---
title: Excel Function Categories | Full Stack Modeller
description: The essential Excel function categories for financial modeling. Explore our top picks for modellers' Excel toolkit.
---

[Blog ](https://www.fullstackmodeller.com/blog)

# [Excel Function Categories | Full Stack Modeller](https://www.fullstackmodeller.com/blog/excel-function-categories)

 Written by [Myles Arnott](https://www.fullstackmodeller.com/blog/author/myles-arnott) | 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](https://www.fullstackmodeller.com/blog/how-to-use-the-if-function)   Returns one value for a TRUE result, and another for a FALSE result

 

## Lookup and reference functions

### [XLOOKUP](https://www.fullstackmodeller.com/blog/how-to-use-the-xlookup-function) Look up values from another table

### [INDEX](https://www.fullstackmodeller.com/blog/how-to-use-the-index-function) Returns a value from a range based on the position specified

 

## Date and time functions

### [EOMONTH](https://www.fullstackmodeller.com/blog/how-to-use-the-eomonth-function)  Returns the last day of the month after adding a specified number of months

 

## Statistical functions

### [MAX](https://www.fullstackmodeller.com/blog/how-to-use-the-max-function)  Returns the largest value from a range of numbers

### [MIN](https://www.fullstackmodeller.com/blog/how-to-use-the-min-function)  Returns the smallest value from a range of numbers

## Maths  functions

### [SUMIFS](https://www.fullstackmodeller.com/blog/how-to-use-the-sumifs-function) Sum rows that meet specific criteria

### * *

 

*Read more about all of Excel's functions on the Microsoft support page [here](https://support.microsoft.com/en-us/office/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb).*

 

[View full post](https://www.fullstackmodeller.com/blog/excel-function-categories)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Myles Arnott"
  },
  "dateModified" : "2024-09-21T16:40:03.596Z",
  "datePublished" : "2021-01-08T08:24:00Z",
  "headline" : "Excel Functions by Category",
  "image" : {
    "@type" : "ImageObject",
    "height" : 1260,
    "url" : "https://www.fullstackmodeller.com/hubfs/Excel%20Functions%20by%20Category.png",
    "width" : 2240
  },
  "mainEntityOfPage" : "https://www.fullstackmodeller.com/blog/excel-function-categories",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Blog"
  }
}
```