Automated Transformations and Formulas

Microsoft Copilot in Excel

James Chapman

AI Curriculum Manager, DataCamp

Order! Order in the Court!

messy_data.jpg

Microsoft Copilot in Excel

Order! Order in the Court!

clean_data.jpg

Microsoft Copilot in Excel

The Traditional Workflow

trad_workflow.jpg

Microsoft Copilot in Excel

The Copilot Workflow

copilot_workflow.jpg

Microsoft Copilot in Excel
Microsoft Copilot in Excel
Microsoft Copilot in Excel

A Prompting Checklist

checklist.png

 

  1. Reference tables and columns so Copilot knows exactly what data to use
  2. Start a new chat if it gets long or between tasks

→ Context leakage: context from other tasks interfering with the current task

Microsoft Copilot in Excel

Let's practice!

Microsoft Copilot in Excel

Preparing Video For Download...