Excel functions listed by category.
Below are the key Excel functions for financial modelling by category:
Logical functions
IF Returns one value for a TRUE result, and another for a FALSE result
Lookup and reference functions
XLOOKUP Look up values from another table
INDEX Returns a value from a range based on the position specified
Date and time functions
EOMONTH Returns the last day of the month after adding a specified number of months
Statistical functions
MAX Returns the largest value from a range of numbers
MIN Returns the smallest value from a range of numbers
Maths functions
SUMIFS Sum rows that meet specific criteria
Read more about all of Excel's functions on the Microsoft support page here.
