# 102 Microsoft Excel Formulas & Functions Cheat Sheet [Free Download]

*Do you use Excel Formulas daily at your job? Download my Excel workbook where I have listed 100+ common Microsoft Excel Formulas and Functions Cheat Sheet for your daily use.*

Without Formulas, Microsoft Excel is just like a word processor. These are Excel formulas and functions that give life to the world’s most popular spreadsheet program.

People say if you learn 20-25 formulas, you can master Microsoft Excel. It is true in some sense. But I say at least learn these 102 Excel formulas; you will be a super user of Excel.

## Free download the Cheat Sheet

To make you able to use the workbook in your daily Excel, I have made the functions browse-able from one worksheet.

## Function Categories in the Cheat Sheet (Worksheet)

I have categorized the Excel functions into 10 broad categories:

### IS FUNCTIONS

Under IS FUNCTIONS, you will find the cheat sheet of the following functions:

- ISBLANK
- ISERR
- ISERROR
- ISEVEN
- ISODD
- ISFORMULA
- ISLOGICAL
- ISNA
- ISNUMBER
- ISREF
- ISTEXT
- ISNONTEXT

### CONDITIONAL FUNCTIONS

Under CONDITIONAL, you will find a cheat sheet of the following functions:

- AVERAGEIF
- SUMIF
- COUNTIF
- AVERAGEIFS
- SUMIFS
- COUNTIFS
- IF
- IFERROR
- IFNA

### MATHEMATICAL FUNCTIONS

Under MATHEMATICAL, you will find the cheat sheet of the following functions:

- SUM
- AVERAGE
- AVERAGEA
- COUNT
- COUNTA
- MEDIAN
- SUMPRODUCT
- SUMSQ
- COUNTBLANK
- EVEN
- ODD
- INT
- LARGE
- SMALL
- MAX
- MAXA
- MIN
- MINA
- MOD
- RAND
- RANDBETWEEN
- SQRT
- SUBTOTAL

### FIND & SEARCH FUNCTIONS

Under FIND & SEARCH, you will find the cheat sheet of the following functions:

- FIND
- SEARCH
- SUBSTITUTE
- REPLACE

### LOOKUP FUNCTIONS

Under LOOKUP, you will find the cheat sheet of the following functions:

- MATCH
- LOOKUP
- HLOOKUP
- VLOOKUP

### REFERENCE FUNCTIONS

Under REFERENCE, you will find the cheat sheet of the following functions:

- ADDRESS
- CHOOSE
- INDEX
- INDIRECT
- OFFSET

### DATE & TIME FUNCTIONS

Under DATE & TIME, you will find the cheat sheet of the following functions:

- DATE
- DATEVALUE
- TIME
- TIMEVALUE
- NOW
- TODAY
- YEAR
- MONTH
- DAY
- HOUR
- MINUTE
- SECOND
- WEEKDAY
- DAYS
- NETWORKDAYS
- WORKDAY

### MISC. FUNCTIONS

Under MISC., you will find the cheat sheet of the following functions:

- AREAS
- CHAR
- CODE
- CLEAN
- TRIM
- LEN
- COLUMN
- ROW
- EXACT
- FORMULATEXT
- LEFT
- RIGHT
- MID
- LOWER
- PROPER
- UPPER
- REPT
- SHEET
- SHEETS
- TRANSPOSE
- TYPE
- VALUE

### RANK FUNCTIONS

Under RANK, you will get the cheat sheet of the following functions:

- RANK
- RANK.AVG
- RANK.EQ

### LOGICAL FUNCTIONS

Under LOGICAL, you will get the cheat sheet of the following functions:

- AND
- OR
- NOT
- And XOR

If find anything in my **Excel Formulas Cheat Sheet** workbook that has to be updated or edited, please let me know in the comments section. Hope it will help you to master Excel Formulas in an easy way!

**Master Excel Formulas & Functions in Just 3.5 Hours!**

*with my FREE COURSE at Udemy.*

**Excel Formulas and Functions with Excel Formulas Cheat Sheet!**

Dear Kawser

If is wonderful to have you share your love for Excel.

When I tried to download your file it only brings me to your mailing list signup page which I’ve already filled out. Could you please send me either the file or a link.

Thanks.

Hi Roger,

Please check your inbox. Sorry for the inconvenience you are facing.

Thanks and regards.

I am having the same problem. I’ve checked my email and confirmed my sign-up but cannot find the download?

Hi Gina,

Thanks for notifying me. I manually checked the whole process and found some problems. It is fixed now. Please check your inbox. I have sent you the link of the resource page.

Best regards

Kawser

same issue here. plz send to my inbox. Thanks

same!

Please check the mailbox. I have sent you an email with the direct download link of the resources.

Dear Kawser Bhai,

When I tried to download your file it only brings me to your mailing list signup page which I’ve already filled out. Could you please send me either the file or a link?

Please check your mail.

Thanks and regards

Although I have been already subscribed, I cannot download the Macro ebook and the Functions. It always be required an email adress. If I insert it, I get an error that I’m already subscribed.

Thanks

Please check the mailbox. I have sent you an email with the direct download link of the resources.

Wonderful resource, unfortunately experiencing the exact same problem as the users above.

Can you please send me a direct download link. Thank you.

Please check your mail, Lilly.

Yep subscribed but no email link!

Borb,

I tried to reach you to your email address but it is showing the mail cannot be reached.

How can I help you?

Regards

Kawser

Already subscribed; would like the Formula Cheat Sheet. Please send link, thanks!!

Please check your email.

Hi Kawser,

Already subscribed, can you share the Formula Cheat Sheet. Thanks

It’s sent, check your email.

I clicked on the link, but nothing downloaded. Is there another option?

I had the same problem as everyone else. Embarrassing since I shared the link on LinkedIn. :O\

Hey Tricia,

I checked several times the link. There is no problem with the link 🙂 This is not a direct download link. You have to subscribe to get the cheat sheet. I hope you should not be embarrassed with the shared link.

Best regards

Kawser

i’m always subcribed, but there is no email with a download-link :/

Please check the email 🙂

subscribed but did not find any downlaod link?

Please check your email, Sohail!

I have subscribed and waiting for my download link. Kindly send the link to my email. I have an interview later in the day. Thank you, Kawser.

Hello,

I just subscribed and would like the download link as well.

Thanks,

Kaz

Please check your email, Kaz!

Thanks.

Hello Kawser

I am facing issue on page script error. Please send me 100+Excel Formulas Cheat Sheet on my email id.

Thanks

Excellent support from this site.

Thanks for your feedback 🙂

Please send me the excel!

I subscribed! Please send me 100+Excel Formulas Cheat Sheet to my email

Nice