Cheat Sheet of Excel Formulas

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

Cheat Sheet of Excel Formulas

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 of 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.

In this Excel Formulas Cheat Sheet 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.

Cheat Sheet of Excel Formulas – 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.

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.

Cheat Sheet of Excel Formulas – Example #2

Below are some Number values.

Excel Course 20 Online Courses | 80+ Hours | Verifiable Certificate of Completion | Lifetime Validity Watch The Course Preview

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 below screenshot.

Cheat Sheet of Excel Formulas – 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 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.

Cheat Sheet of Excel Formulas – 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 Cheat Sheet of Excel Formulas

• 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.

You can download this Cheat Sheet Excel Formulas Template here – Cheat Sheet Excel Formulas Template

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 –

1. Top 25 Advanced Excel Formulas and Functions
2. Best Examples OF MIN Function in Excel
3. MS Excel: LARGE Function
4. Guide To NOW Function in Excel