Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise