Error Checking For Excel BI Solutions Course Page
| Module 1 | Introduction to Error Handling |
|---|---|
| Unit 1 | The Need For Error Handling |
| Module 2 | Error Checking Steps & Demos |
| Unit 1 | Building The Global Framework |
| Unit 2 | Building A Local Error Check Solution |
| Unit 3 | Adding Error Checks to the SCF Worksheet |
| Unit 4 | Adding Error Checks To The IS Worksheet |
| Unit 5 | Counting Total And Unique Table Entries |
| Unit 6 | Using Table Statistics To Cross Check Summaries |
| Unit 7 | Checking If A Pivot Is Updated |
| Unit 8 | Adding Pivot Checks Into A Model |
| Unit 9 | Final Testing |