Consulting Excel Modelling

Engagement models built to a house standard: a scoping note, clean inputs and outputs, scenario switches, a checks sheet, version control and a handover the client can run without you.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Consulting Excel Modelling, and click Install. It goes into your own files, and works offline from then on.

What it installs.

1

Pillar

1

Area

50

Projects

199

Starter tasks

📋 Management Consulting

Consulting Excel Modelling

Building client-ready Excel models: clear structure, inputs and outputs, scenarios, checks and a model the client can maintain after you leave.

  1. Personal modelling standard for client work
  2. Excel set-up for keyboard-first modelling
  3. Model scoping note before the first formula
  4. Tab map and calculation flow diagram
  5. Inputs sheet with sources, units and owners
  6. Timeline row with period flags
  7. Checks sheet with one master check
  8. Model version control and file naming
  9. Output tables built to paste into slides
  10. Daily model change log
  11. Weekly model review with the engagement manager
  12. Weekly model archive and backup
  13. Monthly input refresh when client data lands
  14. Pre-send model check routine
  15. Assumption sign-off log with the client
  16. Model issues list shared with client finance
  17. Quarterly review of errors that reached a client
  18. Keyboard shortcut drill for model building
  19. Lookup formulas that fail loudly
  20. Conditional aggregation with SUMIFS and pivots
  21. Dynamic arrays, LET and named ranges
  22. Sensitivity tables and tornado charts
  23. Scenario switch on the inputs sheet
  24. Charts for consulting exhibits from the model
  25. Handling circular references deliberately
  26. Auditing a model you did not build
  27. Excel or another tool for this model
  28. Simplifying an overbuilt model
  29. Slow workbook performance fix
  30. Single file or linked model set
  31. Input controls with data validation
  32. First model walkthrough with client finance
  33. Numbers freeze before a steering committee
  34. Independent model review before the final readout
  35. Model user guide for the client owner
  36. Model handover and training session
  37. Close-out archive of the engagement model
  38. First engagement model as a new analyst
  39. Reviewing analysts' models as a manager
  40. Modelling inside a locked-down client environment
  41. Client models in a shared cloud spreadsheet
  42. Working with an offshore modelling team
  43. Business case model with NPV and payback
  44. Initiative benefits model with phasing
  45. Driver-based market and revenue model
  46. Three-statement link for a client business plan
  47. Probabilistic ranges with Monte Carlo
  48. Macro use and documentation rules
  49. Reusable model module library
  50. Model risk rating before high-stakes decisions

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Personal modelling standard for client work

Models built on a Monday night under deadline pressure all look different, and the reviewer has to learn a new layout every time. A one-page standard covering cell colours for inputs, formulas and links, sign conventions, units, tab order and naming means every model you build reads the same way, and a manager can review it in half the time.

First tasks

  • Find your firm's modelling or Excel guide in the knowledge base
  • Write the colour, format, sign and unit rules on one page
  • Build a blank starter workbook with cover, inputs, calcs, outputs and checks tabs
  • Send the standard to your engagement manager and ask for one change

Excel set-up for keyboard-first modelling

Consultants lose hours a week to default settings: automatic calculation on a heavy file, a ribbon hunted with the mouse, and paste-special buried three menus deep. One session setting calculation mode, the Quick Access Toolbar, autosave behaviour and your most used shortcuts pays back within the first week of any engagement.

First tasks

  • List the ten commands you reach for most with the mouse
  • Add them to the Quick Access Toolbar in order of use
  • Set the AutoRecover interval and check where recovered files land
  • Export the toolbar customisation and save it to your own notes

Model scoping note before the first formula

Most rebuilt models were rebuilt because nobody wrote down what they had to answer. Half a page agreed with the engagement manager, naming the questions, the outputs and their units, the time horizon, the level of detail and who will use the file, stops you building a monthly SKU model when the steering committee wanted three annual scenarios.

First tasks

  • Write the questions the model must answer for this engagement
  • Sketch each output table with its units on paper
  • Decide the time horizon, period length and currency
  • Walk the engagement manager through the note in fifteen minutes

Make it yours.

Install Consulting Excel Modelling, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.