Autoplay
Autocomplete
Previous Lesson
Complete and Continue
AI & ChatGPT for Microsoft Excel
Introduction to the ChatGPT & AI for Microsoft Excel Course
Welcome to ChatGPT & AI for Microsoft Excel (2:13)
Download your "ChatGPT for Excel eBook"
Download the Sample Files
Built-In Excel AI Tools
Flash Fill for Fast Data Manipulation (7:22)
Introduction to AI Tools in Excel (0:44)
Let Excel Write Formulas for You (6:12)
Column From Examples in Power Query (12:56)
Create Data Insights Quickly with Analyze Data in Excel (12:11)
Practise Exercise
Getting Started with ChatGPT for Excel
ChatGPT 3.5 and ChatGPT 4 Differences (3:07)
How to Get ChatGPT (5:15)
Getting Started with ChatGPT (10:25)
Practise Exercise
Using ChatGPT for Excel Formulas
Ask ChatGPT for a Simple Excel Formula (5:48)
Using ChatGPT with Excel Formulas (1:21)
Using ChatGPT with Excel Tables (4:44)
Getting More Advanced + Fixing Errors and Adding Comments (7:35)
Practise Exercise
Advanced Formulas with ChatGPT for Excel
ChatGPT Writes Excel formulas from Data in an Image (6:45)
Write Lookup Formulas with ChatGPT (7:34)
Working with ChatGPT to Write Advanced Excel Formulas (6:14)
Get Chat GPT to Explain a Complex Excel Formula (3:26)
ChatGPT Explains Excel Formulas from a File Upload (2:23)
Debug and Fix Excel Formulas with ChatGPT (6:42)
Troubleshooting Excel Formulas with your ChatGPT Assistant (6:04)
Improving Existing Formulas with ChatGPT (4:44)
Practise Exercise
Data Cleaning and Transformation with ChatGPT
Easily Transform Data from a PDF by Copying into GPT 3.5 (5:08)
Data Cleaning and Transformation with ChatGPT (0:48)
Easily Transform Data from a PDF by Copying into GPT 3.5 (4:10)
Let ChatGPT Clean a PDF and Convert to a CSV File (4:14)
Transform a Complex Excel File (4:44)
Practise Exercise
ChatGPT and Macros
Introduction to ChatGPT and Macros (0:47)
Writing Basic Macros with ChatGPT (7:38)
ChatGPT and Event Procedures in Excel VBA (6:55)
Use ChatGPT to Write More Complex VBA Code (5:03)
Use ChatGPT to Explain How Excel VBA Code Works (3:14)
Add Comments to your Macros the Easy Way (3:42)
Ask ChatGPT to Improve your Excel Macro Code (4:27)
Debug and Fix Excel VBA Code with ChatGPT (12:48)
Practise Exercise
Conclusion & Thank You
Thank You & What's Next? (0:53)
Add Comments to your Macros the Easy Way
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock