A regional sales CSV with checked counts and totals
Excel Sales Reporting
Build a checked sales report with lookups and conditional totals.
beginner · About 95 minutes · 4 lessons · 8 exercises + 1 project
Your finished work
A regional sales CSV with checked counts and totals
Completion requires every output check to pass. Exact columns, types, values, missing values and duplicate counts all matter. A diagnostic score helps you revise your work.
All examples use original, fictional business data. Your final project starts with 69 source records.
The course
- Start lesson →
1. Look up a region
Join a sales row to a region using an explicit key.
- Start lesson →
2. Calculate conditional totals
Use conditions before summing sales.
- Start lesson →
3. Build a pivot-style summary
Group by region and product without duplicating totals.
- Start lesson →
4. Audit a report
Reconcile totals with an independent calculation.
Put it together
Deliver a regional report
69 source records. Apply the business rules, check your output and download a handoff report with your source, answer and results.
Preview your first input
order_id,customer_id,region 1,1, 2,2, 3,99,