Excel AI - data analysis made easy

[@KevinStratvert]

🎒 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com 📊 Master Pivot Tables in Excel to analyze data just by clicking and dragging and dropping your mouse: kzbin.info/www/bejne/hpWtq6xvapuqpZY 📚 Article that walks through AI in Excel: kevinstratvert.com/2023/01/07/how-to-unlock-the-power-of-ai-in-excel/

[@bogdansas2277]

Hi Kevin, Is this a new feature? Which versions of Excel have this? Is it only in Excel 365? If Excel 2021 permits, could you make a short tutorial on how to install this add-in? Thank you!

[@dirkfinger6119]

I would like to have this information too please 🙂

[@MihaiGoRunning]

Hey Kevin, I just watched your tutorial on using AI in Excel and it blew my mind! I had no idea it was even possible to analyze data so easily and quickly. Keep up the great work!

[@KevinStratvert]

Fully agree, it makes Excel so easily accessible now.

[@bane2256]

The quality of these videos is off the charts Get it

[@MohitSingh-jd7jr]

Hello .This is Mohit from India .Just saw your video on how to convert word document to pdf .Thankyou for all your videos.Looking forward to learn alot from you.

[@tina_kulp]

You are the best, my go to for learning on youtube!! Thanks for all you do!

[@prashanth9309]

I recently discovered this channel, Kevin's content is absolutely best and underrated channel.

[@aniketsingh6995]

Unable to get analyze data option

[@empowermentchronicles5257]

Dear Kevin, In my excel window, analyse data option is not available. What to do?

[@DoctorIgnacio]

hi, my excel does not have the analyze data button, am I missing a video or something?

[@abdulrhmanaidross8605]

Analyze Data is available to Microsoft 365 subscribers

[@waltergrapa]

Hello Kevin! I don't seem to have "Analyze Data" icon/option like the one you have. How can I get this function? I have the Data Analysis function, but it is not the same with the one you have? Thank you!

[@abdulrhmanaidross8605]

Analyze Data is available to Microsoft 365 subscribers

[@videostok2452]

Bonjour Kevin, Thanks a lot for efforts. 've a good one

[@krishnakanth7493]

Hi, I am using Excel in MacBook Pro and How do i activate the Analyze Data option? I have selected the Analysis Tool Pack add-on. please help and thanks for your time.

[@MomCareMoments]

Is this feature in all versions of excel? mine seems not to have the analysis feature activated. How do you activate analysis feature?

[@misterprozilla2293]

It looks like it's only for paid accounts - visible on my work account but not my personal account (both in the web version)

[@abdulrhmanaidross8605]

Analyze Data is available to Microsoft 365 subscribers

[@Jko282]

I dont have that button "analyze data" is that a plugin you've downloaded?

[@PAPAPTV101]

hello kuya kevin hope to see you in person your such a good man and a kindhearted person

[@ALEXMBUGUAKIRAGU]

i cant find the excel ad in or the analyze in my excel?

[@antarctico76]

Hi Kevin, great job, I love your videos! Unfortunately the Analyze Data in my excel365 is not supporting the specified chart type for this scenario! Some hint?

[@JatinderSingh-rf3ri]

Is it available in Excel 365 web? IF YES THEN HOW CAN I GET THAT??

[@draftlinemaz5623]

Hi Kevin. IDK how to activate the command prompt option on the Analyze data tool. Can you make a video explaining how to activate that searching bar? which is your excel version? Thanks

[@hyannwaldschmidt5377]

same issue here. Where can we active it?

[@kirubagaran5132]

Did u find the solution

[@kirubagaran5132]

​​@@hyannwaldschmidt5377 did u find solution

[@yoanperez172]

This video is amazing, I have been working with excel for years and this tool look like it can save a lot of time.

[@juliamarsh2077]

Thank you for your clear examples.

[@pavlenikolic3555]

Kevin Stratvert is the most realistic Human Bot that we have ever seen.

[@ravengorospe8398]

hi. how can i find the analyze data button on excel? i have checked all even the add ins, i only have data analysis button under data tab

[@ismailtechy3457]

It's already been in home>to your top right end(Analyze data)

[@SiddharthBose-c5m]

One of the best videos, I watched in a long time. Please let me know if there is a possibility to integrate other external AI data analysis tools within MS Excel? Thank you.

[@MsMe-zo2uo]

Thanks big help.. as always❤

[@markandrow4010]

Thank you, great review.

[@moneysensemap]

You are a fantastic teacher! Super happer happy that I've found your channel. Thank you so much for doing this for us. Much Love from UK

[@raphgomess]

This is insane! Thank you so much Kevin

[@JJ_TheGreat]

