Advanced Analysis: Multi-Step Analytical Workflows

Microsoft Copilot in Excel

James Chapman

AI Curriculum Manager, DataCamp

When standard tools fall short

advanced_analysis.png

 

Examples of advanced analysis tasks:

  • Correlations across many variables
  • Visualizing distributions
  • Summarizing free-text data

 

→ These need multi-step exploration, not single formulas

Microsoft Copilot in Excel

How Copilot performs multi-step analysis

reason_plan_execute.png

 

  • Example: "Investigate the correlation between the variables in the workbook"
  • Copilot reasons, writes and runs formulas, and shows charts, tables, statistics
Microsoft Copilot in Excel
Microsoft Copilot in Excel
Microsoft Copilot in Excel

Let's practice!

Microsoft Copilot in Excel

Preparing Video For Download...