Excel 2003 Pivot Tables - Level 2

Progressive Training & Development

Course

In Southwark

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    Southwark

  • Class hours

    3h

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!!

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

You need to know how to create simple Pivot Tables, format them,
and use calculations within them.

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
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!!

PREREQUISITES
You need to know how to create simple Pivot Tables, format them, and use calculations within them.

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

See related categories

Excel 2003 Pivot Tables - Level 2

Price on request

The best Excel courses

See all

See all