Excel 2003 Pivot Tables - Level 3

Progressive Training & Development

Course

Inhouse

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Methodology

    Inhouse

  • Class hours

    3h

An introduction to automating Pivot Tables using Visual basic for Applications (VBA)

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

DESCRIPTION
An introduction to automating Pivot Tables using Visual basic for Applications (VBA)


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.


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

See related categories

Excel 2003 Pivot Tables - Level 3

Price on request

The best Excel courses

See all

See all