Excel Formulas Cheat Sheet
There are an endless amount of formulas in excel...
but knowing how to use each, as well as when to use each is what separates the pros from the beginners.
Let's do a deep dive into all of our options so that by the end of today, you'll be able to call yourself a pro 😎
➡️Sum Formulas
These are fairly simple - they allow you to sum values in a range
➡️Lookup Formulas
These are really common → they return a value that you enter into your lookup formula
*Note: there's no reason to use vlookup anymore!
➡️ Date Formulas
These are formulas that allow you to work flexibly with dates
My favorite here is EOMONTH
➡️ ROUND Formulas
These formulas help you round values
➡️ CONDITIONAL / BOOLEAN Formulas
These are also really popular, and allow you to return results that meet a specific true / false criterion
➡️ SPILL ARRAY Formulas
These formulas #SPILL! into other cells.
These are really useful, and are unique in the way they feed into other cells
➡️General Math Formulas
These formulas are basic math operators, but make no mistake...they can be really powerful.
➡️Text Formulas
These excel formulas are helpful when dealing with text.
Trim is especially helpful when working with accounting softwares that add a space before / after your GL account
➡️Finance Formulas
These excel formulas are useful in the context of finance.
I'll often times use one of these when building out a debt schedule.
➡️Custom Function Creation Formula
These excel formulas help you create functions.
I LOVE using LET, as it helps me create variables that I can reuse in my formulas
➡️Indirect Cell/Range Reference Formula
These excel formulas allow you to refer to cells, both directly and indirectly.
I like to sometimes create a reference to a tab in a cell, and use that text in my formulas using indirect.
➡️Combine Formulas
These excel formulas allow you to combine values
➡️10 Formulas that I use EVERYDAY in Finance & Accounting from the Excel Cheat Sheet
In my job, I am constantly using excel...
and when I go on vacation, I have withdrawal 🤣
Here are the formulas I use everyday from the excel cheat sheet:
EOMONTH
SUMIFS
INDEX / MATCH
COUNTIFS
SUMPRODUCT
LET
FILTER
UNIQUE
SORT
IF
Here's the full Excel Formulas Cheat Sheet