The Excel Formulas Cheat Sheet
This cheat sheet contains close to every formula Iโve ever used in Excel ๐๐ฎ
Letโs go through the different categories, and when to use each...
This cheat sheet contains close to every formula Iโve ever used in Excel ๐๐ฎ
Letโs go through the different categories, and when to use each...
โก๏ธ SUM
These are fairly simple - they allow you to sum values in a range
These are fairly simple - they allow you to sum values in a range
โก๏ธ LOOKUPS
These are really common โ they return a value that you enter into your lookup formula
*Note: there's no reason to use vlookup anymore!
These are really common โ they return a value that you enter into your lookup formula
*Note: there's no reason to use vlookup anymore!
โก๏ธ DATES
These are formulas that allow you to work flexibly with dates
My favorite here is EOMONTH
These are formulas that allow you to work flexibly with dates
My favorite here is EOMONTH
โก๏ธ ROUND
These formulas help you round values
These formulas help you round values
โก๏ธ CONDITIONAL / BOOLEAN
These are also really popular, and allow you to return results that meet a specific true / false criterion
These are also really popular, and allow you to return results that meet a specific true / false criterion
โก๏ธ SPILL ARRAYS
These formulas #SPILL! into other cells.
These are really useful, and are unique in the way they feed into other cells
These formulas #SPILL! into other cells.
These are really useful, and are unique in the way they feed into other cells
โก๏ธGeneral Math
These formulas are basic math operators, but make no mistake...they can be really powerful.
These formulas are basic math operators, but make no mistake...they can be really powerful.
โก๏ธText
These 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 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
These formulas are useful in the context of finance.
I'll often times use one of these when building out a debt schedule.
These 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
These formulas help you create functions.
I LOVE using LET, as it helps me create variables that I can rese in my formulas
These formulas help you create functions.
I LOVE using LET, as it helps me create variables that I can rese in my formulas
โก๏ธIndirect Cell/Range Reference
These 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 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
These formulas allow you to combine values
These formulas allow you to combine values
โก๏ธ10 Formulas that I use EVERYDAY in Finance & Accounting
In my job, I am constantly using excel...
and when I go on vacation, I have withdrawal ๐คฃ
Here are the formulas I use everyday:
EOMONTH
SUMIFS
INDEX / MATCH
COUNTIFS
SUMPRODUCT
LET
FILTER
UNIQUE
SORT
IF
In my job, I am constantly using excel...
and when I go on vacation, I have withdrawal ๐คฃ
Here are the formulas I use everyday:
EOMONTH
SUMIFS
INDEX / MATCH
COUNTIFS
SUMPRODUCT
LET
FILTER
UNIQUE
SORT
IF
๐๐ถ๐ฑ ๐๐ผ๐ ๐น๐ถ๐ธ๐ฒ ๐๐ต๐ถ๐ ๐๐ผ๐ฝ๐ถ๐ฐ?
๐๐ฒ๐ ๐บ๐ฒ ๐ธ๐ป๐ผ๐ ๐๐ต๐ฎ๐ ๐ฑ๐ผ ๐๐ผ๐ ๐น๐ถ๐ธ๐ฒ ๐บ๐ฒ ๐๐ผ ๐ฐ๐ผ๐๐ฒ๐ฟ ๐ป๐ฒ๐ ๐. ๐ฉ
PS: Level up your career and get Finance & Accounting tips like this delivered right to your inbox:
yourcfoguy.com
๐๐ฒ๐ ๐บ๐ฒ ๐ธ๐ป๐ผ๐ ๐๐ต๐ฎ๐ ๐ฑ๐ผ ๐๐ผ๐ ๐น๐ถ๐ธ๐ฒ ๐บ๐ฒ ๐๐ผ ๐ฐ๐ผ๐๐ฒ๐ฟ ๐ป๐ฒ๐ ๐. ๐ฉ
PS: Level up your career and get Finance & Accounting tips like this delivered right to your inbox:
yourcfoguy.com
Loading suggestions...