Files to work with
Choose a project, save your own working copy and follow the lesson. Open the worked answer when you’re ready to compare. All people and organizations in these files are invented.
Turn a draft into a document people can scan. Use heading styles, the Navigation Pane and a table of contents.
Download starter DOCXA structured memo with heading styles and a real table-of-contents field.
Download worked answer DOCX ↓Keep Raw intact, build an Excel table in Clean, then connect your summaries and chart. Check 9,450 and eight records before adding a new sale.
Download starter XLSXAn Excel table, SUMIFS summaries and an editable chart. Baseline: 9,450 across eight records.
Download worked answer XLSX ↓Make an editable chart from four monthly totals. Highlight August and keep the claim tied to the data.
Download starter PPTXSix slides with a native chart, embedded data and a comparison table.
Download worked answer PPTX ↓Build a six-slide decision story. Explain what ticket volume can establish, propose a pilot and define how you would measure it.
Download starter PPTXA worked six-slide pilot proposal. The evidence shows ticket volume, not response speed.
Download worked answer PPTX ↓Use these smaller files for individual lessons or when you want to build the project from scratch.
For PivotTables and analysis. Total 9,450; West 4,500; East 3,350; North 1,600.
Download CSVFour input rows with extra spaces and one duplicate. Clean result: three rows, total 2,850.
Download CSVFive unique product IDs and their prices. Import before trying lookup formulas.
Download CSVSix region-month rows, total 7,850. This dataset deliberately excludes North.
Download CSVFour invented recipients. Preserve PostalCode as text, including the leading zero in 02110.
Download CSVCopy the text into Word to build your memo, table and final report. This is a brief, not a DOCX template.
Download MarkdownSeparate outlines for the ticket-chart lesson and the six-slide capstone, with the shared dataset.
Download MarkdownImport instructions, verified row counts and numeric answers for all shared datasets.
Download MarkdownSave a copy before editing, especially when AutoSave is on. Import CSV through Excel’s import command so you can review dates, delimiters and text identifiers. Keep postal codes such as 02110 as text.
DOCX, XLSX and PPTX are editable Office files. Markdown files are text briefs. Formula separators and feature availability can differ by language, region and edition; see the compatibility guide for details.
We checked the files’ contents, formulas and stored results, editable chart data, document structure and rendered layouts. These checks do not establish that every feature works in every Microsoft 365 edition. Use the lesson’s result checks in your own app, including recalculation, table expansion and exported output.
The worked answers are examples, not a certification of your work. A chart based on ticket counts cannot prove faster responses. A file with a table of contents still needs its fields updated after you change the headings.
Use the practice checklists before you send a document, share a workbook or present. If Copilot is available in your account, try a copyable prompt after you’ve completed the manual task.