7:49 Cool! Looks like this is a feature which came from Power BI. Is this a new feature? Which versions of Excel have this? Is it only in Excel 365? As an Excel 2021 user, I would like to see whether I can take advantage of this. If not, I could always transfer it to Power BI and do this AI analysis there.

[@AkshayKumar-vd5wn]

Some features are present in power BI which I have noticed.

[@heartlin5875]

this feature doesn't work in excel 21 toy have to use 365

[@AgusSalimMaksum]

Wow I can't believe it, it's amazing for me 😎😎

[@joen5000]

I have office 2021, and I can't add this Analyze Data tool. There is no such a data analysis tool. It appears though in the add-ons, but it's impossible to add it.

[@abdulrhmanaidross8605]

Analyze Data is available to Microsoft 365 subscribers

[@hosseinselki]

Great job❤

[@bolajiadedasola6369]

Thank you so much for all your videos. I have a question. Please how did you activate the AI on your excel, mine seems not to have the feature activated.

[@mikexue5104]

maybe he is using O365 version, in my Excel 2021, there is NO such 'analysis' menu.

[@tanvisondur7019]

I am using Excel 2021 but I am unable to find the option of Analyze Data. How can I get that option in my excel. Can you please suggest it ?

[@dearlokennedy8775]

@tanivondue7019 did you receive an answer to your question?

[@abdulrhmanaidross8605]

Analyze Data is available to Microsoft 365 subscribers

[@samworks]

Is this function available for the one payment version of Excel or just for the 365 subscription?

[@charlesxix]

Just 365 :(

[@edimethesecond]

Kelvin!!!! Wow! Just wow! Thank you for this. I just subscribed 👏

[@SindhiSaazOfficial]

Can you please tell which version of office it support because I can find in my office

[@aseel6910]

analyze data not showing in excel , any suggest to solve this ?

[@kristoffermohr2102]

i have the same problem...

[@SUSANTHTP]

This is really mind blowing......

[@KP-ky1sn]

Total revenue minus total cost = gross profit. Awesome content again.

[@chadvlad69]

I can't find it and i have a microsoft365 account, can you help me?

[@rhonalkhairul3969]

nice sharing, thanks a lot

[@surrealmedianl]

Awesome. Do you know how / where on Mac?

[@hmartin3351]

Hello Kevin, I don't have the question bar over the analyze data that's normal ? I use the french version of Excel 365 install on my destop. Thanks for all !

[@Irulan10]

Same here...

[@KevinStratvert]

The natural language query capability is currently only available in English. Hopefully it'll roll out to more languages soon.

[@Irulan10]

@@KevinStratvert Thanks Kevin :)

[@haderyehia8744]

wonderful .. great work .. thx..

[@tcthio336]

Great tutorial on this feature. Thanks Kevin

[@donaldbanda3578]

Amazing, thank you once again ❤

[@jonasrigodon3026]

Hi Kevin, Your tutorial is very useful to us. Could you please share the excel data set so that i can practice?

[@Jo-xu2vi]

Thank you for this another awesome video 😊

[@triptabhattacharjee7004]

Best video of the day for me! Thanks a lot.

[@uzomaemerie]

Mind blown...awesome, Thanks

[@osamaalsaraqbi]

thank you very much very nice my explain

[@nichellesgems4558]

Thank you for these time saving tips 🎉

[@ahmadjunaid3204]

how can i download this excel version because in my excel this option is not available

[@EdHohlbein]

Incredibly helpful! Thank you, Kevin!👍💪

[@drdadaa]

yeah

[@ChituOkoli]

Great video! And thanks for sharing your super-confidential Kevin Cookie Company sales data with us so that we can follow along. Don't worry--I won't share it with anyone.

[@theappleshorts]

Can we say it is good?

[@KevinStratvert]

it's actually solid. You can skip over writing formulas / functions and using pivot tables for most common queries.

[@MARKHIXSON-u2q]

I don't have that button on my excel. How can I get that?

[@mohamedyusuf8631]

Very helpful. Thanks Kevin

[@endrisyimeradem1799]

Is the excel sheet embedded with AI features?

[@kuroramen2451]

Very helpful, thank you Kevin!

[@ibrahimamirbek1114]

How to implement or download it????

[@wassup406]

very useful as always, learn a lot from your videos,kep up the good work 👍

[@hosseinselki]

Great❤❤❤❤

[@1029skatingirl]

Thank you. It's amazing

[@excellover7172]

Do we neee to convert our data into table to use this?

[@KevinStratvert]

No need to be a formal table, although it helps to have a single header row.

[@adeyemiolushola3156]

Thank you Kevin for sharing

[@KevinStratvert]

Very welcome!

[@sinhaSaurabh2]

@@KevinStratvert Hey i dont have the analyze option in ribbons?

[@Indjudgement]

Sir can I install audacity software in i3 processor laptop for voice editing?

