What to be able to hand over
Finance reporting turns assumptions and transactions into a decision. The important part is being able to explain why a number moved and which assumption would change the recommendation.
- A budget-versus-actual review
- Use a stated sign convention, separate departmental exceptions and explain the drivers behind a variance.
- An assumption-led comparison
- Put volumes, rates and dates in labelled inputs so another person can test a different scenario.
- A short decision note
- Connect the calculation to a recommendation, its limitations and the information still needed.
Build beyond this course
Financial statement analysis, valuation, forecasting and domain knowledge extend beyond this course. Financial and investment analyst jobs typically require a bachelor’s degree; an Excel course alone does not establish the qualifications for the role.
Occupational context: BLS: Financial and investment analysts. The handover examples above are our practice suggestions.
Work to practise
- Separate overspending from underspending.
- Calculate a unit price weighted by actual quantities.
- Keep assumptions in referenced cells.
All examples use original synthetic data. Source row numbers and column letters are shown so you can reproduce the formulas.
Read a three-department expense report
Calculate actual minus plan for each department, then find the price paid per unit across both purchases.
USD; quantities are units, not monetary weights.
| Row | A · Department | B · Plan USD | C · Actual USD |
|---|---|---|---|
| 2 | Research | 1200 | 1260 |
| 3 | Service | 900 | 810 |
| 4 | Facilities | 600 | 630 |
| Row | A · Lot | B · Units | C · Price USD |
|---|---|---|---|
| 7 | P-1 | 10 | 20 |
| 8 | P-2 | 30 | 12 |
Worked solution and complete results
Research · D2
=C2-B2Result: 60
Service · D3
=C3-B3Result: -90
Facilities · D4
=C4-B4Result: 30
Net expense variance · D5
=SUM(D2:D4)Result: 0
Weighted unit price · D9
=SUMPRODUCT(B7:B8,C7:C8)/SUM(B7:B8)Result: 14
A mistake to catch
The simple mean of 20 and 12 is USD 16. It gives a small purchase the same influence as a purchase three times its size.
Correction. Multiply each quantity by its unit price, add the costs, and divide by total units. Read departmental exceptions even when the net variance is zero.
Read the result
Total spending matches total plan, while Research and Facilities exceed their own budgets. The purchased mix costs USD 14 per unit.
Practise the skills in order
- Actual versus target Read the guide, then open the actual lesson.
- Absolute references Read the guide, then open the actual lesson.
- Weighted average Read the guide, then open the actual lesson.
- SUMPRODUCT Read the guide, then open the actual lesson.
- Percentage growth Read the guide, then open the actual lesson.
- Profit margin Read the guide, then open the actual lesson.
Use these reporting foundations before more complex models. Discounted cash flow, NPV, IRR and forecasting are outside this course subset.
Practice actual versus targetPay and remote work
U.S. pay reference
- Published occupation
- Financial and investment analysts
- Median annual wage
- USD 102,740
- Location and period
- United States · May 2025
This is a specific investment-analysis occupation, used for context. Corporate FP&A, finance assistants and financial risk specialists have different responsibilities and pay.
These BLS figures cover employees across work arrangements. They are not a remote-only salary, an entry-level offer or an earnings outcome from this course. Median means half earn more and half earn less.
Source: U.S. Bureau of Labor Statistics, Occupational Outlook Handbook. Reviewed . Values are U.S. dollars; no currency conversion is applied.
Read a remote posting carefully
Read a remote finance posting for its reporting calendar, time-zone overlap and secure data requirements. Check whether the quoted compensation is base pay, bonus-eligible pay or total compensation.
Check the allowed country or state, working hours, employment or contractor status, and the currency and components of the offer. A remote role can still have location restrictions and locally set pay.
One employer example: GitLab’s candidate handbook says to check each listing’s hiring country. Its current compensation policy uses local market data and local-currency ranges. This is an illustration of employer policy, not a claim about every remote job.
Continue in a downloadable workbook
Budget variance practice
Explain signed expense variance, overspend and percentage variance without hiding a zero budget.
USD for a fictional November 2026 workshop. Variance = actual minus plan; positive means expense over budget.
Bank version 2026-11-02. Includes Instructions, Practice, AnswerKey; 14 live answer formulas. All source records are invented for education.
The download is an additional practice task. Its Instructions sheet identifies the source coordinates; this page’s illustrative example may use different records.
- Working answers use scalar Excel 2007+ functions. No macros, external links or dynamic-array dependency. Native Excel has not been launched for verification.