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 😎
These are fairly simple - they allow you to sum values in a range
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.
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
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.
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:
INDEX / MATCH
Here's the full Excel Formulas Cheat Sheet