Formula Auditing Examples
Formula Auditing Ex 1
To follow along go to sheet 20.2
Find the errors in this spreadsheet
To see the full course contents click here.
Select Your Currency
Intermediate Excel Course
Collapse
Expand
-
Function and Formula Basics
- Tip- Opening Frequent files
- Enter formula into many cells (at the same time)
- Function Wizard
- Auditing Toolbar
- Formula Auditing Examples
- Referring to fixed cells
- Using the F4 shortcut for $ signs
- Dollar Sign ($A$1) Examples
- The basic “IF” function
- If THIS then THAT Examples
