Excel AI - data analysis made easy

  Рет қаралды 494,869

Kevin Stratvert

Kevin Stratvert

Күн бұрын

🔥 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 KZfaq
kzfaq.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

Пікірлер: 266
@KevinStratvert
@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: kzfaq.info/get/bejne/hsp6rdxqmpzbn2g.html 📚 Article that walks through AI in Excel: kevinstratvert.com/2023/01/07/how-to-unlock-the-power-of-ai-in-excel/
@bogdansas2277
@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
@dirkfinger6119 7 ай бұрын
I would like to have this information too please 🙂
@MihaiGoRunning
@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
@KevinStratvert Жыл бұрын
Fully agree, it makes Excel so easily accessible now.
@moneysensemap
@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
@yoanperez172
@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.
@prashanth9309
@prashanth9309 Жыл бұрын
I recently discovered this channel, Kevin's content is absolutely best and underrated channel.
@videostok2452
@videostok2452 Жыл бұрын
Bonjour Kevin, Thanks a lot for efforts. 've a good one
@raphgomess
@raphgomess Жыл бұрын
This is insane! Thank you so much Kevin
@MohitSingh-jd7jr
@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.
@donaldbanda3578
@donaldbanda3578 Жыл бұрын
Amazing, thank you once again ❤
@tina_kulp
@tina_kulp 3 ай бұрын
You are the best, my go to for learning on youtube!! Thanks for all you do!
@markandrow4010
@markandrow4010 Жыл бұрын
Thank you, great review.
@bane2256
@bane2256 Жыл бұрын
The quality of these videos is off the charts Get it
@tcthio336
@tcthio336 Жыл бұрын
Great tutorial on this feature. Thanks Kevin
@EdHohlbein
@EdHohlbein Жыл бұрын
Incredibly helpful! Thank you, Kevin!👍💪
@drdadaa
@drdadaa Ай бұрын
yeah
@Jo-xu2vi
@Jo-xu2vi Жыл бұрын
Thank you for this another awesome video 😊
@kuroramen2451
@kuroramen2451 Жыл бұрын
Very helpful, thank you Kevin!
@triptabhattacharjee7004
@triptabhattacharjee7004 Жыл бұрын
Best video of the day for me! Thanks a lot.
@edimethesecond
@edimethesecond Жыл бұрын
Kelvin!!!! Wow! Just wow! Thank you for this. I just subscribed 👏
@mohamedyusuf8631
@mohamedyusuf8631 Жыл бұрын
Very helpful. Thanks Kevin
@uzomaemerie
@uzomaemerie Жыл бұрын
Mind blown...awesome, Thanks
@juliamarsh2077
@juliamarsh2077 5 ай бұрын
Thank you for your clear examples.
@1029skatingirl
@1029skatingirl Жыл бұрын
Thank you. It's amazing
@SUSANTHTP
@SUSANTHTP Жыл бұрын
This is really mind blowing......
@nichellesgems4558
@nichellesgems4558 Жыл бұрын
Thank you for these time saving tips 🎉
@wassup406
@wassup406 11 ай бұрын
very useful as always, learn a lot from your videos,kep up the good work 👍
@supaschokobear
@supaschokobear Жыл бұрын
Great Kevin. I had no idea that could be done with Excel😀
@hosseinselki
@hosseinselki Жыл бұрын
Great job❤
@AgusSalimMaksum
@AgusSalimMaksum Жыл бұрын
Wow I can't believe it, it's amazing for me 😎😎
@olegmalinko777
@olegmalinko777 Жыл бұрын
amazing, thank you!
@muroojh4567
@muroojh4567 Жыл бұрын
This is amazing 😍
@haderyehia8744
@haderyehia8744 11 ай бұрын
wonderful .. great work .. thx..
@ardinouayoue7055
@ardinouayoue7055 Жыл бұрын
Mind blowing!!!
@ChituOkoli
@ChituOkoli 10 ай бұрын
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.
@PAPAPTV101
@PAPAPTV101 Жыл бұрын
hello kuya kevin hope to see you in person your such a good man and a kindhearted person
@bejukacarlson6454
@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.
@enna2023
@enna2023 Жыл бұрын
Great ❤
@rhonalkhairul3969
@rhonalkhairul3969 11 ай бұрын
nice sharing, thanks a lot
@Kelvynator
@Kelvynator Жыл бұрын
Awesome
@user-kb5mc6sp7b
@user-kb5mc6sp7b 8 ай бұрын
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.
@muhammadrafiqakhtar4566
@muhammadrafiqakhtar4566 Жыл бұрын
Excellent - maa sha Allaah Honorable Son Kevin Stratvert.
@Migatwin
@Migatwin Жыл бұрын
Merci !
@khurramshehzad1217
@khurramshehzad1217 Жыл бұрын
Your speaking style is impressive, love from Pakistan 🖐🖐🖐🖐
@KP-ky1sn
@KP-ky1sn Жыл бұрын
Total revenue minus total cost = gross profit. Awesome content again.
@hosseinselki
@hosseinselki Жыл бұрын
Great❤❤❤❤
@syedikramullah1114
@syedikramullah1114 Жыл бұрын
It's amazing
@aniketsingh6995
@aniketsingh6995 4 ай бұрын
Unable to get analyze data option
@pavlenikolic3555
@pavlenikolic3555 Жыл бұрын
Kevin Stratvert is the most realistic Human Bot that we have ever seen.
@essamelgenedy
@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!
@nelson9ce
@nelson9ce Жыл бұрын
Wow that's amazing, thank you Kevin
@abhijitdey1819
@abhijitdey1819 10 ай бұрын
Please suggest me where I get this button Analyze data.
@nidakhan1197
@nidakhan1197 2 ай бұрын
​@@abhijitdey1819 did you figure it out?
@dmail44
@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
@navinahmed9642
@navinahmed9642 Жыл бұрын
For more flexibility and analysis, just insert the excel file into powerBI. That's more specialised in the above works!
@sajjadkazi1806
@sajjadkazi1806 Жыл бұрын
cool stuff
@pattiflannagan7151
@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!!!
@adeyemiolushola3156
@adeyemiolushola3156 Жыл бұрын
Thank you Kevin for sharing
@KevinStratvert
@KevinStratvert Жыл бұрын
Very welcome!
@saurabhsinha8406
@saurabhsinha8406 12 күн бұрын
@@KevinStratvert Hey i dont have the analyze option in ribbons?
@impibibi403
@impibibi403 11 ай бұрын
I love you. thank you. omg
@Phoenixspin
@Phoenixspin Жыл бұрын
This guy is slick, almost too slick.
@krinodagamer6313
@krinodagamer6313 Жыл бұрын
Nice!!! I will see how my desktop ai is functioning
@maitseasi
@maitseasi Жыл бұрын
What!? I did not know that Timothy Olyphant is schooling people on the benefits of AI. Solid!
@antarctico76
@antarctico76 8 ай бұрын
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?
@jonasrigodon3026
@jonasrigodon3026 3 ай бұрын
Hi Kevin, Your tutorial is very useful to us. Could you please share the excel data set so that i can practice?
@Taulsky
@Taulsky Жыл бұрын
Nice😎
@MrTalhakamran2006
@MrTalhakamran2006 Жыл бұрын
nice video
@rongsilas9106
@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
@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
@nm3547 Жыл бұрын
@@davidferrick ?
@surrealmedianl
@surrealmedianl 10 ай бұрын
Awesome. Do you know how / where on Mac?
@waltergrapa
@waltergrapa 11 ай бұрын
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!
@ula7156
@ula7156 6 ай бұрын
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 =)
@krishnakanth7493
@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.
@EthosLegos
@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
@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.
@andydidyouhear
@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?
@BarkhaMusic
@BarkhaMusic 11 ай бұрын
Can you please tell which version of office it support because I can find in my office
@curtsoulonline
@curtsoulonline 11 ай бұрын
Could you update product prices on a spreadsheet to match a website with the AI?
@EnglishwithSbeata1
@EnglishwithSbeata1 3 күн бұрын
why can NOT I see this function. in my excel? I fell almost crying when I found out :(
@bolajiadedasola6369
@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
@mikexue5104 Жыл бұрын
maybe he is using O365 version, in my Excel 2021, there is NO such 'analysis' menu.
@prokorshopal4865
@prokorshopal4865 Жыл бұрын
0:00 - Hi KS. 8:12 - 757th like from me. Cheers.
@AbuSayed-ls3iu
@AbuSayed-ls3iu 18 күн бұрын
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 ?
@Dy1z
@Dy1z Жыл бұрын
Student in a data anayltics college course, ive taken two classes and none of the teachers have mentioned this tool.
@RiffatAhmed-vn1sv
@RiffatAhmed-vn1sv Ай бұрын
please can you tell which ai you use to analyse data , i cant find this option on my excel sheet.
@JJ_TheGreat
@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
@AkshayKumar-vd5wn Жыл бұрын
Some features are present in power BI which I have noticed.
@heartlin5875
@heartlin5875 Жыл бұрын
this feature doesn't work in excel 21 toy have to use 365
@empowermentchronicles5257
@empowermentchronicles5257 Жыл бұрын
Dear Kevin, In my excel window, analyse data option is not available. What to do?
@joen5000
@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.
@agatambidibalakrishna3734
@agatambidibalakrishna3734 Жыл бұрын
Can we apply AI in excel for weather data?
@Jko282
@Jko282 9 ай бұрын
I dont have that button "analyze data" is that a plugin you've downloaded?
@nzznvm
@nzznvm 10 ай бұрын
The button on the ribbon says 'Add-ins', not 'Analyze Data'. Which add-ins are you using?
@bernardfrimpong4551
@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.
@tanvisondur7019
@tanvisondur7019 7 ай бұрын
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
@dearlokennedy8775 2 ай бұрын
@tanivondue7019 did you receive an answer to your question?
@dank8041
@dank8041 Жыл бұрын
Hi Kevin. Is this feature available in Excel 2013
@maywanng5614
@maywanng5614 Жыл бұрын
Hi Kevin, thanks for your great you tube for teaching. However, you said there is a link given data for us to learn from your course. Some have and some do not have at all. Just like this there is no link data xls given.
@nlg062701
@nlg062701 5 ай бұрын
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"?
@susilorejo
@susilorejo Жыл бұрын
Hello my name is Susilo from Indonesia, thanks this tutorial
@Khushwantsingh_Vlogs003
@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
@ALEXMBUGUAKIRAGU
@ALEXMBUGUAKIRAGU Жыл бұрын
i cant find the excel ad in or the analyze in my excel?
@murtuzashabbir1259
@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
@nomansultan4469 4 ай бұрын
Have you got an answer?
@draftlinemaz5623
@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
@hyannwaldschmidt5377 Жыл бұрын
same issue here. Where can we active it?
@kirubagaran5132
@kirubagaran5132 9 ай бұрын
Did u find the solution
@kirubagaran5132
@kirubagaran5132 9 ай бұрын
​​@@hyannwaldschmidt5377 did u find solution
@samworks
@samworks Жыл бұрын
Is this function available for the one payment version of Excel or just for the 365 subscription?
@charlesxix
@charlesxix Жыл бұрын
Just 365 :(
@williamknox974
@williamknox974 Жыл бұрын
Noticed you’re using a Mac. The company I work for is transitioning us over the MacBooks and I’m concerned about the excel experience because 90% of what I do is in Excel. Can someone share their thoughts on if I should be worried?
@jameskaranja5959
@jameskaranja5959 Жыл бұрын
Very helpful. Is this available in Microsoft 2010? Seems I can't find the 'Analyze data' button
@paddercreations6423
@paddercreations6423 Жыл бұрын
It's not available.
@sekolahdata
@sekolahdata 5 ай бұрын
how to display add in analyze data in excel online? thanks
@josephorinday489
@josephorinday489 11 ай бұрын
Hi, is it possible to get data from an excel file attachment in an email to MS Access?
@a47mlb
@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??
@mukulrawat8113
@mukulrawat8113 3 ай бұрын
Wher ecan i find the Analyze data section. Plz tell..
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
The best AI for SPREADSHEETS! (2024)
14:01
Jason_CPA
Рет қаралды 18 М.
Please be kind🙏
00:34
ISSEI / いっせい
Рет қаралды 187 МЛН
🌊Насколько Глубокий Океан ? #shorts
00:42
БОЛЬШОЙ ПЕТУШОК #shorts
00:21
Паша Осадчий
Рет қаралды 7 МЛН
Excel Tutorial for Beginners
16:17
Kevin Stratvert
Рет қаралды 1,6 МЛН
Don't Use ChatGPT Until You Watch This Video
13:40
Leila Gharani
Рет қаралды 1,5 МЛН
Master Data Analysis on Excel in Just 10 Minutes
11:32
Kenji Explains
Рет қаралды 1,8 МЛН
Is Excel Dead? Meet the ChatGPT Data Analyst.
9:33
Kevin Stratvert
Рет қаралды 454 М.
How to Increase your Excel Skills with ChatGPT (10x Productivity 😉)
9:30
Introducing Python in Excel
19:01
Leila Gharani
Рет қаралды 1,5 МЛН
7 AI Tools That WILL Make You RICH
12:48
Iman Gadzhi
Рет қаралды 2,3 МЛН
Microsoft Copilot - Excel has forever changed
10:05
Luke Barousse
Рет қаралды 977 М.
В России ускорили интернет в 1000 раз
0:18
Короче, новости
Рет қаралды 905 М.
Ультрабюджетная игровая мышь? 💀
1:00