Subscriber only lesson.

Sign up to the Microsoft Excel - Basic & Advanced course to view this lesson.

## About this lesson

Understanding Excel Formula Anatomy

## Lesson versions

Multiple versions of this lesson are available, choose the appropriate version for you:

2013, **2016**.

## Exercise files

Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.

Formula Anatomy.xlsx14.4 KB Formula Anatomy - Completed.xlsx

14.5 KB

## Quick reference

### Topic

Understanding Excel Formula Anatomy

### Where/when to use the technique

Use to understand the anatomy of Excel formulas, and how to build them.

### Instructions

#### What is a Formula?

- Excel’s method to return data based on a question or equation you have provided.

#### Key points to remember

- Every formula starts with =
- Equations started with - will convert to =-
- Equations started with + will convert to =

- Formula inputs can be:
- Numbers or text
- Ranges
- Excel Functions

- Formulas can be used to:
- Add two numbers: =1+5
- Add values in ranges: =A1+B1
- Perform more complex operations

- Mathematical formulas are always evaluated based on the order of operations:
- Brackets (Parenthesis)
- Exponents
- Multiplication and Division
- Addition and Subtraction

- Mathematical Operators
- Brackets: ( )
- Exponents: ^
- Add: +
- Subtract: -
- Multiply: *
- Divide: /

Lesson notes are only available for subscribers.