10x your productivity with these AI tools in Excel 😲

There is a lot of hype around ChatGPT, but do you know that Excel has really powerful AI built-into it? YES!!!
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-feature...
Need to practice these concepts in Excel? Try with my sample data file here 👇
chandoo.org/wp/wp-content/upl...
🚨 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 E...
Data Analysis with Excel - • Beginner to Pro FREE E...
30 Advanced Excel tips - • Top 30 *Advanced* Exce...
Essential Excel Keyboard Shortcuts - • The *ONLY* 10 Excel ke...
FULL Excel Course - chandoo.org/wp/excel-school-p...
~
Why can't AI get a permanent driving license? 🚗
Because it is always learning 🤓🤣
#chatgpt #excel

[@roberttaylor3594]

I'll have to watch that again with excel open and following along. That was great, thanks!

[@crafty_tams]

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!

[@serenemary873]

1:16 Flash Fill-cntrl E 2:31-import data 3:43 Power Query 6:04 AI Analysis 10:06 12:46 Automatic formulas 15:12

[@boele0707]

Love the forcasting options which i have never used before but which will be very handy for my work. Thanks so much.

[@sbatsia]

Dear Chandoo, your presentations are incredibly helpful! Thanks so much for sharing! You are an excellent teacher.

[@nandyk2393]

Awesome. Simple and correct way to convey with good examples. Thanks bro.

[@lokeshagarwal6373]

Fantastic as always

[@danielleshelbourne220]

I wasn’t logged into KZbin (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! ❤

[@chandoo_]

Wow.. you are welcome :)

[@hardeepsingh-sf7bb]

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

[@redtees1]

Awesome! Thank you!

[@sowmyan1231]

You are an amazing Excel teacher....thankyou 👏 so much for your valuable teachings

[@chandoo_]

You are very welcome

[@syedazher6316]

Chandoo you amaze me.. Its like diving in to Excel Ocean and going deeper and deeper. Thanx for sharing. Regards

[@bhu_admpsr343]

so helpful..thanks man

[@Tum_Tum_]

You are the real king 👑 of Excel on KZbin ❤️❤️

[@colinadevivero]

Good job. I like your super simple and cool style

[@Puliyancholai]

Excellent job buddy. U r making us more stronger then before in Excel as I was observed 1st 3 features already when I work but I didnt aware features 4 & 5.

[@rjwszabados]

Fantastic instructional video for folks like me that was unaware of Excel AI features - BRAVO to you sir.

[@chandoo_]

Glad you enjoyed it!

[@vishalmathur1300]

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_]

Thank you so much 😀

[@ceiswannel]

Thank you Chandoo for imparting your excellent knowledge and giving us your valuable time. I will be going through this again. God bless you. 🙏🏻

[@chandoo_]

You're most welcome

[@ragabahmed5138]

Greetings from Egypt I am a great fan of your work, your videos made my work easier & looks great, thanks for your kind support

[@Karrmohamed1998]

Thanks 👍 very much. It's very educative and helpful

[@Icarsuss]

Really great video. helps a lot, when in confusion.

[@denypardede8435]

Simply wow...thanks a lot, Sir!

[@LuisCarlosChavez717]

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

[@hareshr6058]

You are awesome Thank you chandoo All your videos are very helpful Thanks a lot

[@elitonelias753]

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

[@chandoo_]

Glad it was helpful!

[@popuptrains9877]

Thanks a lot for sharing this! Awesome!

[@KevinMorenzi]

You're a rock star! I love your work, your website, and your videos! Keep up the amazing work!!!

[@chandoo_]

Thanks so much!

[@phanlekhai]

Thanks Chandoo alot for this videos. This rise em up with some ideal about AI forecasting. I appreciated and Seeking for more video using Excel AI or extension AI in Excel.

[@rnselel]

Great stuff mate!

[@arhaanrazaa2842]

i love your explanation❤

[@dinosilooy2228]

Oh, I love the forecasting one.

[@francisdon537]

Chandoo... I have always told my friends, don't say: Excel can't do, say: I don't know how to do it !!! Awesome !!!

[@idrissajkargbo2848]

Good evening Mr Chandoo. I have been following/watching your videos closely this days but there is a future i saw you using in this video which I would want you to show me how to add it to my excel home tob which is "the faded analyze data tab you used in this video from the home tab. Regards Idrissa J from Sierra Leone, West Africa

[@razikhan3799]

valuable content, full of pearls. very much appreciated keep rocking

[@mohammedelsakally540]

Thank you Chandoo for these valuable tricks ... continue and we are supporting you...

[@neerajkapoor1050]

Wonderful video Forecasting and powerquery liked most

[@kalaivaanan8604]

Im going to enrol in your excel school Chandoo. You are the best!

[@kapibara2440]

That was super cool, thanks man :)

[@JorgeHernandez-gf1oe]

This info is gold!

[@dataanalyticssolutioninban4066]

Complex things are discussed in a very good way.

[@abdelouahedelmaazouzi6102]

Perfect tutorial!

[@shahtajp4379]

