Call Me Back

Page 1

Looking for more information?

Complete your details below and we'll call you back



Course Type


Price Per Delegate

£245 +VAT
Public Scheduled Course

Price Per Course

£745 +VAT
On-Site at Customer Premises, Max 10 Delegates


1 Day

Full/Part Time

Part Time


SmartStyle Training

Book course

This course is intended for users who need to perform complex analysis of single and multiple data sets in order to present and manipulate data using Pivot Tables and Pivot Charts.


At the end of the course users will be able to use multiple data sources and produce calculations in PowerPivot and manage Pivot Table and Pivot Chart outputs with slicers.


An advanced understanding of working with Excel including using Functions and Formulas. A sound working knowledge of Pivot Tables and Related Databases is desirable but not essential.

Download Outline (PDF)

Pivot Table Revision
  • Creating a Pivot Table
  • Presenting Data using Pivot Charts
  • Filtering Pivot Data with Interactive Slicers
Getting Started & Connecting to Data Sources
  • Introducing Power Pivot
  • Working in the Power Pivot Screen
  • Using the Table Import Wizard
  • Filtering Data on Import
  • Creating Queries to Import Data
  • Adding Data with Copy & Paste
  • Linking Table Data
Related Data Sources
  • Related Data Sources
  • Creating Additional Queries
  • Merge & 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 & KPI’s
  • Creating Perspectives

Enquire about a course

Fill in your information to apply for this course. The information you provide on this application form may be passed to funding bodies, in line with the Data Protection Act 1998, and may be shared with other training providers and possible employers for the purpose of administration, statistical and research purposes.