Error Checking for Excel BI Solutions

What’s in this course

Get the Downloads

• Get All the Files

Introduction to Error Handling

• The Need for Error Handlers

Error Checking Steps & Demos

• Building the Global Framework
• Building a Local Error Checking Solution
• Adding Error Checks to the SCF Worksheet
• Adding Checks to the IS Worksheet
• Counting Total and Unique Table Entries
• Using Table Statistics to Cross Check Summaries
• Checking if a Pivot is Updated
• Adding Pivot Checks into a Model
• Final Testing