Wall Street Prep

Excel Courses, Templates & Guides

Explore

All Excel Content

  • Adjust Column Width in Excel
  • Center Across Selection in Excel
  • CHOOSE Function
  • COUNTA Function
  • COUNTIF Function
  • COUNTIFS Function
  • EDATE Function
  • EOMONTH Function
  • Excel Drop-Down List
  • Excel IFS Function
  • Excel LAMBDA Function
  • Excel Shortcuts “Cheat Sheet”
  • FV Function
  • Goal Seek Function
  • Highlight Duplicate Values in Excel
  • How to Protect a Worksheet in Excel
  • IFERROR Function
  • Index & Match
  • IPMT Function
  • Loan Amortization Schedule
  • Macro Recorder in Excel VBA
  • MIRR Function
  • Nested (Two-Way) XLOOKUP vs Index Match
  • OFFSET MATCH and Data Validation, Part 1
  • OFFSET MATCH and Data Validation, Part 2
  • PMT Function
  • PPMT Function
  • PV Function
  • RATE Function
  • RIP INDEX MATCH? Example Where XLOOKUP Loses
  • RRI Function
  • Scenario Analysis
  • Scenario Analysis Using XLOOKUP [VIDEO]
  • Sensitivity Analysis (“What if” Analysis)
  • SUMIF Function
  • SUMIFS Function
  • SUMPRODUCT Function
  • TODAY Function
  • Unhide Columns in Excel
  • Using XLOOKUP to Generate Multiple Values
  • XIRR Function
  • XLOOKUP in Excel
  • XNPV Function
  • YEARFRAC Function
  • YIELD Function
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.