How to use Analyze Data in Excel (AI Creates Pivot Tables and Charts)

Data analysis in Microsoft Excel has just gotten a LOT easier. A feature called "Analyze Data" uses AI (artificial intelligence) makes this process simpler, faster and more intuitive. This feature used to be called IIDEAS in Excel but it was renamed to "Analyze Data". It automatically creates pivot tables for you so you don't even need to think about what to put in the rows and what to put in the columns of the pivot tables. You'll get pivot table and chart suggestions which you can immediately use. You'll also get data insights you might not be actively looking for which could be important for your analysis. This tool simply makes analyzing data in Excel really easy.

Requires Excel for Microsoft 365.

00:00 Data Analysis Made Easy with Excel AI
00:23 Analyze Data with AI in Excel
03:02 Automatically Create Charts by Asking Questions
04:36 Use Natural Language to Get Insights Into Data
06:42 Update Insights When Data Changes
07:46 Wrap Up

🎬 LINKS to related videos:

🚩Let’s connect on social:

This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel #ai

[richardlibby]

Once again, Leila doesn’t disappoint us with her knowledge 😊

[Stan_sprinkle]

How timely. I finally started playing with this just last week. Go figure Leila reads my mind and posts a video on it.

[samrathna]

I played around this tool when I saw it. But I learned bit more by seeing your video. Thank a bunch

[aaronag]

Just an idea for a future video
I'd like to see you "Do your magic" on subscribers own sheets. You ask subscribers to send in their sheets and you show what could be done to improve their processes and functions.

[steinanderson]

your smile makes it quick and painless

[Micktunz]

Thanks for the tips, Leila. Just to add, I believe a vb code can be used to automatically refresh the pivot tables whenever the source data changes.

[sesughyaji]

Awesome. You deliver your sessions in the most effective ways. Very interesting, easy to follow and focus through it. Your videos are of massive help to me. Well-done.

[jerg]

The best content on Excel topics. ❤🔥🙌🏼

[bigboldbicycle]

This is crazy useful. I've seen that natural language query feature in PowerBI but didn't realise it's also available in Excel. Thanks!

[shivamrai]

I HAVENT COMPLETED WATCHING BUT I ALREADY LOVE IT.

[FilmGrouch]

Where has this been my whole life? Very cool!

[WilfEsme]

Not only is this video helpful, but you've made an excel tutorial less boring. AIs are really helpful indeed. I'm using Bluewillow recently to induce an idea and lessens the mental block in generating visuals and designs.

[theamaze]

Thank u ma'am. Big fan of yours from India

[anindadatta]

But "analyze data " feature is not available in most excels, is it to be bought separately as an add in? We use tableau for all this kind of work

[yungkreuz]

The most insightful video I've ever watched since the beginning of 2023
Thanks a million for that 🤩🤩🤩

[tricksntales]

Nice video like please provide some alternatives to your solutions for old excel users india specifically, we don't throw the old things as soon as new things come in market, instead of that we repair them and use them keeping that in mind, we still have previous versions of excel (mostly 2016 or 2019) so please make sure that you provide trick to do the same work in those old versions too, as most of these options are not available in previous

[isaacmwabila]

Thank you Leila for always share with us these new Excel options!
You're the Best!👌🏽👏🏾

[borstenpinsel]

I did this on a data Set a few months ago. Excel delivered 30 some graphs , most of which were pointless for my use case (like the first column was some ID and excel showed me the sum). A bunch were really obvious but I knew the data already so... on completely foreign data it might have been cool. 3 or so insights were unique. 2 of them again useless but at least unique and something that wasn't immediately obvious. And what's really cool for the management level who always asks for graphs but doesn't bother reading them: excel out the quintessential result as a heading to the graph. Something which is hard to automate even with macros, without manually adding a ton of cases. This is really a task that I can see AI doing for me in the future. Write a heading and 2-3 sentences about the analysis I created. And I just need to proofread it before sending it out.

[silverlicious]

Nice demonstration. Best wishes from Cincinnati USA

[samr]

Thank you for sharing this feature, Leila! I credit you for many of my Excel skills...I appreciate you!❤️