10x your productivity with these AI tools in Excel 😲
580,498
Published 2023-02-27
In this video, let me share of 5 of my favourite AI features (plus a bonus one) in Excel that really save time & make you more productive!
Learn all about the AI features in Excel like Flash Fill, Column from examples (Power Query), AI automatic analysis of data, Recommendations, AI formula writer & Automatic forecast with real world examples.
0:00 - Forget ChatGPT
0:34 - Feature 1 - Flash Fill 🦸♂️
2:19 - Feature 2 - Let Excel write the formulas 🧪
6:00 - Feature 3 - AI Automatic Analysis of Data 🤖
10:01 - Feature 4 - Recommendations in Excel 🆘
12:26 - Bonus - Formula writer in Excel ⌨
15:03 - Feature 5 - Forecasting in Excel 📈📈📈
17:59 - More AI 😎
~
📂 Download Sample File
======================
Learn more about these concepts here 👉 chandoo.org/wp/top-ai-features-in-excel/
Need to practice these concepts in Excel? Try with my sample data file here 👇
chandoo.org/wp/wp-content/uploads/2023/02/Excel-AI…
🚨 COMPATIBILITY
================
While the AI features are exciting, they don't work in all versions of Excel. See below for compatibility information.
Feature 1 - Flashfill - Excel 2013 or above, Excel 365
Feature 2 - Column from Examples - Excel 2106 or above, Excel 365
Feature 3 - AI Analysis of Data - Excel 365
Feature 4 - Recommendations - Excel 365, Excel 2016 (?)
Feature 5 - Forecasting - Excel 2103 or above, Excel 365
Bonus feature - Formula Writer - Excel Online
~
💻💡 LEARN MORE
================
New to Excel and want to level up quick? Check out below curated playlists to upskill fast.
Free Excel Crash Course - • How to use Microsoft Excel - Beginner...
Data Analysis with Excel - • Beginner to Pro FREE Excel Data Analy...
30 Advanced Excel tips - • Top 30 *Advanced* Excel Tips to make ...
Essential Excel Keyboard Shortcuts - • The *ONLY* 10 Excel keyboard shortcut...
FULL Excel Course - chandoo.org/wp/excel-school-program/
~
Why can't AI get a permanent driving license? 🚗
Because it is always learning 🤓🤣
#chatgpt #excel
All Comments (21)
-
I'll have to watch that again with excel open and following along. That was great, thanks!
-
I have been a subscriber to your channel for a few months now. Really enjoy your videos. Yesterday I asked Chat GPT to recommend some you tube channels to help me learn excel. It recommended you!
-
-
You are great chandu u have change some people life for uploading that type of video
-
Fantastic instructional video for folks like me that was unaware of Excel AI features - BRAVO to you sir.
-
You are an amazing Excel teacher....thankyou 👏 so much for your valuable teachings
-
Chandoo... I have always told my friends, don't say: Excel can't do, say: I don't know how to do it !!! Awesome !!!
-
Whenever I see your video it's just below our mind and gives us a new way to do something . Too good to better and better to the best. Thank you so much chandu. For helping those people who dont know how to tackle this problem.
-
Chandoo you amaze me.. Its like diving in to Excel Ocean and going deeper and deeper. Thanx for sharing. Regards
-
I wasn’t logged into YouTube (I saw your video in a browser) but I logged in just to thank you for showing me how to use flash falls - OMG this is GOD level Excel! I love you! ❤
-
what an excellent video. I really enjoyed the tips and certainly will improve my efficiency in a day to day activities saving me a lot of time! Thanks
-
You are the real king 👑 of Excel on YouTube ❤️❤️
-
You're a rock star! I love your work, your website, and your videos! Keep up the amazing work!!!
-
Thank you Chandoo for imparting your excellent knowledge and giving us your valuable time. I will be going through this again. God bless you. 🙏🏻
-
As soon as your new video comes, you get a chance to become a hero in front of the boss Thanks Brother God Bless You
-
Professor Chandoo, your work is truly awesome and incredibly helpful! I was wondering if you've ever tried the Advanced Formula Environment add-in, which includes some powerful AI features
-
That fairly harmless button is awesome 😂@6:31
-
Dear Chandoo, your presentations are incredibly helpful! Thanks so much for sharing! You are an excellent teacher.
-
Im going to enrol in your excel school Chandoo. You are the best!
-
Really great video. helps a lot, when in confusion.