Use AI in Excel to Analyze Data with ONE Click

Analyze data in Microsoft Excel will provide you with immediate insights about your data. It uses artificial intelligence to quickly create summary reports and high-level visualizations. You can even directly ask it questions about your data using "normal" conversational language. Analyze data, is the new artificial intelligence feature built into Excel. It does a really good job in analyzing your data and giving you a summary.

Analyze data/Ideas feature is available in Excel for Office 365.

Simply click a cell inside your data range, and then click the Ideas button on the Home tab. Ideas in Excel will analyze your data, and return interesting visuals about it in a separate task pane.

Save time and narrow down your Ideas by selecting only the fields you want to see. You can also provide feedback about which fields are helpful to you and which are not. This way the system learns and will present fewer, more targeted suggestions in the future.

🚩Let’s connect on social:

Note: 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

[LeilaGharani]

"Ideas" was renamed to "ANALYZE DATA" in Excel.

[mcd]

This presentation was like watching a child open a present on Christmas morning. The excitement and enthusiasm you bring to these videos set you apart from the typical instructor.

Also the hair coloring is on point!

[anastasiasentyurova]

This is a completely new level of working in Excel! WOW. I am so impressed. The question is how soon the majority of us will start working with MS Office 365..

[iamindian]

Never understood how powerful this feature is until I saw this video. Thank you

[estivisonmc]

Woooow!
Search in that data was made better than using SQL! it was used natural language. That's is simply amazing!!!

[stephengibson]

So good. I did this with some real data from work today, and found it quite helpful. I’m going to use this more often. Thanks.

[mojeedasade]

Hi Leila, your tutorial is very good and interesting.

[owaiesmulla]

what an IDEA!!! Excel nails it everytime it updates. Thank u for highlighting this feature, i had no clue at all it was actually there in excel and your demo makes the feature looks just amazingly live saver. Cheers

[chh]

" … super quick start …"
From a super good video … an excellent feature … excellent presentation … no surprise to me … Perfect timing … I will 'test drive' this morning.

Thank you.

[Top-Ten-]

BIG LIKE, even before watching the video. Leila is the Best excel teacher ever.

[Riskninjaz]

Thanks Leila. Work smarter not harder!!!!

[NamanArya]

Thanks for talking about this amazing tool Leila. I hate it that Excel normal versions 2016, 2019 don't have such features!!

[istiaktuhin]

Leila Gharani You are doing great work. 100% professional

[DrSmoke]

I love this video. I can't believe excel has advanced so much!!

[unigirl]

I saw the Ideas function but was afraid to use it or didn't know how. Thank you and thank you that this video comes right in time when I need it.

[KamiraXIV]

To those that come in to this video over a year later: "Ideas" is now called "Analyze Data"

[rasoulkhoshravan]

Very good feature. AI is entering to ordinary software like Excel. This is amazing. But your office should be 365. Would be great if we could add it to older Excel versions as an add-on.

[anandabherath]

Google Sheets has had a similar but a bit more powerful feature - Explore - for quite some time now, quite ahead of Excel introducing 'Ideas'. It is good that Excel has followed suit.

[Betterifitsfree]

Wonderfully explained. But when Leila talks soft or whispers, my head spins and I get like a dizzy sensation. I love it. 🤯

[robertflynn]

Thanks Leila, I had not yet tried the Ideas function but after your video I can see it is yet another gem that you have uncovered for us!