Excel functions for finance
Finance work in Excel comes down to a handful of jobs: totalling, comparing against a budget, matching codes to names and keeping numbers tidy. These are the functions that cover them.
Typical jobs
- Total spend by team, category or month
- Flag invoices that are over budget
- Match account codes to account names
- Round prices and tax so totals agree with invoices
13 functions to learn
Add up a column or range of numbers
Find the typical value in a set of numbers
Find the highest or lowest value fast
Add up only the rows that meet a condition
Add up rows that meet several conditions
Show one result or another based on a test
Choose between three or more outcomes
Combine several tests inside IF
Tidy numbers to a set number of decimals
Find a value in a table by its ID
A modern, flexible replacement for VLOOKUP
Look things up in any direction
Replace errors with something readable
Other jobs
Unlock every lesson
Every function has a free lesson. Members get all the lessons, fresh exercises every time and the weekly leaderboard. £7 a month or £49 a year, and you can cancel at any time.