✦Template Printable Ideas Insights

Excel Formulas Cheat Sheet with Examples

By

Excel is a vital tool for data management, analysis, and visualization. Understanding its formulas is key to unlocking its full potential. This comprehensive Excel formulas cheat sheet offers a quick reference with examples to help you master the essential formulas for common tasks.

Let's explore these formulas, categorized into two main topics: Arithmetic and Text Manipulation.

Arithmetic

The Arithmetic category includes formulas for performing basic calculations, such as addition, subtraction, multiplication, and division.

Top 25 Basic Excel Formulas Every Beginner Must Know
Top 25 Basic Excel Formulas Every Beginner Must Know
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Excel Formula Cheat Sheet Printable - Excel Functions Guide PDF - Excel Reference Sheet Digital Download
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips

Here are some essential arithmetic formulas with examples:

SUM

The SUM function adds up a list of values. The syntax is =SUM(number1, number2, ...). For example, if you have the values 5, 10, and 15 in cells A1, A2, and A3, the formula in cell A4 would be =SUM(A1:A3) and it would display the sum, 30.

Top 21 Excel Formulas
Top 21 Excel Formulas
10 Easy Excel Formulas Every Beginner Should Know | Excel Tips Cheat Sheet
10 Easy Excel Formulas Every Beginner Should Know | Excel Tips Cheat Sheet
Complete Excel Formula Cheat Sheet | Excel Functions, Shortcuts & Tips for Students
Complete Excel Formula Cheat Sheet | Excel Functions, Shortcuts & Tips for Students

You can also use the fill handle to drag the SUM formula across multiple cells. Suppose you have numbers in cells A1 to A10. After typing =SUM( into cell A11, drag the fill handle across cells A12 to A20, and click Enter. It will sum the values from A1 to A10 and display the result in cells A11 to A20.

AVERAGE

The AVERAGE function calculates the average (or mean) of a list of values. The syntax is =AVERAGE(number1, number2, ...). For example, if you have the values 5, 10, and 15 in cells B1, B2, and B3, the formula in cell B4 would be =AVERAGE(B1:B3) and it would display the average, 10.

Similar to the SUM function, you can use the fill handle to apply the AVERAGE formula to multiple cells.

an excel chart with many different types of items and numbers on the page, including office hours
an excel chart with many different types of items and numbers on the page, including office hours
Excel formulas cheat sheet | All formulas
Excel formulas cheat sheet | All formulas
Excel Formulas Cheatsheet
Excel Formulas Cheatsheet
a table with the names and numbers of different types of items in each column,
a table with the names and numbers of different types of items in each column,
50+ Essential Excel Keyboard Shortcuts | Ultimate Cheat Sheet for Beginners
50+ Essential Excel Keyboard Shortcuts | Ultimate Cheat Sheet for Beginners
Excel Functions Cheat Sheet | Logical Functions & Text Functions Guide
Excel Functions Cheat Sheet | Logical Functions & Text Functions Guide

Text Manipulation

Text Manipulation formulas help you clean, convert, and combine text strings for better readability and analysis.

Here are some useful text manipulation formulas with examples:

CONCATENATE

The CONCATENATE function combines a list of values into a single text string. The syntax is =CONCATENATE(text1, text2, ...). For example, if you have 'Hello' in cell C1 and 'world' in cell C2, the formula in cell C3 would be =CONCATENATE(C1, C2) and it would display the combined string, 'Hello world'.

Top Excel Formulas Cheat Sheet for Students
Top Excel Formulas Cheat Sheet for Students
the top 30 excel formulas for data and texting are shown in this poster
the top 30 excel formulas for data and texting are shown in this poster
the basic guide to excelif formulas for beginners and advanced students in english
the basic guide to excelif formulas for beginners and advanced students in english

Starting with Excel 2016, the CONCAT function (syntax: =CONCAT(text1, text2, ...)) is recommended over CONCATENATE, as it is simpler and more intuitive to use.

LEFT, RIGHT, and MID

These functions help extract parts of a text string. The LEFT function retrieves text from the left side ( starting from the first character), RIGHT retrieves text from the right side (starting from the last character), and MID retrieves text from a specified starting character.

For example, if you have the string 'Hello World' in cell D1, the following formulas would display: - LEFT(D1, 5): 'Hello' - RIGHT(D1, 5): ' World' - MID(D1, 7, 5): 'World'

Integrating these formulas into your Excel workflow will enhance your data processing, analysis, and visualization capabilities. To further expand your skills, consider exploring more advanced formulas like IF, IFS, VLOOKUP, and XLOOKUP. Happy calculating!