Regional sales summary
Turn a raw sales export into a summary a manager can actually use, with totals, a chart and a dropdown.
1. Download your workbook
Each download has its own data, so your answers are yours alone.
2. Do the work in Excel
- Total each region. On the Summary sheet, fill B2:B5 with formulas that total Sales for the region in column A.
- Add a grand total. In B6, add a formula that totals the regions.
- Add a chart. Add a chart of the regional totals to the Summary sheet.
- Add a dropdown. In E2, add a data validation dropdown that lists the four regions, then choose one.
- Make it respond. In E3, add a formula that shows the total for whichever region is selected in E2.
Save the file as an Excel Workbook (.xlsx) when you’re done.