Tabellab

Excel for New Financial Analysts: Your First 90 Days

20 hands-on labs for junior and new financial analysts: P&L variance commentary, forecast roll, revenue bridge, headcount costs, driver-based forecast, KPI pack, TTM, ratios, scenario switch, sensitivity table, reconciliation, management dashboard – plus trial-balance mapping, budget phasing, forecast accuracy, cost allocation, cash conversion, capex payback and NPV, FX translation and a month-end board pack.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course follows your first 90 days as a financial analyst at a fictional outdoor retailer in 20 labs. You explain P&L variances against budget, roll a 6+6 forecast, build a price/volume revenue bridge, model headcount costs, forecast revenue from drivers, prepare a KPI pack, calculate trailing twelve months and ratios, switch scenarios, fill a sensitivity table, reconcile two exports and build a management dashboard. The second half adds the month-end routine: mapping the trial balance to the P&L with a tie-out check, phasing a seasonal budget, measuring forecast MAPE and bias, allocating shared costs with drivers, turning EBITDA into free cash flow, checking a capex request with payback, NPV and IRR, translating foreign entities into USD with constant-currency growth and assembling a board pack with a combo chart. Every cell is checked instantly.

Lessons

  1. Monthly P&L Variance: What to Explain to Your ManagerLabFree
  2. Budget vs Forecast: Rolling the Latest Estimate (6+6)Lab Locked
  3. Revenue Bridge: Volume and Price Effects in a WaterfallLab Locked
  4. Headcount Cost Model: Salaries, Start Months and On-CostsLab Locked
  5. Driver-Based Forecast: Sessions × Conversion × Order ValueLab Locked
  6. KPI Pack: Margins, Year-on-Year Growth and Run-RateLab Locked
  7. Trailing Twelve Months (TTM): A Moving SUMLab Locked
  8. Ratio Snapshot: Liquidity, Leverage and Working Capital DaysLab Locked
  9. Scenario Toggle: Base, Upside and Downside with CHOOSELab Locked
  10. Sensitivity Table: EBITDA for Price and Volume ChangesLab Locked
  11. Reconciling Two Exports: XLOOKUP and the Difference ColumnLab Locked
  12. One-Page Management Dashboard: KPIs, Chart and HighlightsLab Locked
  13. From Trial Balance to P&L: Account Mapping with XLOOKUP and the Tie-Out CheckLab Locked
  14. Budget Phasing: Seasonal Monthly Budgets, YTD Variance and What Is Left to SpendLab Locked
  15. Forecast Accuracy: Errors, MAPE and Bias by Product LineLab Locked
  16. Allocating Shared Costs: Drivers, Department Contribution and Why the Driver MattersLab Locked
  17. Cash Conversion: From EBITDA to Free Cash Flow with Working Capital and a WaterfallLab Locked
  18. Capex Request: Payback, NPV and IRR for a New Store Fit-OutLab Locked
  19. Group Reporting in USD: FX Translation, Reported vs Constant-Currency GrowthLab Locked
  20. Final Project: Month-End Board Pack – YTD vs Budget and Last Year, Margins & a Combo ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy