Summarize quarterly revenue by region
You're a regional sales analyst at BrightStar Retail, preparing for next week's quarterly business review. The VP of Sales needs a summary showing total revenue by region so the leadership team can compare performance at a glance. The Orders table has one row per transaction, and your job is to turn it into a concise pivot-style summary.
This exercise is part of the course
Microsoft Copilot in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise