Copilot in Excel interprets natural language instructions like “create a PivotTable showing sales by region and month” or “suggest a formula to calculate year-over-year growth,” then automatically generates formulas, transforms messy data into clean tables, builds PivotTables or charts, and even constructs simple forecasting models. Users select a dataset and describe the analysis, and Copilot handles the syntax-heavy work while explaining steps for transparency.
This accelerates data prep for non-experts, reduces formula errors that plague spreadsheets, and enables faster insights for business users without needing data analysts for routine tasks.