Uncover new data insights with AI

Intermediate
Administrator
Business User
Functional Consultant
Solution Architect
Technology Manager
Microsoft 365
Office 365

This module covers advanced data analysis with Copilot in Excel, including multi-step workbook building with Edit with Copilot, Python-powered forecasting, Graph-grounded data enrichment from Microsoft 365 and the web, and cross-file exploration with the Analyst agent.

Learning objectives

By the end of this module, you'll be able to use Copilot in Excel to generate insights, build formulas, and create PivotTables from structured data. You'll also build and restructure workbooks with Edit with Copilot, enrich workbooks with organizational and web data, run Python-powered statistical forecasts, and explore cross-file patterns with the Analyst agent.

Prerequisites

  • Familiarity with Microsoft 365 Copilot and working experience with Excel spreadsheets.