AI NEWS

It feels Like Magic

Stolen joke of the day>

Quick jump through the newsletter:

1. Can I use AI in Excel or Google Sheets for data management?

2. What could I ask AI to help me with in everyday work?

3. How can AI remove problematic objects from my image?

4. Collectable “Like Magic AI” NFT

Question of the day

Can I use AI in Excel or Google Sheets for data management?

Yes, this is possible, and both Microsoft and Google have started to integrate AI across their tools and are adding functionalities daily. Because of this, you need to be very careful about what version of their tools you are using and update to the most recent (especially with Microsoft).

AI in Excel

You can unlock the full potential of your data with the AI-powered Analyze Data tool in Microsoft Excel. As the leading spreadsheet software, Excel has transformed the way we work with data. Now, with the integration of artificial intelligence, it’s taking data analysis to new heights.

Harnessing AI for Smarter Insights

The Analyze Data tool leverages AI to provide you with deeper insights and understanding of your data. It’s like having a data analyst at your fingertips, ready to uncover trends, patterns, and correlations that might otherwise go unnoticed.

A Step-by-Step Guide to AI in Excel

Step 1: Access the Analyze Data Tool Open your Excel workbook and click on the “Analyze Data” button in the Home tab. This will activate the AI capabilities.

Step 2: Ask Questions About Your Data Type in a question about your data in natural language, such as “What are the sales trends over the past year?” The AI will interpret your query and provide relevant insights.

Step 3: Explore AI-Generated Insights The AI will present you with a variety of insights, including charts, graphs, and summaries, helping you visualize and understand your data better.

Step 4: Deepen Your Analysis You can go further by asking the AI to perform complex tasks like forecasting or finding statistical significance, all without needing to write formulas or scripts.

NOTE: The Analyze Data tool, previously known as Ideas, is available in Excel for Microsoft 365 subscribers. It’s important to ensure you have the latest version of Office to access this feature. The functionality aligns with the same privacy and licensing regulations and is available in multiple languages, including English, French, Spanish, German, Simplified Chinese, and Japanese. If you’re on the Semi-Annual Enterprise Channel, you might still see “Ideas” until Excel is updated.

With the AI in Excel’s Analyze Data tool, you can make more informed decisions faster. It simplifies the data analysis process, allowing you to focus on what really matters - the story behind the data. We give it a 4/5 on LMAI scale just because the functionality is still limited.

AI in Google Sheets

Google Sheets offers two revolutionary new tools: “Explore” and “AI in Sheets” (the second is an extension of Flowshot). These tools are transforming the way we interact with data, making complex analyses accessible to everyone.

Explore: Your Data Analysis Assistant

The “Explore” feature in Google Sheets is like having a data analyst by your side. It uses machine learning to understand your data and provide insights.

Step 1: Open Explore Click on the “Explore” button in the bottom right corner of your sheet to activate the tool.

Step 2: Ask Questions Type natural language questions about your data, such as “What is the average sales for this quarter?” and let Explore do the rest.

Step 3: Gain Insights Explore will offer suggestions, perform calculations, and even create charts based on your queries.

“AI in Sheets” extension by Flowshot: The Ultimate Automation Tool

“AI in Sheets” by Flowshot takes automation to the next level. It allows you to use AI prompts, autocomplete tasks, and even create custom models.

Step 1: Install AI in Sheets Add “AI in Sheets” to your Google Sheets from the Google Workspace Marketplace.

Step 2: Click on “Extensions” in the top menu bar of Google Sheets and Select “AI in Sheets” from the dropdown menu and then click on “Login” to activate the add-on.

Step 3: Use AI Prompts From the sidebar, use AI prompts to generate text, translate languages, summarize feedback, and more.

Step 4: Automate with Autocomplete Teach AI to autocomplete repetitive tasks by providing a few examples, and watch your efficiency skyrocket.

Transform Your Workflow

These AI tools in Google Sheets are not just about saving time; they’re about enhancing your ability to make informed decisions. Whether you’re a seasoned analyst or a spreadsheet novice, these tools will elevate your data game. Be careful, as it might be a bit of work to get it working, and it seems to be more fit for advanced users. Also, this addon is not free and we give it 2/5 in LMAI scale.

A simple tip a day, keeps the boss away!

What could I ask AI to help me with in everyday work?

If you are one of those people who would like to use AI more often to boost your productivity but need ideas on what to ask, here are some prompts you could use. They revolve around daily productivity tasks, information retrieval, and content creation.

1. Summarizing Information: Users often ask for concise summaries of news stories, documents, or web content.

2. Drafting Content: Requests include drafting emails, reports, or outlines on specific topics, with instructions on tone and references.

3. Data Analysis: Prompts for analyzing data or explaining complex concepts in simple terms are common.

4. Research Assistance: Users seek help with product research, finding deals, or performing deep searches for thorough information.

5. Creative Writing: Generating poems, stories, or creative content based on certain themes or keywords is also popular.

Try these out for fun, and very quickly, you will start seeing use cases in your daily work tasks. Also, follow LikeMagisAI.com for step-by-step use cases and tool reviews.

Photo & Video

How can AI remove problematic objects from my image?

Yes, man!

Meet Cleanup.pictures, the AI-powered tool that effortlessly removes any unwanted objects, people, text, or defects from your images. Whether you’re a professional photographer, a creative agency, or just looking to perfect your personal photos, Cleanup.pictures offers a seamless solution to enhance your visuals.

A Step-by-Step Guide to Using Cleanup.pictures

Step 1: Upload Your Image Start by visiting the Cleanup.pictures website and upload the image you want to retouch. The platform supports various formats, ensuring compatibility with your existing workflow.

We uploaded an image that we wanted to use for our newsletter, but it already had text integrated into it. We wanted to remove it so that we could add custom text. This also works great if you want to edit meme pictures by adding your own punchline instead of the original.

Step 2: Select the Object Using the intuitive interface, simply click or tap on the object you wish to remove. The advanced AI technology will recognize and highlight the unwanted elements. You can use the free version of this tool and edit in smaller resolution (720p), but if you need the image in high resolution, pricing starts from $3/month.

Step 3: Watch the Magic Happen With just one click, the AI will process your image, removing the selected object and reconstructing the background with incredible accuracy. What’s left is a clean, unblemished photograph.

Step 4: Download Your Perfected Image Once you’re satisfied with the result, download the edited image in high resolution, ready to be used for any purpose - from professional portfolios to social media posts.

Unleash Your Creativity

Cleanup.pictures is not just for removing blemishes; it’s a tool that empowers your creativity. Reimagine your photos by eliminating distractions, enhancing product shots for e-commerce, or creating the perfect profile picture. With Cleanup.pictures, the possibilities are endless.

Experience the future of photo editing today with Cleanup.pictures – where your images are only limited by your imagination.

Calling for Your Feedback 🫱🏻‍🫲🏻

As the LikeMagicAI.com community grows and matures, we would love to be a place that really serves your best interests and is fun to be part of. That's why we are calling for your help. Please feel free to contact us at [email protected] with questions and themes you would like us to feature in the newsletter. Let's shape our platform and community together🙌🏻

Like Magic AI NFT 🏞️

Our master plan is to publish an NFT image in each newsletter and hand it out to our subscribers. The earlier you subscribe, the smaller the series are. It's a future collectible, a piece of digital art that captures the essence of this moment in time.

Thank you for being a valued subscriber. Together, let's embrace the magic of AI and creativity!

Was this email forwarded to you? Sign up here 👇