In this video, let me share of 5 of my favourite AI features (plus a bonus one) in Excel.
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
======================
Need to practice these concepts in Excel? Try with my sample data file here 👇
https://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 – https://youtu.be/F7aPazuS8QY
Data Analysis with Excel – https://www.youtube.com/watch?v=v2oNWja7M2E&list=PLmejDGrsgFyBCxF37lewZtX6c1kJXyLt3
30 Advanced Excel tips – https://youtu.be/m2C_-6PW6WE
Essential Excel Keyboard Shortcuts – https://youtu.be/ykP-agYOtC4
FULL Excel Course – https://chandoo.org/wp/excel-school-program/
~
Why can’t AI get a permanent driving license? 🚗
Because it is always learning 🤓🤣
#chatgpt #excel
