---
title: Excel Functions | Full Stack Modeller
description: Master essential Excel functions for financial modelling. Explore our top picks for every modeller's Excel toolkit.
---

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

# [Excel Functions | Full Stack Modeller](https://www.fullstackmodeller.com/blog/excel-functions)

 Written by [Giles Male](https://www.fullstackmodeller.com/blog/author/giles-male) | Jan 1, 2021, 2:35:00 PM

The Excel functions list.

## Below are the key Excel functions for financial modelling:

 

#### [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

### [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

### [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

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

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

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

 

*Read more about all of Excel's functions on the Microsoft support page [here](https://support.microsoft.com/en-us/office/excel-functions-alphabetical-b3944572-255d-4efb-bb96-c6d90033e188).*

 

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

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Giles Male"
  },
  "dateModified" : "2024-07-16T10:22:12.709Z",
  "datePublished" : "2021-01-01T14:35:00Z",
  "headline" : "Excel Functions",
  "image" : {
    "@type" : "ImageObject",
    "height" : 1260,
    "url" : "https://www.fullstackmodeller.com/hubfs/Excel%20Functions.png",
    "width" : 2240
  },
  "mainEntityOfPage" : "https://www.fullstackmodeller.com/blog/excel-functions",
  "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"
  }
}
```