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:

  • "I enjoyed the course this week, I feel really motivated now to get stuck into my new role. There are many aspects of the course that I plan to implement into the office and am actually looking forward to the changes." KG - MCP Management Consultants Ltd
  • "I enjoyed my AWS Big Data course. I am not sure if it counts as points towards any AWS certification, but it would be good if so. Stas is a good trainer. I struggled the first day given the technical approach, but it came together by day three.Technically, everything worked well.The environment was very pleasant and being able to write on all the walls was quite nice for whiteboarding. The facilities were great, liked the coffee machine and sweet options. " T Dibbens, Supergroup ( Superdry )
  • "Architecture on AWS ; Good facilities and wonderful to have such knowledgable and enthusuastic instruction. The material was well paced and the labs all very well planned. I especially like the reinforcement of learning by having knowledge checks and technical troubleshooting challenges." S Preece, Institute of Physics