Autoplay
Autocomplete
Previous Lesson
Complete and Continue
ChatGPT for Excel
Introduction
Introduction (4:26)
Exercise: Meet Your Classmates and Instructor
Course Resources
Generative AI, ChatGPT and Excel
What Is AI and Why Do We Care? (10:48)
How ChatGPT Can Help Excel Users (8:29)
How ChatGPT Works (8:28)
Perils and Pitfalls of ChatGPT (8:02)
The Big Picture (5:50)
AI Techniques for Excel
Be Clear and Specific (12:22)
Provide Context (13:13)
Few-Shot Prompting (14:18)
Megaformula Exercise (8:03)
Don't Be Shy with AI! (6:04)
Using Delimiters (11:55)
Conditional Formatting Exercise (13:14)
Don't Overdo It! (4:06)
Role Reversal Prompting (8:48)
Using Outlines (16:28)
Exercise - Building a Dashboard (12:23)
Working With Files via ChatGPT for Excel
Using ChatGPT to Work with Files Directly (10:33)
Extracting Data from PDFs (4:39)
Extracting Formulas from Images (6:53)
Get Insights from a Spreadsheet (14:08)
Where To Go From Here?
Review This Byte!
Megaformula Exercise
This lecture is available exclusively for ZTM Academy members.
If you're already a member,
you'll need to login
.
Join ZTM To Unlock All Lectures