Capstone — A Business Report and Its Companion Deck

Chapter 1 opened this course with two genuinely different content models under one shared interface. Eleven chapters later, this capstone puts both halves to work on the same real project: a properly structured, personalized Word report, and a disciplined, well-designed PowerPoint deck summarizing it — built, reviewed, and delivered using every tool this course covered.

The Project Brief

A quarterly business report needs to: read professionally, with real navigable structure; get reviewed by a colleague before finalizing; go out personalized to several named recipients; and be summarized into a short, well-designed slide deck for a live stakeholder meeting — plus a version stakeholders who couldn't attend can review afterward.

Step 1 — Structuring the Report with Styles

Every section title uses a real Heading style (Chapter 2) — Heading 1 for major sections, Heading 2 for subsections — never manually bolded text made to look the part. Opening the Navigation Pane confirms the entire report's structure is genuinely visible and jumpable, not just visually convincing.

Step 2 — Page Layout for a Professional Report

Section breaks (Chapter 3) divide the report into a cover page, a Table of Contents section, the main content, and — for one wide data table that doesn't fit portrait width — a single Landscape appendix page, isolated between its own pair of section breaks exactly as Chapter 3's own exercise demonstrated.

Step 3 — Automatic ToC, Captions & Cross-References

A real Table of Contents (Chapter 4) is inserted, built entirely from Step 1's Heading styles. Every chart and table in the report gets a real Insert Caption label, and any in-text reference to one ("see Figure 3") uses a genuine cross-reference field — both staying correct automatically if a figure is later added or reordered.

Step 4 — Headers, Footers & Page Numbers

The cover page uses Different First Page (Chapter 5) to show no header at all. The Table of Contents section is numbered in roman numerals; the main content section's page numbering restarts cleanly at Arabic "1" once it begins. Link to Previous is turned off wherever the header needs to show that section's own heading rather than mirroring the cover page.

Step 5 — Collaborative Review with Track Changes

Before finalizing, a colleague reviews the draft with Track Changes (Chapter 6) switched on the entire time, plus a Comment flagging a genuine open question about one figure rather than silently deleting it. Every suggested edit is reviewed individually — accepted, rejected, or discussed — rather than blindly Accept All'd.

Step 6 — Personalizing the Report via Mail Merge

A short personalized cover letter accompanying the report is built as a Mail Merge (Chapter 7), connected to an Excel Table of recipient names and account details. Match Fields confirms every merge field genuinely lines up with the Excel source's real column headers before running the full merge — not assumed to match just because the names look similar.

Step 7 — Building the Companion Deck with the Slide Master

The PowerPoint deck uses a Slide Master (Chapter 8) whose Theme colours deliberately match the Word report's own accent colour — the same shared-Theme idea Chapter 1 introduced. Every slide uses one of a small handful of defined Layouts, never one-off manually-positioned text boxes.

Step 8 — Distilling the Report into Slides

The deck does not copy the report's own paragraphs onto slides. Following Chapter 9, each slide covers exactly one takeaway from the report, kept within the 6×6 guideline; the report's own dense data table becomes a single clear chart on its own slide instead of a wall of numbers, chosen by the same "what question is this answering" logic Excel Fundamentals Chapter 8 established.

Step 9 — Purposeful Motion

One consistent, simple transition style is applied to every slide (Chapter 10). The single slide walking through several sequential findings uses an On Click Entrance animation so each point appears exactly when the presenter is ready to discuss it — the deck's only animation, used because it solves a genuine pacing need, not decoration.

Step 10 — Rehearsing and Presenting

Every slide's extra explanatory detail — the specifics trimmed out during Step 8's distillation — lives in that slide's own Speaker Notes (Chapter 11), not back on the slide itself. Rehearse Timings confirms realistic pacing before the live meeting. Afterward, the deck is exported both as a video (for stakeholders who couldn't attend live) and as PDF handouts (a quick static reference for anyone wanting to skim it before a follow-up).

Putting It All Together

Hands-On Exercises