Course
Project: monthly sales report
Turn a quarter of raw orders into a report a manager can read: key figures first, then sales and orders per region, then a region-by-month table built from one formula.
Exercise 1 of 7
Step 1: total sales
Here are the quarter’s 15 orders. Start the report on the right: in G2, add up every amount in D2:D16 with SUM.
| Order | Month | Region | Amount ($) | Key figure | Value | |||
| SO-1041 | Jan | East | 1,420.00 | Total sales | ||||
| SO-1042 | Jan | South | 860.00 | Average order | ||||
| SO-1043 | Jan | North | 1,250.00 | Smallest order | ||||
| SO-1044 | Jan | West | 975.00 | Largest order | ||||
| SO-1045 | Jan | North | 640.00 | Number of orders | ||||
| SO-1046 | Feb | South | 1,180.00 | |||||
| SO-1047 | Feb | East | 730.00 | |||||
| SO-1048 | Feb | West | 1,560.00 | |||||
| SO-1049 | Feb | North | 1,095.00 | |||||
| SO-1050 | Feb | South | 905.00 | |||||
| SO-1051 | Mar | East | 1,310.00 | |||||
| SO-1052 | Mar | North | 820.00 | |||||
| SO-1053 | Mar | South | 1,475.00 | |||||
| SO-1054 | Mar | West | 690.00 | |||||
| SO-1055 | Mar | West | 1,140.00 |