Excel 2003 Pivot Tables - Level 3
 Course Outline

DURATION 3 Hrs
PREREQUISITES

You need to have Intermediate to Advanced Pivot Table knowledge.  You should have attended Excel VBA Level 1 at a minimum, or at least have some programming experience so that you are aware of basic programming techniques.
DESCRIPTION

An introduction to automating Pivot Tables using Visual basic for Applications (VBA)
COURSE DATES Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Weekday Wed, 22-Feb-12 13:30 - 16:30 £100.00 +VAT
Weekend Thu, 23-Feb-12 18:30 - 16:30 £100.00 +VAT
Weekday Wed, 21-Mar-12 13:30 - 16:30 £100.00 +VAT
Weekend Sat, 24-Mar-12 13:30 - 16:30 £100.00 +VAT
Weekday Mon, 23-Apr-12 13:30 - 16:30 £100.00 +VAT
Weekend Tue, 24-Apr-12 18:30 - 16:30 £100.00 +VAT
Weekday Wed, 16-May-12 13:30 - 16:30 £100.00 +VAT
Weekend Thu, 24-May-12 18:30 - 16:30 £100.00 +VAT
Weekday Fri, 22-Jun-12 13:30 - 16:30 £100.00 +VAT
Weekend Sat, 23-Jun-12 13:30 - 16:30 £100.00 +VAT
Weekday Fri, 20-Jul-12 13:30 - 16:30 £100.00 +VAT
Weekend Tue, 24-Jul-12 18:30 - 16:30 £100.00 +VAT
Weekday Thu, 16-Aug-12 13:30 - 16:30 £100.00 +VAT
Weekend Thu, 23-Aug-12 18:30 - 16:30 £100.00 +VAT
Weekend Sat, 22-Sep-12 13:30 - 16:30 £100.00 +VAT
Weekday Mon, 24-Sep-12 13:30 - 16:30 £100.00 +VAT
Weekday Tue, 16-Oct-12 13:30 - 16:30 £100.00 +VAT
Weekend Tue, 23-Oct-12 18:30 - 16:30 £100.00 +VAT
Weekend Sat, 17-Nov-12 13:30 - 16:30 £100.00 +VAT
Weekday Wed, 21-Nov-12 13:30 - 16:30 £100.00 +VAT
Weekend Sat, 22-Dec-12 13:30 - 16:30 £100.00 +VAT
Weekday Mon, 24-Dec-12 13:30 - 16:30 £100.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £200.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

 

 

 

ENHANCING YOUR PIVOT TABLE REPORTS WITH MACROS

  • Why use Macros with your Pivot Table report?

  • Recording your first macro

  • Creating a User Interface with form controls

  • Altering a Recorded macro to Add functionality

 

 

USING VBA TO CREATE PIVOT TABLES

  • Introduction to VBA

  • Tricks of the trade

  • Versions

  • Build a Pivot Table in Excel VBA

  • Revenue by Model for a Product Line Manager

  • Handle Additional Annoyances

  • Issues with Two or more Data Fields

  • Summarize Date Fields with Grouping

  • Advanced Pivot Table Techniques

  • Control the Sort Order Manually

  • Sum, Average, Count, Min, Max and More

  • Report percentages