Guide
Date and deadline formulas guide
Build deadline trackers, working-day schedules, and monthly reporting helpers with the right date formulas.
networkdays project timelineworkday due dateeomonth last day
Learn
Go deeper with formula guides that connect the library together.
Step beyond individual functions and understand how formulas work together to solve real spreadsheet problems — from financial modeling to text cleanup to date arithmetic.
Guide
Financial modeling formulas guide
Use PMT, NPV, IRR, and depreciation formulas to build a lightweight financial model in Excel.
pmt loan paymentnpv investment valueirr return rate
Guide
Monthly reporting formulas guide
Build a simple reporting toolkit for recurring monthly summaries, date windows, and working-day calculations.
sumifs monthly revenuenetworkdays project timeline
Guide
Text cleanup formulas guide
Learn how to clean messy imported text with TRIM, CLEAN, SUBSTITUTE, and case-fixing helpers.
trim remove spacesclean remove nonprintablesubstitute replace text
Guide
VLOOKUP vs XLOOKUP in Excel
Understand when the older VLOOKUP pattern still works well and when XLOOKUP gives you a cleaner, more flexible solution.
vlookup match two columnsxlookup last match