Master Excel: Ultimate Formulas Cheat Sheet

Gregory Jul 09, 2026

Excel, a staple in the world of data management, offers a plethora of formulas to streamline tasks and extract valuable insights. To help you navigate this powerful tool, we've compiled a useful cheat sheet of essential Excel formulas. Whether you're a beginner or an experienced user, this guide will serve as a handy reference to boost your productivity.

Excel formulas cheat sheet | All formulas
Excel formulas cheat sheet | All formulas

Before we dive into the formulas, let's quickly recap the basic structure of an Excel formula: `=operator(function(argument1, argument2, ...))`. The operator is usually `=` or `-`, the function is the action you want to perform, and the arguments are the values or cells you want the function to act upon.

Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know
Excel Functions Cheat Sheet | 50+ Essential Formulas Every Beginner Should Know

Arithmetic Operators

Arithmetic operators are the backbone of Excel formulas. They allow you to perform basic mathematical operations.

Top 21 Excel Formulas
Top 21 Excel Formulas

1. Addition: `+`

2. Subtraction: `-`

Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips

3. Multiplication: `*`

4. Division: `/`

Basic Arithmetic Formulas

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

Let's say you have two cells, A1 with the value 5 and B1 with the value 3. Here's how you can perform basic arithmetic operations:

  • Addition: `=A1+B1` (result: 8)
  • Subtraction: `=A1-B1` (result: 2)
  • Multiplication: `=A1*B1` (result: 15)
  • Division: `=A1/B1` (result: 1.6667)

Order of Operations

📗 Basic Excel Formulas Every Beginner Should Know! ✨📊
📗 Basic Excel Formulas Every Beginner Should Know! ✨📊

Excel follows the order of operations (PEMDAS/BODMAS), which means it performs calculations in the following sequence:

  1. Parentheses
  2. Exponents
  3. Multiplication and Division (from left to right)
  4. Addition and Subtraction (from left to right)
Top Excel Formulas Cheat Sheet for Students
Top Excel Formulas Cheat Sheet for Students
ms excel formula
ms excel formula
Complete Excel Formula Cheat Sheet | Excel Functions, Shortcuts & Tips for Students
Complete Excel Formula Cheat Sheet | Excel Functions, Shortcuts & Tips for Students
Excel Shortcut Keys Cheat Sheet
Excel Shortcut Keys Cheat Sheet
Excel Formulas
Excel Formulas
the top 2 excel formulas are shown in this poster, and it is also available for
the top 2 excel formulas are shown in this poster, and it is also available for
the excel formula is shown in this screenshote, and shows how to use it
the excel formula is shown in this screenshote, and shows how to use it
Excel Formulas Cheat Sheet (Part 2) | Advanced & Useful Functions
Excel Formulas Cheat Sheet (Part 2) | Advanced & Useful Functions
10 Easy Excel Formulas Every Beginner Should Know | Excel Tips Cheat Sheet
10 Easy Excel Formulas Every Beginner Should Know | Excel Tips Cheat Sheet
an image of a table with numbers and times for each item in the menu or order
an image of a table with numbers and times for each item in the menu or order
30+ Excel Shortcuts Every Professional Should Know
30+ Excel Shortcuts Every Professional Should Know
the top 15 excel formulas are written on lined paper with different symbols and numbers
the top 15 excel formulas are written on lined paper with different symbols and numbers
Excel Functions Cheat Sheet
Excel Functions Cheat Sheet
Excel Formulas: Basic to Advanced
Excel Formulas: Basic to Advanced
102 Useful Excel Formulas Cheat Sheet PDF (Free Download Sheet) - ExcelDemy
102 Useful Excel Formulas Cheat Sheet PDF (Free Download Sheet) - ExcelDemy
Excel Formulas Cheatsheet
Excel Formulas Cheatsheet
Excel Functions Cheat Sheet | Logical Functions & Text Functions Guide
Excel Functions Cheat Sheet | Logical Functions & Text Functions Guide
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
an open notebook with the text ms excel formulas written in black ink on it
an open notebook with the text ms excel formulas written in black ink on it
Ultimate Excel Cheat Sheet for Data Analysis (2026)
Ultimate Excel Cheat Sheet for Data Analysis (2026)

Built-in Functions

Excel offers a wide range of built-in functions to perform complex calculations and data analysis.

1. SUM: Adds up a range of cells. Syntax: `=SUM(range)`

2. AVERAGE: Calculates the average of a range of cells. Syntax: `=AVERAGE(range)`

3. MAX: Returns the maximum value in a range of cells. Syntax: `=MAX(range)`

4. MIN: Returns the minimum value in a range of cells. Syntax: `=MIN(range)`

Using Built-in Functions

Let's say you have a range of cells A1:A5 with values 1, 2, 3, 4, and 5. Here's how you can use the built-in functions:

  • Sum: `=SUM(A1:A5)` (result: 15)
  • Average: `=AVERAGE(A1:A5)` (result: 3)
  • Max: `=MAX(A1:A5)` (result: 5)
  • Min: `=MIN(A1:A5)` (result: 1)

Absolute and Relative References

Excel formulas use cell references to perform calculations. Understanding absolute and relative references is crucial for creating flexible formulas.

Absolute reference: `$A$1`

Relative reference: `A1`

Text Functions

Text functions allow you to manipulate and extract data from text strings.

1. LEN: Returns the number of characters in a text string. Syntax: `=LEN(text)`

2. UPPER: Converts text to uppercase. Syntax: `=UPPER(text)`

3. LOWER: Converts text to lowercase. Syntax: `=LOWER(text)`

4. PROPER: Capitalizes the first letter of each word in a text string. Syntax: `=PROPER(text)`

Using Text Functions

Let's say you have a cell A1 with the text "hello world". Here's how you can use the text functions:

  • Length: `=LEN(A1)` (result: 11)
  • Uppercase: `=UPPER(A1)` (result: HELLO WORLD)
  • Lowercase: `=LOWER(A1)` (result: hello world)
  • Proper case: `=PROPER(A1)` (result: Hello World)

Mastering these essential Excel formulas will not only save you time but also help you uncover valuable insights from your data. As you become more comfortable with these formulas, you can explore more advanced functions and techniques to further enhance your Excel skills. Happy calculating!