Session Four:
Using Names and the Formula Auditing Tools
Download sample files for the Session
Four sample lessons|
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction and Objectives | [PDF] | [Video] |
 |
| Lesson 4‑1: Automatically create single-cell range names |
 |
||
| Lesson 4‑2: Manually create, single cell range names and named constants | |||
| Lesson 4‑3: Use range names to make formulas more readable | |||
| Lesson 4‑4: Automatically create range names in two dimensions | |||
| Lesson 4‑5: Use intersection range names and the INDIRECT function | |||
| Lesson 4‑6: Create dynamic formula-based range names using the OFFSET function | |||
| Lesson 4‑7: Create table-based dynamic range names | |||
| Lesson 4‑8: Create two linked drop-down lists using range names | |||
| Lesson 4‑9: Understand the #NUM!, #DIV/0! and #NAME? Error Values | |||
| Lesson 4‑10: Understand the #VALUE!, #REF! and #NULL! Error Values | |||
| Lesson 4‑11: Understand background error checking and error checking rules | |||
| Lesson 4‑12: Manually error check a worksheet | |||
| Lesson 4‑13: Audit a formula by tracing precedents | |||
| Lesson 4‑14: Audit a formula by tracing dependents | |||
| Lesson 4‑15: Use the watch window to monitor cell values | |||
| Lesson 4‑16: Use Speak Cells to eliminate data entry errors | [PDF] | [Video] |
|
| Session 4: Exercise | [PDF] |
|
|
| Session 4 Exercise Answers | |||
Session Four:
Using Names and the Formula Auditing Tools
Download sample files for the Session
Four sample lessons|
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction and Objectives | [PDF] | [Video] |
|
| Lesson 4‑1: Automatically create single-cell range names |
|
||
| Lesson 4‑2: Manually create, single cell range names and named constants | |||
| Lesson 4‑3: Use range names to make formulas more readable | |||
| Lesson 4‑4: Automatically create range names in two dimensions | |||
| Lesson 4‑5: Use intersection range names and the INDIRECT function | |||
| Lesson 4‑6: Create dynamic formula-based range names using the OFFSET function | |||
| Lesson 4‑7: Create table-based dynamic range names | |||
| Lesson 4‑8: Create two linked drop-down lists using range names | |||
| Lesson 4‑9: Understand the #NUM!, #DIV/0! and #NAME? Error Values | |||
| Lesson 4‑10: Understand the #VALUE!, #REF! and #NULL! Error Values | |||
| Lesson 4‑11: Understand background error checking and error checking rules | |||
| Lesson 4‑12: Manually error check a worksheet | |||
| Lesson 4‑13: Audit a formula by tracing precedents | |||
| Lesson 4‑14: Audit a formula by tracing dependents | |||
| Lesson 4‑15: Use the watch window to monitor cell values | |||
| Lesson 4‑16: Use Speak Cells to eliminate data entry errors | [PDF] | [Video] |
|
| Session 4: Exercise | [PDF] |
|
|
| Session 4 Exercise Answers | |||