Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Zero To Mastery

ChatGPT for Excel

via Zero To Mastery

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 beginner
  • Prompting strategies that work across any field and business
  • How to understand and build mega-formulas using AI assistance
  • Using ChatGPT to automate file analysis and manipulation
  • The foundations of Generative AI and its practical uses in AI-driven workplaces
  • Creating conditional formatting with smart prompts
  • Breaking big problems into easy steps with AI planning
  • Building 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
    • Data Privacy and Security
    • 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

Reviews

Start your review of ChatGPT for Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.