Complete AI Training
Sign inGet started

Video course · 12 chapters · 70 min · certificate

Copilot in Excel: Complete Course for Beginners

Lisa Crosbie teaches beginners how to use Copilot in Excel step by step. The lessons cover editing, dashboards, data import, model selection, data cleaning, personalization, workbook rules, formulas, blank-workbook creation, and repeatable skills.

Become a memberAlready a member? Sign in

What you'll learn

  • Use Copilot in Excel to edit, plan, and chat with workbooks.
  • Analyze data and create dashboards with Copilot prompts.
  • Bring in data from other files and combine it for summaries.
  • Compare AI model outputs with Model Selector.
  • Clean messy data automatically and apply workbook rules.
  • Generate formulas, create spreadsheets from scratch, and build repeatable skills.

Chapters

12 chapters · 70:10
  1. 1:17 01Intro Members Copilot in Excel Complete Course (Free) A free step-by-step introduction to using Copilot in Excel.
  2. 1:55 02Overview Members What You'll Learn / Before You Start What to expect before using Copilot in Excel.
  3. 9:34 03Editing Members Lesson 1: Edit, Plan & Chat with Copilot Use Copilot chat, planning, and editing modes in Excel.
  4. 3:47 04Dashboards Members Lesson 2: Analyse Data and Create Dashboards Ask Copilot to analyze tables and build dashboards.
  5. 7:08 05Data Import Members Lesson 3: Bring in Data from Other Files Combine data from other files and ask Copilot across sources.
  6. 5:23 06Model Selector Members Lesson 4: Compare AI Models with Model Selector Use Model Selector to compare outputs from different AI models.
  7. 3:56 07Data Cleaning Members Lesson 5: Clean Messy Data Automatically Let Copilot find and fix messy data inconsistencies.
  8. 4:38 08Personalization Members Lesson 6: Personalize Your Copilot Experience Set preferences for charts and colors in Copilot.
  9. 6:38 09Workbook Rules Members Lesson 7: Create Workbook Rules Create rules to format and manage workbook data.
  10. 4:18 10Formulas Members Lesson 8: Generate Formulas with Copilot Describe a calculation and let Copilot write Excel formulas.
  11. 8:11 11Blank Workbooks Members Lesson 9: Create a Spreadsheet from Scratch Start with a blank workbook and build a spreadsheet with Copilot.
  12. 13:25 12Skills Members Lesson 10: Build Repeatable Workflows with Skills Turn repeated instructions into reusable Copilot skills.