Excel Functions

The Excel functions list.

Below are the key Excel functions for financial modelling:


IF   Returns one value for a TRUE result, and another for a FALSE result

EOMONTH  Returns the last day of the month after adding a specified number of months

MAX  Returns the largest value from a range of numbers

MIN  Returns the smallest value from a range of numbers

INDEX Returns a value from a range based on the position specified

SUMIFS Sum rows that meet specific criteria

XLOOKUP Look up values from another table


Read more about all of Excel's functions on the Microsoft support page here.


Back to Blog