Absolutely awesome, I highly appreciate. Please keep on moving

[@kiranmedishettitalks594]

Thankyou Chandu for making this video

[@vishalmathur1300]

You are great chandu u have change some people life for uploading that type of video

[@fajvac6436]

Thank you for your effort. Very nice and very useful information.

[@ZulfikarAlisuper23]

Great Sir!!!

[@swapniltoraskar8843]

That fairly harmless button is awesome 😂@6:31

[@Commonaadmi768]

Awesome video ! Thanks 👍😊

[@paramveerssachdeva]

Thanks a lot for sharing

[@ogondaogonda4748]

This is a great video. Thanks!

[@shabchique7149]

Awesome video! You got me on the edge of my seat.🤩🙏

[@muhammadhaseebdhatt878]

What an amazing and knowledgeful video

[@indian35556]

Mind blowing

[@user-jp3kg5ue5t]

Thank you so much!

[@khammyvieng7549]

Love you!!!!

[@sagarwaghmare8749]

Thank you so much 👍

[@taizoondean689]

Thank You Sir

[@rishalek]

Great video 🤗

[@dineshgct]

amazing work

[@marivicestacamento8953]

so great i learned ,, thank you

[@Patrickgomes16]

Thank you😊

[@ronebhowmick]

Thanks @Chandoo for all your tricks. Huge Fan of yours from Bangladesh.

[@PainfullySubjective]

thank you, Chandoo!

[@FaysalEasyExcel]

Chandoo Sir simply you are great. you are an innovative excel guide for me. thankyou sir.

[@charanraj1605]

This video really help us a lot

[@SMNazrul_Islam]

amazing Excel practical class

[@selvajeganathan4013]

Really useful !

[@achprn1256]

Thank you!

[@BenDieselBasicAutomotive]

Thank you for the learning....

[@felipejaramillo1637]

Nice! 👌

[@Jamalhappy]

Excellent.... Yaar..... Specially last one

[@ranavishalsingh7993]

Hi @Chandoo - I cannot find any of the useful functions in my version of excel - I use Excel 365 on a mac but can't find 1. Flash Fill, 2. Forecast Sheet, etc. What should I do? Searched the internet as well but no found no solutions

[@snehaluchil8065]

Wow.. didn’t know of these cool Excel features available for everyone right in Excel itself

[@jagatkrishna1543]

Thanks 🙏 Sir

[@ramnaslai2980]

Excellent video

[@geetapandey5325]

You are brilliant Chando!

[@WyattBarandino]

Hey @Chandoo are these features like a plug - in for Excel or I can use their function similar to the way how you utilised them in this video. Thank you in advance and more power

[@chandoo_]

All of these are built into Excel. So no plugins needed. You may need Excel 365 version though.

[@codingtips499]

awesome tips. Can this also be done for the free online version of excel or only the paid one?

[@Ringsofsweden]

Its greatly inspirable vedios. Hatsoff you chandoo

[@mozaffarhussain6431]

Brother u r great

[@mohammadalbizri2013]

Thankful

[@rus1ickoff]

Dear Dr.Chandoo, “Fill cells with this formula” feature doesn’t work in onedrive. Is there any changes since you have announced this feature? If not then how to activate flash fill feature with this extension? Thanks for your comment

[@prasadyalamanchi5499]

Highly detailed presentation

[@shailsahu2672]

Fantastic Chandoo😇

[@chrism9037]

Nice video Chandoo!

[@hassanolanrewaju2869]

Hi Chandoo, I tried to merge cells but found that it was grayed out please what can I do. also I will like to make a complete dashboard from a spreadsheet how do you suggest I go about it. thanks

[@fog2640]

finished watching

[@papachoudhary5482]

Speechless

[@johnyqamote]

Chandoo the genius!

[@craigofficially]

Great video already

[@chandoo_]

Glad you enjoyed it

[@rahulsharma-gd8yc]

Dear chandu sir plz tell me is this playlist sufficient for whole Excel? If i will complete all video so have to watch any other videos of excel or not ???

[@ramfuture]

Hi Chandugaru I had been using power query my regular data work.but I am facing issues more than 1 core data refresh taking long time. Is there any shortcuts please advise me..

[@ihlhr]

Nice work, I like to extract data from trading view chart in to excel. How to do it.

[@MrMehrd]

Thx

[@shaikhstonevilla1]

First video watch... Subscribed bro.. Can you give me suggestion which AI add in can i use to automate drat email reply in outlook? 18:42

[@vikramgupta2625]

How could enable ai analysis option to my home page. Your teaching is really great.

[@someshkumar1626]

I have a table with 1000 rows with students details. On top I have 4 grading mentioned in a table which is row in main table A,B,C and D. If I click on any grading on above grading table, below main table should show only that selected grading

[@adim7909]

Chandoo Sir need your help for Excel in MacBook In Microsoft pivot there is option of selecting model and dragging distinct count from pivot table but in MacBook I don’t see option for data model so what’s the option to find the Distinct count in MacBook?

[@md.shamiulalamsarkar281]

Hello sir how are you... It's awesome ... Thanks ❤