Spreadsheet mechanics for analysts

You master navigation shortcuts, structured tables, named ranges, and array habits that keep formulas readable when models grow. Audit topics include tracing dependents, isolating circular references, and versioning conventions that FP&A teams expect before month-end close. Case files emphasize separating inputs, calculations, and outputs on distinct sheets with consistent color coding. You also document model purpose and owner contact so handoffs survive employee turnover.

Three-statement integrated modeling

Lessons walk through revenue drivers, operating expenses, working capital movements, and how the income statement links to the balance sheet and cash flow statement through corkscrew schedules. You practice sanity checks such as balance sheet balancing and cash tie-outs. Error-proofing includes range naming for recurring concepts like depreciation and tax timing assumptions explained in footnotes rather than buried in cell comments.

Scenarios, sensitivities, and downside cases

You build data tables, scenario switches, and goal-seek exercises that help leadership understand downside paths without rebuilding the model. Guidance covers choosing driver ranges grounded in history versus optimism, and how to narrate uncertainty to boards. Stress tests include delayed customer payments and step-function hiring plans so outputs feel relevant to operating committees.

Presentation for investors and internal leaders

The final unit converts technical outputs into summary dashboards, appendix detail, and footnotes diligence teams expect. You learn to pair charts with written caveats and to avoid false precision in decimal-heavy tables. Peer review critiques whether a stranger could audit your assumptions in under an hour, which is the standard many funds apply during fundraising.

Governance and model maintenance

You document version history, model owner rotation, and how to incorporate actuals each quarter without breaking links. Controls cover segregation of duties for sensitive inputs and archiving superseded forecasts. Discussion includes when to migrate heavy models to specialized FP&A systems versus keeping Excel as the source of truth. Workshops compare audit findings from real diligence exercises so you recognize warning signs before investors do. You also rehearse explaining circular references and sensitivity tables to colleagues who rarely open your workbook.