Administration and Executive AssistantTier 1330 minadvanced

Capstone: Build a Complete Expense Report

Combine four skills from four different tiers into one realistic deliverable: a summary formula, a styled report header, a restricted category column, and a protected final sheet.

What you will learn

• Summarise transaction data by category with a formula that updates itself
• Style a report header so it reads as a finished document, not a draft
• Restrict a category column to an approved list so entries stay consistent
• Protect the finished summary sheet before it is considered done
• Combine several independent Excel skills into one coherent piece of work, the way a real deliverable requires

Excel skills

SUMIF, Cell Formatting, Data Validation, Protect Sheet · Capstone

The task

This is the capstone: one deliverable that pulls together four separate skills, the way a real report actually does. The Expenses sheet lists every transaction; the Summary sheet needs to become a finished report from it.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free