Error Checking For Excel BI Solutions Course Page - Excel TV Members
Excel TV Members
Share The LOVE

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
>