Locked lesson.
About this lesson
Understanding Excel Formula Anatomy
Exercise files
Download this lesson’s related exercise files.
Formula Anatomy  Begin.xlsx25.7 KB Formula Anatomy  Complete.xlsx
25.8 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.