Making head or tail of PivotTables

Microsoft Office version 2010; 2013 and 2016

Use PivotTables and PivotCharts with comfort and ease

One of the most powerful features in the Excel package, PivotTables are widely recognised for their applications – but very rarely is their full functionality ever harnessed. In fact, current estimates show that as few as 12% of Excel users ever utilise PivotTables – with only a handful of that 12% harnessing the full range of functionality available to them.

PivotTable power has increased and if you do any of these, you can do it better and faster and with PivotTables:

• Analyse data to identify trends
• Detailed reporting and analysis
• PivotTables are the answer to get the reports you want

Understanding PivotTables and PivotCharts

• Understanding How PivotTables Work
• Working with PivotTables
• Creating a PivotTable Report
• Creating a PivotTable Report with Multiple Columns
• Creating a PivotChart

Understanding Data Sources for PivotTables

• Using Excel Data from the Same Workbook
• Using Excel Data from another Workbook
• Using Data from Databases
• Queries
• OLAP Cubes
• Creating a PivotTable Report from Data in an Access Database
• Using Other External Data Sources

Using PivotTable Tools and Formatting

• Using the Layout Dialog Box in the PivotTable and Pivot Chart Wizard
• Understanding the PivotTable Toolbar
• Customizing the PivotTable Toolbar
• Using the PivotTable Menu
• Setting PivotTable Options
• Format Options
• Data Options
• Formatting PivotTables
• Autoformatting a PivotTable
• Changing the Number Format
• Changing Other Formats
• Applying Formatting to a PivotTable Report

Working with PivotTable Components

• Using Drop Areas
• Using the Column Drop Area
• Using the Data Drop Area
• Using the Page Drop Area
• Using Settings for Data Fields
• Using Different Summary Functions
• Sort Options

Understanding and Using PivotCharts

• Understanding PivotCharts
• Creating a PivotChart
• Create a PivotChart from an Existing PivotTable
• Create a PivotChart from Scratch
• Understanding and Changing PivotChart Types
• Understanding a PivotChart's Structure
• Creating a 3-D PivotChart

Using PivotTables with Multidimensional Data

• Using Multidimensional Data
• Understanding Multidimensional Data
• Flat Data
• Relational Data
• Multidimensional Data
• Creating a PivotTable from a Cube File
• Working with OLAP PivotTables

Who should attend?

• Marketing Managers
• Sales Managers
• Financial Managers
• Chief Information Officers
• Business Analysts

Training approach

Our courses use interactive tools that allow learners to learn by doing.

The experience for learners is fun, rewarding, lasting and integrative, whilst employers are assured of a high return on investment in training.