Session Two:
Data Integrity, Subtotals and Validations
Download sample files for the Session Two sample lessons
|
Lesson |
Lesson |
High Res Video |
|
|---|---|---|---|
| Introduction and Objectives | [PDF] | [Video] |
 |
| Lesson 2 1: Keep data atomic using Text to Columns |
 |
||
| Lesson 2 2: Remove duplicate values from a range or table | |||
| Lesson 2 3: Automatically subtotal a range | |||
| Lesson 2 4: Create nested subtotals | |||
| Lesson 2 5: Consolidate data from multiple data ranges | |||
| Lesson 2 6: Use data consolidation to generate quick subtotals from tables | |||
| Lesson 2 7: Validate numerical data | [PDF] | [Video] |
|
| Lesson 2 8: Create user-friendly messages for validation errors |
|
||
| Lesson 2 9: Create data entry Input Messages | |||
| Lesson 2 10: Add a formula-driven date validation and a decimal validation | |||
| Lesson 2 11: Add a dynamic list validation based upon a table | |||
| Lesson 2 12: Use a function-driven custom validation to enforce complex business rules | |||
| Lesson 2 13: Use a custom validation to add a unique constraint to a column | |||
| Session 2: Exercise | [PDF] |
|
|
| Session 2 Exercise Answers | |||