Cheat Sheet Of Excel Formulas

Updated on December 26, 2023
Article byWallstreetmojo Team
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

What Is Cheat Sheet Of Excel Formulas?

Cheat Sheet of Excel Formulas is a one-point destination customized sheet, so to speak, for Excels most important or frequently used formulas. It contains a list of Excel’s inbuilt formulas, shortcuts, and instructions to combine two or more functions, for easy access and use.
Different Excel formulas with respective examples are explained in the article below, and it focuses on TEXT, STATISTICAL, DATE & TIME, MATHEMATICAL functions, and many more.

Key Takeaways

• The Cheat Sheet of Excel Formulas acts like an index or dictionary that helps us use the frequently or commonly used formulas, functions, and keyboard shortcuts, to use easily.
• The Cheat Sheet also contains the Keyboard Shortcuts that come in handy when it’s hard to remember the path that leads to perform those specific functions on the Excel ribbon. It also helps to save time and increase productivity.
• As per our requirement, we can introduce or add as many formulas or functions, such as Text, Statistical Functions, Date & Time,Mathematical Functions, and shortcuts.

Excel Formulas For Cheat Sheet

The Excel Formulas for Cheat Sheet available are as follows:

1. Text Functions in Excel
2. Statistical Functions in Excel
3. Date and Time Functions in Excel
4. Mathematical Functions in Excel

Different Excel Formulas with respective examples are explained below.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

#1 – Text Functions in Excel

MS Excel offers a variety of string functions. Some Excel formulas cheat sheet is given below. The table contains the function’s name, meaning, syntax, example, and explanation.

The above-explained Cheat Sheet of Excel Formulas examples is implemented in the Excel worksheet shown in the following screenshot.

For eg:
Source: Cheat Sheet Of Excel Formulas (wallstreetmojo.com)

#2 – Statistical Functions in Excel

MS Excel offers a variety of statistical functions. Some Excel formulas cheat sheet is given below. The table contains the function’s name, meaning, syntax, example, and explanation.

The above-explained Cheat Sheet of Excel Formulas examples is implemented in the Excel worksheet shown in the following screenshot.

For eg:
Source: Cheat Sheet Of Excel Formulas (wallstreetmojo.com)

#3 – Date and Time Functions in Excel

MS Excel offers a variety of date and time functions. Some Excel formulas cheat sheet is given below. The table contains the function’s name, meaning, syntax, example, and explanation.

The above-explained Cheat Sheet of Excel Formulas examples is implemented in the Excel worksheet shown in the following screenshot.

For eg:
Source: Cheat Sheet Of Excel Formulas (wallstreetmojo.com)

#4 – Mathematical Functions in Excel

MS . Some Excel formulas cheat sheet is given below. The table contains the function’s name, meaning, syntax, example, and explanation.

The above-explained Cheat Sheet of Excel Formulas examples is implemented in the Excel worksheet shown in the following screenshot.

For eg:
Source: Cheat Sheet Of Excel Formulas (wallstreetmojo.com)

Important Things To Note

• The formulas entered in the Cheat Sheet must be with the correct syntax. Else, we may get an error when using it for calculations.
• When we use the shortcuts or formulas from the sheet, we must remember the sheet is for our reference. Therefore, look up the required details and use them, but never copy-paste.

1. Name some common Basic Excel formulas included in Cheat Sheet of Excel Formulas.

Some of the Basic formulas one may use commonly in Excel are:
• SUM – Finds the total of the selected numeric cell values.
• AVERAGE – Finds the total of the selected numeric cell values.
• MAX – In a selected numeric cell range, it finds the Maximum cell value.
• MIN – In a selected numeric cell range, it finds the Minimum cell value.
• COUNT – In a selected numeric cell range, it counts only the cells with numeric values.

2. What are the steps to merge cells in Excel?

The cells should be blank or empty, else we may lose data.
The cells should be adjacent, either to the right, left, top, or bottom.
Next, follow the path given below to merge cells in Excel:
First, choose the cells we want to merge – select the “Home” tab – go to the “Alignment” group – click the “Merge & Center” option, as shown below.

If we want the merged alignment elsewhere to keep the text aligned to the left or right, we have a few other options when we click the “Merge & Center” option drop-down, such as “Merge Across” or “Merge Cells”, and choose as desired, as shown below.

Finally, the selected cells will merge into one cell. If there were any text in the original cells, it would appear centered in the new merged cell.

3. Name some Ctrl shortcuts found in the Cheat Sheet of Excel Formulas.

Some Ctrl shortcuts that may be found in the Cheat Sheet are:
Ctrl+S – It helps us save the changes while working on Excel.
• Ctrl+X – It helps us cut data either to remove/delete, or to paste it elsewhere.
• Ctrl+C – It helps us copy the data either to move, or to paste it elsewhere.
• Ctrl+V – It helps us paste the data that was just cut or copied.
Ctrl+Z – It helps us undo the data just added.
Ctrl+Y – It helps us redo the data that was just undone.
Ctrl+S – It helps us save the changes while working on Excel.
Ctrl+Shift+=: It helps us to insert a new column/row into the worksheet.