background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for February 2025 for September 2024
:
Private EquityReal Estate InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for February 2025 is Open
Wall Street Prep

Excel
Knowledge Base

Explore

All Excel Content

  • Adjust Column Width
  • Center Across Selection
  • 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
  • How to Protect a Worksheet in Excel
  • IFERROR Function
  • Index-Match Function
  • IPMT Function
  • 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
  • Percent Change
  • 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
  • Using XLOOKUP to Generate Multiple Values
  • XIRR Function
  • XLOOKUP Function
  • XMATCH Function
  • XNPV Function
  • YEARFRAC Function
  • YIELD Function

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.