← All coursesStart lesson →
Excel Sales Reporting
Build a checked sales report with lookups and conditional totals.
beginner · About 70 minutes · 4 lessons · 8 exercises + 1 project
Your finished work
A checked CSV file with the requested values and a complete answer package.
All examples use fictional, synthetic business data. Practice standard: each exercise ≥70, final project ≥80.
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.
Final project
Deliver a regional report
Start the project →Preview the input
order_id,customer_id,region 1,1, 2,2, 3,99,