Back to Blog
Blog post image

Excel Functions by Category

Jan 8, 2021 8:24:00 AM

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.


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

Subscribe to our monthly modelling newsletter