Audience: Analysts, finance staff, managers and anyone who is asked what the numbers say.
Prerequisites: Microsoft 365 Copilot license assigned. Comfortable with Excel tables and basic formulas.
License and software: Microsoft 365 Copilot license: the paid add-on, or Microsoft 365 E7, which includes it. The Copilot label under the user's name reads Microsoft 365 Copilot (Premium). Excel desktop or Excel on the web. Sample workbooks are sent before class and saved to OneDrive.
YOU LEAVE WITH Workbooks with checked calculated columns, a PivotTable, charts and a summary sheet, and a routine for checking Copilot's numbers.
BY THE END, STUDENTS WILL BE ABLE TO
-
Ask Copilot to describe a dataset and point out data problems
-
Highlight and filter data with plain-language prompts
-
Chart a trend and a comparison
-
Add calculated columns and check each formula by hand
-
Build a PivotTable, a ranking of sales reps and a budget-versus-actual comparison
-
Ask multi-step and judgment-call questions and check every figure Copilot cites
-
Write an executive summary that uses only figures in the workbook
Module 1: Describe the Data and Find Data Problems
-
Confirm the data is an Excel table and Allow editing is on
-
Scan the table and predict what looks wrong before asking Copilot
-
Ask Copilot to describe each column and the date range
-
Ask for blank cells, misspellings and impossible values
-
Lab: Describe a sales workbook and find its data problems
Module 2: Highlight, Filter and Chart
-
Highlight the top values in a column
-
Highlight rows that meet a condition
-
Create a monthly trend line chart
-
Create a bar chart comparing two categories
-
Check the chart against the data
-
Lab: Highlight and filter the sales data, then chart a trend and a comparison
Module 3: Add Calculated Columns and Check Them
-
Add Profit and Profit Margin columns with stated formulas
-
Read each formula in the formula bar
-
Recalculate two rows by hand
-
Compare the new column with an existing column that should match
-
Lab: Add calculated columns and check each one by hand
Module 4: PivotTable, Ranking and Budget versus Actual
-
Have Copilot build a PivotTable on a new sheet
-
Read the PivotTable before asking Copilot about it
-
Rank sales reps by total and by average revenue
-
Summarize which regions are over and under budget
-
Lab: Build a PivotTable, rank the sales reps and compare budget with actual
Module 5: Multi-Step and Judgment-Call Questions
-
Ask a multi-step question that filters, ranks and places results on a new sheet
-
Check one total against the data
-
Ask which region had the best combination of revenue and margin
-
Require Copilot to cite the numbers it used and check each one
-
Lab: Ask a multi-step and a judgment-call question and check the figures
Module 6: Executive Summary
-
Specify the summary sentence by sentence for a named reader
-
Tell Copilot to use only figures in the workbook
-
Check every figure in the summary
-
Lab: Write an executive summary that uses only figures in the data