Summary
Keywords
Full Transcript
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 π https://chandoo.org/wp/top-ai-features-in-excel/ 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
