Excel tips for finance professionals.
Tutorials, comparisons, and productivity guides for analysts who live in spreadsheets.
=AUDIT("pre-send")The 10-Minute Model Check Before You Hit Send
A practical pre-send audit for financial models: broken links, hidden errors, stale names, and the embarrassing stuff. Ten minutes that protect your reputation.
=FIND("425")How to Find Hardcoded Numbers in an Excel Model (Before They Find You)
Hardcodes buried inside formulas are the most common source of model errors. Four ways to find them in native Excel, from Go To Special to a five-line VBA scan.
=INPUT("blue")Excel Color Conventions for Financial Modeling: The Standard Nobody Wrote Down
Blue inputs, black formulas, green links. What the investment banking color standard means, why it exists, and how to apply it without clicking through menus.
=SWITCH("macabacus")Best Macabacus Alternatives for Finance Professionals (2026)
Looking for a Macabacus alternative? Compare ExcelSurge, Wall Street Training, and other Excel add-ins for IB, PE, and FP&A.
Essential Excel Shortcuts for Investment Banking Analysts (2026)
Master the keyboard shortcuts IB analysts use daily. From formatting to formula tracing, these Excel shortcuts will save you hours every week.
=PRECEDENTS(B12)How to Trace Precedents Across Sheets in Excel (Step-by-Step)
Tracing cell references across 40 tabs? Here's how to follow formulas across sheets in Excel using built-in tools and add-ins.