Course Intermediate budget-report
Budget against actual
It is the end of the first quarter and the finance director wants to know where the company is over budget. The Actuals sheet lists every payment from January to March. The Budget sheet gives each category's budget for one month. Build the report on the Report sheet.
Sheet What it is for Filled cells
Parts
Part What to do Done
1 Actual spend by category Not done yet
2 Budget for the quarter Not done yet
3 Variance Not done yet
4 Summary Not done yet
Part 1 of 4 · Actual spend by category
In B2:B7, total what was actually spent in each category over the quarter, from the Actuals sheet.
Loading spreadsheet…
- =
- start a formula
- ↑ ↓ ← →
- move, or pick cells
- Ctrl D
- fill down
- Alt =
- AutoSum
- Ctrl Enter
- check
- ?
- all shortcuts