Course Academy are experts in the delivery of Microsoft Excel training which forms part of our core competencies as a provider of learning and development services. One area within Excel which we are often asked to focus on are Pivot Tables.

Pivot Tables are an extremely useful feature within Microsoft Excel and when correctly used provide an invaluable tool to the user.  During our Pivot Tables training sessions we cover the following areas:

• PivotTable Hints and Tips
• Connecting to External Data with PivotTables
• PowerPivot Overview
• Where do I get PowerPivot from?
• Identifying PowerPivot
• Connecting to Data Different Sources
• Pasting data into PowerPivot
• Checking PowerPivot can Produce Results
• Excel (flat-file database) as a Data Source
• Importing Data from SharePoint Lists to PowerPivot
• Excel (linked tables) as a Data Source
• PowerPivot Relationships
• Access Tables (relational database) as a Data Source
• SQL Databases as a Data Source
• Creating a Perspective to make Field Lists Manageable
• Filtering Data during Importing External Data
• Database Tables as a Data Source Writing SQL Statements
• The Diagram View in PowerPivot
• Managing Relationships and Tables in the Diagram View
• Working with Hierarchies
• Measures Overview
• Create a Calculated Column
• Creating a Measure
• AutoSum Measures
• User Created Measures
• Working with Dates in a PowerPivot Environment
• Creating a KPI
• Adding a KPI to a PivotTable
• Sample DAX Functions
• Writing DAX Functions
• Time Intelligent Functions
• Layout Styles
• Using Slicers
• Additional Slicer Settings
• Locking a Slicer to a PivotTable

All our Pivot Tables training sessions can be tailored to your specific needs so if you would like us to focus on one particular area then this is not a problem.

Our Microsoft Excel trainers are all qualified to MCT level and have a huge range of knowledge and real world experience so you will receive a training session that adds real value to your business.

Popular courses include:

Microsoft Excel 2010 Level 2

Dates and booking

Microsoft Excel 2010 Level 3

Dates and booking

Microsoft Excel 2010 PowerPivot

Dates and booking

Microsoft Excel 2013 Level 2

Dates and booking

Microsoft Excel 2013 PowerPivot

Dates and booking

All our courses meet the highest criteria but don't just take our word for it, see what some of our clients have said:

  • "Great course, really knowledgeable trainer with real world expertise" J Adams, Private bank
  • "Microsoft implementing Active Directory Federation Services M50412: I came over especially for the training with CourseAcademy; It was tailored perfectly , lots of hands on training in a great London facility off Leadenhall Court - Thank you" Qamar Rathore, Hoffman La Roche
  • "I've gained a huge amount from this course so thanks for allowing us to be on it. There is a lot of stuff I need to type up into my own words and process thoroughly but it has been massively beneficial and would love to attend some more of these. Especially the things based around psychology and NLP, as that's most relative to my role. " 4Com PLC