About this lesson
Understanding Excel Formula Anatomy
Lesson versions
Multiple versions of this lesson are available, choose the appropriate version for you:
Exercise files
Download the ‘before’ and ‘after’ Excel workbooks from the video tutorial and try the lesson yourself.
Formula Anatomy.xlsx22 KB Formula Anatomy  Completed.xlsx
22 KB
Quick reference
Formula Anatomy
Understanding Excel Formula Anatomy
When to use
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.