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

How can install Analyze data in home tab

❤🎉

that is awesome but how can I get this icon in my excel sheet. I couldn't find it.

I am using Excel 2021 but I am unable to get the option of Analyze Data. Can you please tell me from do I get this option activated ?

Ma'am how to activate the data analysis option on MS excel 2021 please kindly make a video on it..

Just what I needed, perfect :)

Hi Leila, thanks for all great training videos you are sharing. They are super helpful.
I have a question about this command. I enabled this command in my Excel 365 Home tab but it is grayed out. What should I do? I tried everything to make it work but no success yet. Thanks in advance!

Another great Vid Leila 🙂. Suggestion to make it even more interactive is provide source data so we can try it ourselves , also likely to push your average viewing time up which should also impact your revenue stream. Moving onto your power BI dashboard

I don't have analyze data option in my excel I use 2021 version MS office

GAH! I'm finding this video a week too late bc I was asked very similar questions recently. Oh well, this is a fantastic video that I will be referencing the next time I get these questions. Thank you. 😊

How to enable that option

Great content as the usual, thank you for that. Quick question: I don't have this feature "Analyze Data" or "Ideas" in my Excel, how do I get it?

Hi Leila, is this feature available in Excel 2019? can't find it, I'm a Planning Manager and analyzing data is one of the most important tasks in my role, thank you for sharing your knowledge, your Awesome!

Custom formatting to obtain engineering exponential, I,e., as multiples of e. E.g., 1E-6, 23E-9, 123E+3, ...

Hi, i use excel versio 2021 but this features not appear !

I dont see this option (Office PP 2019)

Bruv. Thank you so much for demo-ing this. Super helpful... And it's right there and never thought to click it lol

Madam please help me. I can't find out the Analyze data button in my excel.

This is wonderful

Omg this is going to save me so much time!!!

Leah I don't have the Analyze Data Button

I can find the analiza data option, but there is no query box to type my question in

how to add analyze data in excel?

Does anyone know how to enable the ribbon once it is Added to the home tab?

I am using excel 365 but analyze data option is not showing in home tab

QUESTION FOR YOU. DO ALL YOUR EXAMPLES REQUIRE USE IN OFFICE 365? WILL ANY, OR SOME, WORK WITHIN THE OFFICE INSTALLED ON MY LAPTOP?? THANK YOU.

Thanks for the video Leila. But I didn’t get how to get started on this? Is this the newer excel version?

How to activate this option in excel 2021??

how do I get this button on excel

Is this option available for free account ? If yes, can anyoneplease share the steps to activate.

I was excited to use this feature after watching Leila's video on How to use Analyze Data. However, no matter where I look for help, I cannot get a version that she is showing (not even the same icon) for my Excel 2016. I would gladly take a course if that would be included

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

Data analytics diva. Salam alykum❤

Hi Leila,
is it possible that Analyze Data feature is only available for english version of Excel? I noticed, i was missing the feature even tho I am an Office Insider. When i switch to an english language pack however, the feature suddenly pops up. If you know anything about the matter I would really appreciate your expertise.
And also - many thanks for all the awesome work you put in to educate us and make everyone EXCELlent :))

how to add this feature 'analyze data' into excel?

pls provide workbook for practice too, thanks

The God of Excel 😄 perfect as usual

If you see that email, you are working for a Tobacco company which means you have made some pretty poor choices in your life and need to make some changes.

Hello!!!
How to include the AI Analyse tab under the Home tab?

What year Excel does it? 2022? 2023?

I don't find the ANALYZE DATA under ANALYSIS section. The ANALYSIS section is empty no buttons, are these options I am using excel 2021?

Wow! Thanks a lot!

Perfect, please share data file for practice

This feature for 365 only

Best excel teacher.

❤

Hi mam, this is available in excel013

❤❤❤❤

I really like your video recommending this function, but if I have 800k rows of data and the analyze data prompts "You may have too much data picked to come up with meaningful suggestions, try selecting a smaller set of data and trying again." 🥲