AI
best practice
Accelerate Spreadsheet Data Analysis Using Copilot in Excel
Let Copilot handle complex formulas and data visualization in Excel.
Integrate Copilot into your Excel workflow to perform advanced data analysis and visualization using natural language instead of manual formulas.
Microsoft Copilot
The Scenario
You have a large sales report for the quarter and need to identify which product categories are underperforming and why.
Before & after
The old way
Analyzing a complex spreadsheet with thousands of rows of data using manual formulas and pivot tables typically takes 45–60 minutes.
With AI
Use Copilot in Excel to analyze large datasets, identify patterns, and visualize results through natural language commands in 2–5 minutes.
The Prompt
Analyze this spreadsheet and identify the top 3 trends in [COLUMN_NAME]. Then, create a chart showing the correlation between [X_VARIABLE] and [Y_VARIABLE].
New innovations in Copilot for Excel allow for more sophisticated data manipulation and visualization without needing to remember complex syntax.
Source
Microsoft 365 Copilot | Microsoft Community Hub"Transform your spreadsheet workflows with Copilot in Excel ... through expert-led demos and real-world examples."