A gentle, step-by-step path through the Excel formulas that come up every day in accounting. Ten short lessons, watch-style walkthroughs, and a live practice sheet on every page.
Everything starts here. Add a column of numbers and find the average.
Add numbers only when a condition is true.
Add up numbers that match multiple conditions at once.
Count how many cells match a condition — without any math.
Find a value in a table and return a matching value from another column.
Like VLOOKUP, but your headers run across the top in a row.
The modern replacement for both VLOOKUP and HLOOKUP.
The most flexible lookup combo — used all over finance.
Make formulas decide: return one thing if true, another if false.
Combine formulas inside one another to solve real finance problems.
Summarize huge tables into a report with a few clicks.