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:

  • "The trainer was excellent. Fantastic communication skills, and always trying to ensure the training was linked to our personal experiences and requirements" Simon Sanders, Just Eat
  • "Working with Course Academy was a happy accident for Balfour Beatty Rail Projects. With 36 UK locations and 1300 staff we invest heavily in training and development and the nature of our business (Rail construction) means that safety critical and technical training are always our priority. Course Academy have demonstrated a refreshing approach to customer service and the feedback from people attending courses has been positive." OP - Balfour Beatty Rail Projects Ltd
  • "Great course, with great content. Lots to take away and review, as well as some interesting insights from a very knowledgeable trainer. Will definitely look to attend further AWS training in the future." Mark Conabeare, Landmark Property