Excel AI - data analysis made easy

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to use Artificial Intelligence or A.I. in Microsoft Excel to easily and to quickly analyze your data.
📚 RESOURCES
- Excel for Beginners Course - Go from Excel Novice to Data Analysis Ninja in just two hours: kevinstratvert.thinkific.com/
- Sample Excel workbook to follow along: 1drv.ms/x/s!AmxrofZZlZ-whYI8i...
- Article that walks through AI in Excel: kevinstratvert.com/2023/01/07...
⌚ TIMESTAMPS
0:00 Introduction
1:03 Analyze Data to use AI
1:53 Ask questions about data
3:35 Get insights and see trends
4:52 Refine questions
5:39 Shortcomings
6:32 Automatic insights
7:17 Best practices
7:33 Wrap up
📺 RELATED VIDEOS
- Playlist with all my videos on Excel: • ❎ How to use Excel
📩 NEWSLETTER
- Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
🔽 CONNECT WITH ME
- Official web site: www.kevinstratvert.com
- LinkedIn: / kevinstratvert
- Discord: bit.ly/KevinStratvertDiscord
- Twitter: / kevstrat
- Facebook: / kevin-stratvert-101912...
- TikTok: / kevinstratvert
- Instagram: / kevinstratvert
🎒 MY COURSES
- Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/
🙏 REQUEST VIDEOS
forms.gle/BDrTNUoxheEoMLGt5
🔔 SUBSCRIBE ON KZbin
kzbin.info?...
🙌 SUPPORT THE CHANNEL
- Hit the THANKS button in any video!
- Amazon affiliate link: amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
#stratvert #excel #ai

[@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 🙂

[@prashanth9309]

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

[@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.

[@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

[@tcthio336]

Great tutorial on this feature. Thanks Kevin

[@tina_kulp]

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

[@edimethesecond]

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

[@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.

[@EdHohlbein]

Incredibly helpful! Thank you, Kevin!👍💪

[@drdadaa]

yeah

[@kuroramen2451]

Very helpful, thank you Kevin!

[@raphgomess]

This is insane! Thank you so much Kevin

[@mohamedyusuf8631]

Very helpful. Thanks Kevin

[@videostok2452]

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

[@juliamarsh2077]

Thank you for your clear examples.

[@triptabhattacharjee7004]

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

[@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.

[@Jo-xu2vi]

Thank you for this another awesome video 😊

[@markandrow4010]

Thank you, great review.

[@nichellesgems4558]

Thank you for these time saving tips 🎉

[@donaldbanda3578]

Amazing, thank you once again ❤

[@wassup406]

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

[@uzomaemerie]

Mind blown...awesome, Thanks

[@supaschokobear]

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

[@1029skatingirl]

Thank you. It's amazing

[@bane2256]

The quality of these videos is off the charts Get it

[@bejukacarlson6454]

Hello Kevin. I love your videos. They have helped me improve alot. Please could you help me with a video explaining simple ways to link tables on Power Bi in order to make reports? Thanks.

[@aniketsingh6995]

Unable to get analyze data option

[@adeyemiolushola3156]

Thank you Kevin for sharing

[@KevinStratvert]

Very welcome!

[@SUSANTHTP]

This is really mind blowing......

[@olegmalinko777]

amazing, thank you!

[@hosseinselki]

Great job❤

[@rhonalkhairul3969]

nice sharing, thanks a lot

[@haderyehia8744]

wonderful .. great work .. thx..

[@pavlenikolic3555]

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

[@AgusSalimMaksum]

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

[@user-kb5mc6sp7b]

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.

[@PAPAPTV101]

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

[@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?

[@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.

[@muroojh4567]

This is amazing 😍

[@ardinouayoue7055]

Mind blowing!!!

[@Kelvynator]

Awesome

[@enna2023]

Great ❤

[@dmail44]

Also the search bar.... u can type what u want, it gives the option u need, without needing to remember which tab the option is in

[@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.

[@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!

[@syedikramullah1114]

It's amazing

[@hosseinselki]

Great❤❤❤❤

[@KP-ky1sn]

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

[@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!

[@sajjadkazi1806]

cool stuff

[@empowermentchronicles5257]

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

[@jonasrigodon3026]

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

[@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.

[@muhammadrafiqakhtar4566]

Excellent - maa sha Allaah Honorable Son Kevin Stratvert.

[@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?

[@navinahmed9642]

For more flexibility and analysis, just insert the excel file into powerBI. That's more specialised in the above works!

[@Migatwin]

Merci !

[@khurramshehzad1217]

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

[@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!!!

[@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)

[@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 ?

[@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?

[@Taulsky]

Nice😎

[@impibibi403]

I love you. thank you. omg

[@EthosLegos]

Hi Kevin, Could you please do a video on Outlooks email causes of showing “(Not Responding” and or freezes? Mine also has a “(Unlicensed Product)” message even though it’s from my university. Thank you and keep up the great content and have a happy new year.

[@theskeletonboi]

1) Make sure you're signed out of other accounts in Excel, it could be trying to pull the license from the wrong account. 2) Run Outlook in safe mode (Win + R): outlook /safe If it runs here it's a good sign, follow the below steps 3) Uninstall Office 365 completely (restart the computer) and re-install 4) Create a new profile and set it as your default in Outlook 5) Create a new data file, and set it as your default, allow it to catch up and sync 6) Still not working? Repeat step 3, but also delete the Office folder from your program files (x86) and regular after uninstall.

[@MrTalhakamran2006]

nice video

[@curtsoulonline]

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

[@krinodagamer6313]

Nice!!! I will see how my desktop ai is functioning

[@andydidyouhear]

After watching a video, I started seriously wondering whether it’s still worth taking Excel courses. If an AI assistant can handle complex tasks, why bother learning complicated formulas? Wouldn’t it be like using an abacus in the age of advanced calculators? Some say that learning Excel can still be a valuable and practical skill for many professionals. But beyond the basic level, how is that the case?

[@surrealmedianl]

Awesome. Do you know how / where on Mac?

[@Jko282]

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

[@maitseasi]

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

[@mukulrawat8113]

Wher ecan i find the Analyze data section. Plz tell..

[@Phoenixspin]

This guy is slick, almost too slick.

[@RiffatAhmed-vn1sv]

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

[@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.

[@dank8041]

Hi Kevin. Is this feature available in Excel 2013

[@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 =)

[@BarkhaMusic]

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

[@ALEXMBUGUAKIRAGU]

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

[@priyanshubegwani4211]

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

[@sekolahdata]

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

[@gajendrasingh9486]

Which Microsoft excel version have this icon ..analysis data

[@DoctorIgnacio]

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

[@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"?

[@Dy1z]

Student in a data anayltics college course, ive taken two classes and none of the teachers have mentioned this tool.

[@josephorinday489]

Hi, is it possible to get data from an excel file attachment in an email to MS Access?

[@yoanperez172]

From which excel version this feature is available?

[@askaleabrhaley3899]

How to add to my excel 2016 the data analysis plugin

[@ahmadjunaid3204]

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

[@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

[@phoneoperator]

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

[@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

[@bernardfrimpong4551]

Please can you make a video on how to add in pixton in PowerPoint. I’m using PowerPoint LTSC 2021 and the pixton is not able to load or pose the pictures I create.

[@user-sp3pt6uo2c]

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

[@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?

[@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??

[@agatambidibalakrishna3734]

Can we apply AI in excel for weather data?

[@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