Free Cheat Sheet
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.
Being a visual learner, they were a quick and easy way to memorize a lot of information in a short amount of time. Here are a list of my favorite free printables–from learning the bones of the body to trigonometry formulas. Math Cheat Sheet. What started as a personal reference sheet turned into my most viral post. Office cheat sheets. Get up to speed in minutes, quickly refer to things you’ve learned, and master keyboard shortcuts. If you have trouble viewing these PDFs, install the free Adobe Acrobat Reader DC. Outlook cheat sheets.
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 superuser of Excel.
Table of Contents
- Function Categories in the Cheat Sheet (Worksheet)
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.
Read More:
Working with Microsoft Excel can be frustrating when it comes to finding the right commands. Sometimes it seems like part magic and part luck. That's why we've put together the cream of the crop of Excel shortcuts for WIndows and Mac users in easy to use cheatsheets you can print up and keep handy.
Highlighting the most commonly used and commonly looked for Excel commands, this list puts it all at your fingertips.
Keyboard Shortcuts
Learn how to get around Excel using only the keyboard. These cheatsheets have the keyboard shortcuts for manipulating files, editing content, changing formatting and navigating around workbooks.
Excel Function Cheatsheets
The key to being efficient with MS Excel is knowing which functions to use. With the cheatsheets below you can find functions for working with finance, statistics and database content among others.
Excel Formula Cheatsheets
Free Cheat Sheet For Words With Friends
If you need specific calculations, this is a good place to start. Below, you'll get a number of cheatsheets referencing the general formulas you need. Discover formulas on how to do basic math calculations, compose conditional formulas, perform complex counting and numerical conversions. Simply put in your own cell references and you're ready to go.
Simple Math Formulas From Microsoft.com
Rounding Numbers
Advanced Excel Tips From Microsoft.com
Excel and VBA Cheatsheets
If you work with Excel and VBA and are looking for quick resources, try these handy VBA code snippet resources. Learn VBA code for manipulating date and time values, working with arrays and cell content and even emailing workbooks directly from Excel.
General VBA Functions
Working with both Visual Basic and Excel is no uncommon thing. You can get a general overview of VBA functions at Excel Help.
Working With Date and Time
At Tutorials Point you can find ready-made snippets of VBA code for converting date and time from one format to another or expressing the date or time value in the format that suits a specific condition.
Working With Week Numbers
Free Cheat Sheets Fantasy Football Printable
Working with week numbers is just one way of organizing and recording dates. Find VBA code to help you work with ISO week numbers, absolute week numbers and more right here.
Working With Time Zones
Need to work with different time zones? The scripts on this page can display and convert time zones as well as helping you find the difference between GMT and Local time.
Excel VBA Code Snippets from Ozgrid.com
Sort An Array
Being able to use an array formula means you can perform a number of complex calculations. Ozgrid.com offers some VBA code to help you - it helps sort out all your array formulas.
Delete Module After Running VBA Code
In addition to array formula VBA codes, Ozgrid.com also offers a useful VBA coding tip that will delete itself after being run once.
Custom Excel Formula/Function to Parse Words From a Text String in Excel
Here's a handy code snippet if you need a specific word within a text string. The code will extract the nth word in the string and make it easy for you to find the fourth, fifth or even the sixth word.
VBA Workbook Macros From TeachExcel.com
Combine mulitple workbooks into one
From TeachExcel.com, this code snippet lets you work more efficiently within Excel by combining multiple workbooks into one with a simple macro.
Reverse Cell Contents
Need to reverse a few numbers? The VBA macro offered here is designed to do just that. It works on text and numbers within selected cells.
Reverse Row or Column Order in a Worksheet
After you've mastered reversing the textual and numeric contents of a few cells, try out this macro and reverse the row or column order.
Delete Entire Rows Based on Predefined Criteria (Text)
If you're looking for more efficient ways of cutting out and editing your spreadsheet data, TeachExcel.com offers you this macro which deletes rows based upon the criteria you define.
Print all Embedded Charts in the Entire Workbook
Here's a VBA macro that'll save you a ton of time by letting you print up all the embedded charts that are in a workbook in one shot.
About Investintech
Investintech is a company devoted to creating industry leading PDF converter software. Our first and perhaps most widely used PDF conversion is from PDF to Excel. Users wanting to convert PDF to Excel can do so by downloading a free trial of Able2Extract Professional. We believe it is the most accurate way to convert from PDF to Excel.
Articles
- PDF Basics
- PDF Creation
- PDF Conversion
- PDF Editing
- Able2Extract Tips
- MS Office Tips
- Technology