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
Formulas and worksheet functions are the most important feature of Excel which plays a very important role in Financial and business analysis. With the help of Cheat Sheet Excel Formulas, we can easily do the manipulation, can take out the useful information and insight from the data.
Excel has a number of functions which is very useful for performing day to day operations. Excel Formulas Cheat Sheet saves a lot of time and manual efforts.
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.
4.9 (2,478 ratings)
View Course
Please refer the below screenshot where I have applied the functions on strings and shown their workings.
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 –
