The shortcuts, formulas, and formatting conventions that separate a buy-side associate from a hobbyist.
Excel fluency signals something specific in LMM diligence: can you build and maintain a model fast enough, under deal-timeline pressure, without breaking it? Deals at this size rarely have a dedicated modeling team — often it's one associate or the searcher themselves, updating the model daily as diligence data comes in.
Non-negotiable habits
- Keyboard-only navigation. Ctrl+Arrow, Ctrl+Shift+Arrow, F2 to edit in place, F4 to toggle absolute references, Alt+E-S-V (or Ctrl+Alt+V) for paste special. Reaching for the mouse to move around a model is the single fastest tell in a live working session.
- One input, one formula. Hardcode assumptions in a single, clearly labeled cell (blue font is a common convention) and reference it everywhere else. A model where the growth rate is typed into 40 different formulas can't survive a single round of diligence revisions.
- Color and formatting conventions. Blue = hardcoded input, black = formula, green = link to another sheet/tab, red = flag or check. Whatever convention you pick, apply it consistently — a reviewer should be able to tell input from output at a glance.
- Build in checks. A balance-sheet-balances row, a sources-equal-uses row, a debt-schedule-ties-to-cash-flow row — each flagging visibly (conditional formatting to red) the moment something breaks. Catching your own error before a partner does is the job.
Functions that come up constantly
- INDEX/MATCH (or XLOOKUP where available) over VLOOKUP — more flexible, doesn't break when columns are inserted.
- IRR / XIRR for return calculations, especially with irregular cash-flow timing (earnouts, seller-note payments) where XIRR's date-based math matters.
- OFFSET / INDIRECT used sparingly — powerful for dynamic ranges but can silently slow down or corrupt large models; know when not to use them.
- Data tables and Goal Seek for quick sensitivity analysis (purchase multiple vs. IRR, leverage vs. equity check) without building a full scenario toggle.
- SUMIFS / COUNTIFS for cleaning up messy seller-provided financials — categorizing thousands of QuickBooks line items into a usable P&L.
Where seller data actually breaks your spreadsheet skills
The hardest Excel work in LMM deals usually isn't the LBO math — it's turning a seller's raw QuickBooks export or a decade of inconsistent monthly financials into a clean, normalized trailing-twelve-month P&L. Practice with messy, real-world exports (not clean case-study data) — pivot tables, text-to-columns, and careful use of helper columns to reconcile categorization changes over time are what actually get used week to week.
Practice resources
Free options: Wharton's or CFI's Excel fundamentals courses, and rebuilding a public company's model from its 10-K as an exercise. Paid: modeling courses aimed at PE/IB (Wall Street Prep, BIWS) go deeper on the shortcuts and conventions above.
