ChatGPT for Excel

Overview

Become an AI freak in the (Excel) sheets! Unlock the power of ChatGPT to solve Excel challenges, sharpen your AI prompting skills, and get a hands-on intro to the world of Generative AI.How to use ChatGPT to solve real Excel problems even as a beginnerPrompting strategies that work across any field and businessHow to understand and build mega-formulas using AI assistanceUsing ChatGPT to automate file analysis and manipulationThe foundations of Generative AI and its practical uses in AI-driven workplacesCreating conditional formatting with smart promptsBreaking big problems into easy steps with AI planningBuilding a customer survey dashboard with ChatGPT

Syllabus

•   Introduction
Introduction
Exercise: Meet Your Classmates and Instructor
Course Resources
•   Generative AI, ChatGPT and Excel
What Is AI and Why Do We Care?
How ChatGPT Can Help Excel Users
How ChatGPT Works
Perils and Pitfalls of ChatGPT
The Big Picture
•   AI Techniques for Excel
Be Clear and Specific
Provide Context
Few-Shot Prompting
Megaformula Exercise
Don't Be Shy with AI!
Using Delimiters
Conditional Formatting Exercise
Don't Overdo It!
Role Reversal Prompting
Using Outlines
Exercise - Building a Dashboard
•   Working With Files via ChatGPT for Excel
Using ChatGPT to Work with Files Directly
Extracting Data from PDFs
Extracting Formulas from Images
Get Insights from a Spreadsheet
•   Where To Go From Here?
Review This Byte!

---

Taught by

Travis Cuzick

---

Subjects

Computer Science