Excel Lookup and Reference Functions
Pull data from anywhere in a workbook with VLOOKUP, XLOOKUP, INDEX/MATCH, and dynamic reference functions.
6 guidesEvery Desk Dojo tutorial, organized by topic. Pick a hub to see all the guides on a subject in one place.
Pull data from anywhere in a workbook with VLOOKUP, XLOOKUP, INDEX/MATCH, and dynamic reference functions.
6 guidesBuild decision logic and handle errors cleanly with IF, AND, OR, IFS, SWITCH, and IFERROR.
4 guidesCombine, split, clean, and reformat text with CONCAT, TEXTJOIN, LEFT/RIGHT/MID, TRIM, and more.
10 guidesSummarize and analyze numbers with SUM, COUNT, AVERAGE, the conditional IFS family, rounding, and statistical functions.
16 guidesWork with dates and times using YEAR, MONTH, DAY, WEEKDAY, HOUR, MINUTE, SECOND, and TIME.
3 guidesSpill results across ranges with FILTER, UNIQUE, SORT, SEQUENCE, and the LET helper.
5 guidesOrganize, validate, and analyze data with tables, pivot tables, conditional formatting, drop-down lists, what-if tools, and core productivity shortcuts.
16 guidesRun finance calculations in a spreadsheet with PMT, loan and mortgage math, and NPV/IRR functions.
3 guidesThe foundation of finance: how money moves through time with present value, future value, NPV, IRR, and amortization.
4 guidesValue companies and securities with DCF, terminal value, enterprise value, comparable companies, precedent transactions, and dividend and bond models.
7 guidesHow firms fund themselves and price risk: WACC, CAPM, capital structure, leverage, and payout policy.
6 guidesRead and interpret financials with statement analysis, ratios, DuPont, ROIC, free cash flow, depreciation, and working capital.
10 guidesBuild models for real decisions: merger models, accretion/dilution, LBOs, sensitivity analysis, and break-even.
5 guides