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
SUMBeginner
Add up a column or range of numbers
6 lessons · 1 freeLearn it
AVERAGEBeginner
Find the typical value in a set of numbers
6 lessons · 1 freeLearn it
MAX / MINBeginner
Find the highest or lowest value fast
5 lessons · 1 freeLearn it
SUMIFIntermediate
Add up only the rows that meet a condition
5 lessons · 1 freeLearn it
SUMIFSIntermediate
Add up rows that meet several conditions
6 lessons · 1 freeLearn it
IFIntermediate
Show one result or another based on a test
6 lessons · 1 freeLearn it
Nested IFIntermediate
Choose between three or more outcomes
5 lessons · 1 freeLearn it
AND / ORIntermediate
Combine several tests inside IF
5 lessons · 1 freeLearn it
ROUNDIntermediate
Tidy numbers to a set number of decimals
5 lessons · 1 freeLearn it
VLOOKUPIntermediate
Find a value in a table by its ID
6 lessons · 1 freeLearn it
XLOOKUPIntermediate
A modern, flexible replacement for VLOOKUP
6 lessons · 1 freeLearn it
INDEX / MATCHAdvanced
Look things up in any direction
5 lessons · 1 freeLearn it
IFERRORIntermediate
Replace errors with something readable
5 lessons · 1 freeLearn it