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, a custom way to use 2 or more functions, and guideline to use them. The cheat Sheet also helps fulfil the gap where we need to execute some function, and we don’t know how 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 the FORMULAS tab.
- Click on TEXT functions. A drop-down list will open. Refer to the below screenshot.
As we can see here, several string functions are listed. The 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 to them.
Please refer to the below screenshot, where I have applied the functions on strings and shown their workings.
STATISTICAL Functions in Excel
- Go to the FORMULA tab.
- Click on the More Functions option. Choose Statistical Functions category.
- It will open a drop-down list of functions.
The most commonly used statistical functions are MIN, MAX, COUNT, AVERAGE, MEDIAN, etc.
Example #2
Below are some Number values.
Please refer to the below screenshot, where I have applied the functions on number values and shown their workings.
23 Online Courses | 9 Hands-on Projects| 110+ Hours| Verifiable Certificate of Completion
4.9
View Course
DATE & TIME Functions in Excel
- Go to the FORMULAS tab.
- Click on the Date & Time functions category. It will open a drop-down list of functions, as shown below screenshot.
The 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 to the below screenshot, where I have applied the functions on values and shown their workings.
MATHEMATICAL Functions in Excel
- Go to the FORMULAS tab.
- Click on the Math & Trig functions category. It will open a drop-down list of functions as per the below screenshot.
The 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 to 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, go to the FORMULAS tab and click on the Insert Function button below the screenshot or press the SHIFT+F3 key. It will open a dialog box, as shown in the 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 –
