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.
- 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
- Monthly P&L Variance: What to Explain to Your ManagerFree
- Budget vs Forecast: Rolling the Latest Estimate (6+6) Locked
- Revenue Bridge: Volume and Price Effects in a Waterfall Locked
- Headcount Cost Model: Salaries, Start Months and On-Costs Locked
- Driver-Based Forecast: Sessions × Conversion × Order Value Locked
- KPI Pack: Margins, Year-on-Year Growth and Run-Rate Locked
- Trailing Twelve Months (TTM): A Moving SUM Locked
- Ratio Snapshot: Liquidity, Leverage and Working Capital Days Locked
- Scenario Toggle: Base, Upside and Downside with CHOOSE Locked
- Sensitivity Table: EBITDA for Price and Volume Changes Locked
- Reconciling Two Exports: XLOOKUP and the Difference Column Locked
- One-Page Management Dashboard: KPIs, Chart and Highlights Locked
- From Trial Balance to P&L: Account Mapping with XLOOKUP and the Tie-Out Check Locked
- Budget Phasing: Seasonal Monthly Budgets, YTD Variance and What Is Left to Spend Locked
- Forecast Accuracy: Errors, MAPE and Bias by Product Line Locked
- Allocating Shared Costs: Drivers, Department Contribution and Why the Driver Matters Locked
- Cash Conversion: From EBITDA to Free Cash Flow with Working Capital and a Waterfall Locked
- Capex Request: Payback, NPV and IRR for a New Store Fit-Out Locked
- Group Reporting in USD: FX Translation, Reported vs Constant-Currency Growth Locked
- Final Project: Month-End Board Pack – YTD vs Budget and Last Year, Margins & a Combo Chart Locked
Learner reviews
Be the first to review this course.