Excel Lookup and Reference Functions
Pull data from anywhere in a workbook with VLOOKUP, XLOOKUP, INDEX/MATCH, and dynamic reference functions.
6 guidesGuides
Every Desk Dojo tutorial, organized by topic. Pick a hub to see all the guides on a subject in one place.
Excel
Excel Logical and Error-Handling Functions
Build decision logic and handle errors cleanly with IF, AND, OR, IFS, SWITCH, and IFERROR.
4 guidesExcel Text Functions
Combine, split, clean, and reformat text with CONCAT, TEXTJOIN, LEFT/RIGHT/MID, TRIM, and more.
10 guidesExcel Math and Statistical Functions
Summarize and analyze numbers with SUM, COUNT, AVERAGE, the conditional IFS family, rounding, and statistical functions.
16 guidesExcel Date and Time Functions
Work with dates and times using YEAR, MONTH, DAY, WEEKDAY, HOUR, MINUTE, SECOND, and TIME.
3 guidesExcel Dynamic Array Functions
Spill results across ranges with FILTER, UNIQUE, SORT, SEQUENCE, and the LET helper.
5 guidesExcel Data Tools and Productivity
Organize, validate, and analyze data with tables, pivot tables, conditional formatting, drop-down lists, what-if tools, and core productivity shortcuts.
16 guidesFinancial Functions in Excel
Run finance calculations in a spreadsheet with PMT, loan and mortgage math, and NPV/IRR functions.
3 guidesFinance
Time Value of Money
The foundation of finance: how money moves through time with present value, future value, NPV, IRR, and amortization.
4 guidesBusiness and Security Valuation
Value companies and securities with DCF, terminal value, enterprise value, comparable companies, precedent transactions, and dividend and bond models.
7 guidesCost of Capital and Capital Structure
How firms fund themselves and price risk: WACC, CAPM, capital structure, leverage, and payout policy.
6 guidesFinancial Statements and Analysis
Read and interpret financials with statement analysis, ratios, DuPont, ROIC, free cash flow, depreciation, and working capital.
10 guidesFinancial Modeling and Deal Analysis
Build models for real decisions: merger models, accretion/dilution, LBOs, sensitivity analysis, and break-even.
5 guides