Back to Blog
Blog post image

Excel Functions by Category

Published
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.

 

Award_Winning

Become a Modelling Pro

Join us and we'll unlock your full potential.

Our award-winning training programme, and exclusive global community, will guide you on your way to Excel, Financial Modelling, data visualisation & analytics mastery.

Subscribe to our monthly modelling newsletter