Cheat Sheet (companion to Cheat_Sheet.xlsx)

The workbook has four tabs: Shortcuts (Windows & Mac), Formulas, Model Rules, and Day-Count. Highlights below; open the .xlsx for the full tables.

Top shortcuts (Windows → Mac)

• Ctrl+Arrow → Cmd+Arrow — jump to the edge of data
• Ctrl+Shift+Arrow → Cmd+Shift+Arrow — extend selection to the edge
• F2 (edit) → Ctrl+U; F4 (toggle absolute) → Cmd+T; F9 (evaluate)
• Alt+= AutoSum; Ctrl+D/Ctrl+R fill; Ctrl+Enter fill selection at once
• Ctrl+; static date; Ctrl+Alt+V paste special; Ctrl+1 format cells
• Ctrl+[ / Ctrl+] trace precedents/dependents; Ctrl+` show formulas
• F5 → Special select constants/formulas/blanks; freeze panes for headers
• Mac: swap Ctrl→Cmd; some F-keys need fn.

Formula quick-reference

• Lookups: INDEX(rng, MATCH(key, lookup, 0)), XLOOKUP(key, lookup, return, "n/a")
• Conditional: SUMIFS(sum, crit_rng, crit, ...), COUNTIFS, AVERAGEIFS, SUMPRODUCT
• Logic: IF, IFS, AND, OR, IFERROR(expr, fallback)
• Financial: PMT, IPMT, PPMT, CUMIPMT, CUMPRINC, NPER, RATE, NPV, XNPV, IRR, XIRR
• Dates: EOMONTH, EDATE, DATE, YEARFRAC(start, end, basis)

Day-count cheats

• Actual/360 — bal × rate × days/360; commercial mortgages (the default).
• 30/360 — drives PMT/IPMT/PPMT; amortizing perm/agency loans.
• Actual/365 — what XIRR/XNPV use to discount. Different from the accrual.