Excel Formulas Cheat Sheet (Table of Contents)
- Cheat Sheet of Excel Formulas
- TEXT Functions in Excel
- STATISTICAL Functions in Excel
- DATE & TIME Functions in Excel
- MATHEMATICAL Functions in Excel
Excel Formulas Cheat Sheet
Cheat Sheet of Excel formulas and function is always a customized worksheet where we can have all those function details, shortcut keys to execute any function or formulas, custom way to use 2 or more function together and guideline to use them. Cheat Sheet also helps in fulfilling the gap where we need to execute some function and we don’t know the way to do that. Also, we can choose those formulas which are complicated to apply for users in a cheat sheet.
Calculations used in Cheat Sheet of Excel Formulas
In this article, we will cover Excel formulas including Text functions, Statistical functions, Date & Time functions and Mathematical functions which is most frequently used in calculations.
TEXT Functions in Excel
- Go to FORMULAS tab.
- Click on TEXT functions. A drop-down list will open. Refer the below screenshot.
As we can see, here several string functions are listed. Most commonly used text functions are LEFT, RIGHT, MID, CONCATENATE, LOWER, LEN, etc.
How does the TEXT function work?
Let’s take some example to understand the working of Text functions.
Example #1
We are taking some names and will apply the text function on them.
Please refer the below screenshot where I have applied the functions on strings and shown their workings.
4.9 (4,504 ratings)
View Course
STATISTICAL Functions in Excel
- Go to FORMULA tab.
- Click on More Functions option. Choose Statistical Functions category.
- It will open a drop-down list of functions.
Most commonly used statistical functions are MIN, MAX, COUNT, AVERAGE, MEDIAN, etc.
Example #2
Below are some Number values.
Please refer the below screenshot where I have applied the functions on number values and shown their workings.
DATE & TIME Functions in Excel
- Go to FORMULAS tab.
- Click on the Date & Time functions category. It will open a drop-down list of functions as shown below screenshot.
Most commonly used DATE & TIME functions are NOW, DATE, WEEKDAY, TODAY, WORKDAY, etc.
Let’s understand this with some examples in the below screenshot.
Example #3
Below are some data.
Please refer the below screenshot where I have applied the functions on values and shown their workings.
MATHEMATICAL Functions in Excel
- Go to FORMULAS tab.
- Click on the Math & Trig functions category. It will open a drop-down list of functions as per below screenshot.
Most commonly used mathematical functions are SUM, SUBTOTAL, RANDBETWEEN, PRODUCT, SQRT etc.
We will understand the working of this function with some example.
Example #4
Let’s take below number series.
Please refer the below screenshot where I have applied the functions on strings and shown their workings.
Things to Remember About Excel Formulas Cheat Sheet
- If you missed or forget any function syntax, then go to FORMULAS tab and click on Insert Function button as per below screenshot or press SHIFT+F3 key. It will open a dialog box as shown in below screenshot.
And choose the function as per requirement from the list.
- Frequently used shortcut keys are:
CTRL+X – Cut
CTRL+V – Paste
CTRL+C – Copy
CTRL+ALT+V / ALT+E+S– Paste Special
CTRL+B – Bold
CTRL+U – Underline
CTRL+I – Italic
CTRL+F – Find
CTRL+P – Print
CTRL+O – Open
CTRL+Z – Undo, etc.
Recommended Articles
This has been a guide to Excel Formulas Cheat Sheet. Here we discuss the TEXT Functions in Excel, STATISTICAL Functions in Excel, DATE & TIME Functions and MATHEMATICAL Functions in Excel along with practical examples and downloadable excel template. You can also go through our other suggested articles –
