Module 08: Copilot in Excel Advanced + Analyst
Lesson 08.6: Excel Advanced Capstone: Create an Executive Analysis Report
Lesson Promise
Create a decision-ready executive report using Copilot, Excel, and Analyst-style review habits.
Real-World Scenario
A learner must prepare a leadership report explaining what changed, why it may have changed, what to verify, and what action to consider.
Core Concept
The advanced capstone combines analysis planning, trends, outliers, scenarios, PivotTables, charts, Analyst-style reports, and executive communication.
The output should separate facts, hypotheses, recommendations, and open questions. This matters because executives often act on the summary, not the workbook.
A world-class Copilot workflow ends with a reviewable evidence trail: prompts, files, columns, assumptions, formulas, visuals, and verification checks.
Step-By-Step Workflow
- Choose an approved dataset or safe sample file set.
- Create an analysis plan with hypotheses and required columns.
- Ask for trends, outliers, scenarios, and recommended visuals.
- Build or plan PivotTables, charts, or dashboard views.
- Use Analyst where available for a report pass, then compare it with Excel checks.
- Write the final executive report with findings, caveats, recommendations, and verification log.
Prompt Lab
Bad Prompt
Make an executive report.
Better Prompt
Create an executive analysis report from this dataset with trends, outliers, scenarios, charts, assumptions, and verification checks.
Expert Prompt
Create a complete executive analysis report package from the approved dataset. Include the decision question, analysis plan, data quality review, key trends, outliers, scenario analysis, PivotTable/chart recommendations, Analyst-style report summary, assumptions, confidence levels, manual verification log, recommendations, and open questions. Separate observed facts from hypotheses and recommendations.
Hands-On Exercise
Complete the full analysis package using a safe dataset. Keep the prompt trail and verification log.
Deliverable
An executive analysis report package with evidence, visuals plan, assumptions, recommendations, and verification log.
Executive Analysis Review Checklist
Common Mistakes
- Turning one spreadsheet question into a confident executive recommendation without checking the data.
- Asking for forecasts without naming assumptions, time horizon, inputs, and uncertainty.
- Using charts or PivotTables that look polished but do not answer the decision question.
- Treating Analyst, Python, file upload, or advanced editing features as universally available.
- Sharing analysis that does not separate observed facts, assumptions, hypotheses, and recommendations.
Quiz / Checkpoint
What separates an executive analysis report from a raw Copilot summary?
It separates facts, hypotheses, recommendations, and open questions, and it includes a reviewable evidence and verification trail.
Official Sources To Verify
- Get started with Analyst in Microsoft 365 Copilot
- Get started with Copilot in Excel
- Frequently asked questions about Copilot in Excel
- Get insights about numerical data with Copilot in Excel
- Get insights from text-based data with Copilot in Excel
- Create PivotTables with Copilot in Excel
- Create charts with Copilot in Excel
- Edit with Copilot in Excel
- File formats supported by Microsoft 365 Copilot
- Copilot Chat licensing explanation
Want your AI product explained to a large AI-native audience?
Kingy AI helps AI companies turn complex products into clear, useful YouTube videos that drive awareness, product understanding, demos, clicks, and search visibility.
