PowerPivot Training Courses in London

We are pleased to announce that we’re now delivering PowerPivot training onsite across London. The course syllabus comprises the following:

  • Introduction to PowerPivot
    • Overview of the PowerPivot window
    • Working with the PowerPivot tab and field list
  • Entering PowerPivot Data
    • Overview of supported data types
    • How to import data into PowerPivot
    • Adding data with Excel Linked Tables
  • Analysing Data
    • Filtering and sorting
    • Creating relational tables
  • Performing Calculations in PowerPivot
    • The Data Analysis Expressions (DAX) language
    • Using formulas in calculated columns
    • Formula Aggregations
  • Creating PowerPivot Tables & Charts
    • Setting up PivotTable & PivotCharts
    • Creating Reporting Services Reports
    • Working with Measures
    • Using Slicers to filter data
    • Working with relationships in PivotTables

This course can be delivered at your offices anywhere in London and surrounding Boroughs. Delegates will require a sound knowledge of Excel get the best from this PowerPivot training and will have preferably attended an Advanced course. Our usual daily training rates apply, please see the Onsite Training page for full details.