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.
