Lesson 1: Working with the PivotTable Object
Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with PivotTable Objects
Working with PivotFields Collection
Assigning a Macro to the Quick Access Toolbar
Lesson 2: Debugging Code
Understanding Errors
Using the Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions
Lesson 3: Handling Errors
Understanding Error Handling
Understanding VBA’s Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling
Programme scope, delivery arrangements and suitability are confirmed during enquiry.