Back to Blog
Blog post image

Excel Functions

Jan 1, 2021 2:35:00 PM

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.


Take our free 30-question skills assessment

See where you stand with your Excel, financial modelling, data visualisation & analytics, and modelling tech skills

Take Free Skills Assessment