Excel Pivot Tables - Level 2
 Course Outline

DURATION 3 Hrs
PREREQUISITES You need to know how to create simple Pivot Tables, format them, and use calculations within them.
DESCRIPTION A further look at the power of Pivot tables and Pivot Charts, introducing getting your data from multiple sources, and opening the door to OLAP Cubes!!

Course can be either 2003 or 2007, and is 2003 by default.
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 09:30 - 12:30 £100.00 +VAT
Evening Wed, 22-Feb-12 18:30 - 21:30 £100.00 +VAT
Weekday Wed, 21-Mar-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 24-Mar-12 09:30 - 12:30 £100.00 +VAT
Weekday Mon, 23-Apr-12 09:30 - 12:30 £100.00 +VAT
Evening Mon, 23-Apr-12 18:30 - 21:30 £100.00 +VAT
Weekday Wed, 16-May-12 09:30 - 12:30 £100.00 +VAT
Evening Wed, 23-May-12 18:30 - 21:30 £100.00 +VAT
Weekday Fri, 22-Jun-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 23-Jun-12 09:30 - 12:30 £100.00 +VAT
Weekday Fri, 20-Jul-12 09:30 - 12:30 £100.00 +VAT
Evening Mon, 23-Jul-12 18:30 - 21:30 £100.00 +VAT
Weekday Thu, 16-Aug-12 09:30 - 12:30 £100.00 +VAT
Evening Wed, 22-Aug-12 18:30 - 21:30 £100.00 +VAT
Weekend Sat, 22-Sep-12 09:30 - 12:30 £100.00 +VAT
Weekday Mon, 24-Sep-12 09:30 - 12:30 £100.00 +VAT
Weekday Tue, 16-Oct-12 09:30 - 12:30 £100.00 +VAT
Evening Mon, 22-Oct-12 18:30 - 21:30 £100.00 +VAT
Weekend Sat, 17-Nov-12 09:30 - 12:30 £100.00 +VAT
Weekday Wed, 21-Nov-12 09:30 - 12:30 £100.00 +VAT
Weekend Sat, 22-Dec-12 09:30 - 12:30 £100.00 +VAT
Weekday Mon, 24-Dec-12 09:30 - 12: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.

 

 

 

 

CREATING A USING PIVOT CHARTS

  • What is a Pivot Chart Really?

  • Creating your first Pivot Chart

  • Rules and Limitations of Pivot charts

  • Alternatives to using Pivot Charts

 

USING DISPARATE DATA SOURCES FOR YOUR PIVOT TABLE

  • Working with Disparate Data Sources

  • Using Multiple Consolidation ranges

  • The Anatomy of a Multiple Consolidation range Pivot table

  • Creating a Pivot Table from an Existing Pivot Table

 

USING EXTERNAL DATA SOURCES FOR YOUR PIVOT TABLE

  • External Data Sources

  • Working Around Excel’s Data Management Limitations

  • About MS Query

  • Analyze a dataset with more than 83,000 records with a Pivot Table

  • Importing and Using External data without the PivotTable Wizard

  • Creating Dynamic Pivot Table Reporting Systems

  • Pivot Table data options

 

LEVERAGING THE POWER OF OLAP CUBES

  • Defining OLAP

  • Benefits of OLAP Cubes

  • Introduction to Data Warehouses and OLAP Cubes

  • Connecting to an OLAP Cube

  • Working with an OLAP Pivot Table

  • Comparing OLAP Cube’ Pivot Tables to Excel Data

  • Other Considerations When Using OLAP Cubes