Analyse, manipulate and present data in pivot tables and pivot charts.

Open participant course: £195 per person - maximum 10 people

Closed company course: £1,000 per course - maximum 10 people

Those who need to produce complex analysis of single and multiple data sets in order to present and manipulating data using pivot tables and pivot charts.

By the end of the course, you will be able to use multiple data sources and produce calculations in Power Pivot and manage pivot table and pivot chart outputs with slicers.

Pivot Table Revision:

• Creating a pivot table.
• Presenting data using pivot charts.
• Filtering pivot data with interactive slicers.

Getting Started and Connecting to Data Sources:

• Introducing Power Pivot and the Power Pivot interface.
• Using the table import wizard.
• Filtering data on import.
• Creating queries to import data.
• Adding data using copy and paste techniques.
• Linking table data.

Related Data Sources:

• Creating additional queries.
• Merge and append queries.
• Creating relationships in Power Pivot.
• Managing relationships.
• Working in diagram view.
• Defining hierarchy groups.
• Producing related data outputs.
• Adding queries to the data model.
• Manipulating the data model.

Working with Power Pivot Formulas:

• Creating calculated columns.
• Using Power Pivot functions.
• Producing measures and KPIs.
• Creating perspectives.

This course can be delivered remotely or in a classroom environment, to suit your requirements.

Attendees should have an advanced understanding of working with Microsoft Excel, including using functions and formulas. A working knowledge of pivot tables and related databases is desirable but not essential.

Attendees must have the following equipment to attend this training remotely:

• PC or laptop with a microphone and speakers (webcam is preferred but not essential).
• Access to the internet and web browser application (e.g. Google Chrome).
• Microsoft Excel installed on the PC or laptop.
• An email account for file sharing.
• A second screen is ideal but not essential.