Uploaded February 2023 | Updated November 2026, 2 hours ago
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-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-Features.xlsx
๐จ 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 - youtu.be/F7aPazuS8QY
Data Analysis with Excel - youtube.com/watch?v=v2oNWja7M2E&list=PLmejDGrsgFyBCxF37lewZtX6c1kJXyLt3
30 Advanced Excel tips - youtu.be/m2C_-6PW6WE
Essential Excel Keyboard Shortcuts - youtu.be/ykP-agYOtC4
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
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-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-Features.xlsx
๐จ 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 - youtu.be/F7aPazuS8QY
Data Analysis with Excel - youtube.com/watch?v=v2oNWja7M2E&list=PLmejDGrsgFyBCxF37lewZtX6c1kJXyLt3
30 Advanced Excel tips - youtu.be/m2C_-6PW6WE
Essential Excel Keyboard Shortcuts - youtu.be/ykP-agYOtC4
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





![How to Self-Join Tables in Power Query [Step-by-step Tutorial]
Use Power Query self-joins to solve tricky data challenges.
In this example, I share how I am using self-joins to get the prior weekly rental and prior move out date from rental agreement data with Power Query.
Sample data file: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx
Need Power BI Skills for yourself?
Join my Power BI course - https://chandoo.org/wp/power-bi-course/
~
A data engineer got divorced. When friends ask her what happened, she replied,
I left the join because it wasnt the right join. ๐
#powerbi #powerquery How to Self-Join Tables in Power Query [Step-by-step Tutorial]](https://i.ytimg.com/vi/yPTbywOkXIo/mqdefault.jpg)