[@techbrewed]

Yes it will work fine

[@nlg062701]

ok, I am sure I missed a video explaining what I am about to ask. Where do I find the "Analyze Data" button? mine is not where it shows on this screen. I assume that I have need an "Add In"?

[@enna2023]

Great ❤

[@khurramshehzad1217]

Your speaking style is impressive, love from Pakistan 🖐🖐🖐🖐

[@ramnaslai2980]

Awesome tool...now what is the use of power BI

[@KevinStratvert]

Power BI is really good for building reports and visualizing your data and makes sharing with others really easy. Here's an intro video: kzbin.info/www/bejne/ip7LgnaHp8R3eaM

[@nzznvm]

The button on the ribbon says 'Add-ins', not 'Analyze Data'. Which add-ins are you using?

[@phoneoperator]

do you need a specific version of excel? I don't see this in my ribbon

[@Kelvynator]

Awesome

[@muroojh4567]

This is amazing 😍

[@RiffatAhmed-vn1sv]

please can you tell which ai you use to analyse data , i cant find this option on my excel sheet.

[@supaschokobear]

Great Kevin. I had no idea that could be done with Excel😀

[@curtsoulonline]

Could you update product prices on a spreadsheet to match a website with the AI?

[@a47mlb]

Why do I not see the Analyze Data button in the Home tab? Is it an add-on, or is there something else that's needed to enable the feature??

[@purvidaga2646]

Hi Kevin, my "Analyse data" is showing blank space only. Can you please help?

[@priyanshubegwani4211]

how do i get the analysis data option in my home tab in excel?

[@AbuSayed-ls3iu]

Hi kevin, thank you for sharing. But when I am working large number of cells & row then it's not working. How can I solve this ?

[@murtuzashabbir1259]

Hello Kevin.... thank you for sharing your knowledge.....I have tried using Analyse Data but it does not work for the data that is huge....any idea how can I use that.... Thank you!!

[@nomansultan4469]

Have you got an answer?

[@EnglishwithSbeata1]

why can NOT I see this function. in my excel? I fell almost crying when I found out :(

[@abdulrhmanaidross8605]

Analyze Data is available to Microsoft 365 subscribers

[@sekolahdata]

how to display add in analyze data in excel online? thanks

[@essamelgenedy]

Hey Kevin. Your videos are awesome and helpful. Many thanks for that! Just I want to know why Automate button not on my Excel 365. Also try to talk about Google Sheets/Docs with ChatGPT in summarizing/rewriting text. For example if I want to turn the text to third person format, like Mr. X stated so and so instead of Mr. X: I’m so and so. Also how to handle long text in ChatGPT or even through Python code to work on it as chunks if can’t work on the whole text. Cheers!

[@muhammadrafiqakhtar4566]

Excellent - maa sha Allaah Honorable Son Kevin Stratvert.

[@maitseasi]

What!? I did not know that Timothy Olyphant is schooling people on the benefits of AI. Solid!

[@amar.gupta_]

From where I can get the analyze data tab?

[@nelson9ce]

Wow that's amazing, thank you Kevin

[@abhijitdey1819]

Please suggest me where I get this button Analyze data.

[@nidakhan1197]

​@@abhijitdey1819 did you figure it out?

[@pattiflannagan7151]

Kevin: This is awesome! I'm looking to find out what questions I can ask of the Excel data? I've google(d) galore, but I can't find a reference. It's a powerful tool, that's still a mystery due to lack of documentation about question types, chart type, etc. Can you provide a reference ? Thanks!!!

[@ula7156]

thank you for the video! I don't know why I feel like the video looks like a documentary film ))) may be because of the high quality of the video =)

[@gajendrasingh9486]

Which Microsoft excel version have this icon ..analysis data

[@Phoenixspin]

This guy is slick, almost too slick.

[@Khushwantsingh_Vlogs003]

Hey i want to ask one question it may be feel silly but its important to me as i am a beginner does Davinci resolve free ios version work nicely in ipad pro m1 please reply

[@rongsilas9106]

Very interesting! Though I don't use pc, i only use Android phone for personal use and i love it! Thanks to you. I learnt it from you.Can you please explore more features of it in Android phone? Of course the free version! ☹️

[@davidferrick]

Use yoru Android with DEX and it basically converts your phone to an Operating SYstem. I use my Android with a USB powered portable monitor, USB keyboard and mouse and Voila!

[@nm3547]

@@davidferrick ?

[@jameskaranja5959]

Very helpful. Is this available in Microsoft 2010? Seems I can't find the 'Analyze data' button

[@paddercreations6423]

It's not available.

[@alikarimi1987]

I cannot find Analyze Data in home ribbon in Exell 2021. where on earth is it?

[@jessmac2379]

what version of excel is that @1:55?