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:

  • "Excellent feedback for the attendees. No question was unanswered, even when the attendees thought it was a rather silly. Fabulous Facilitator, would definitely request him again. Would recommend you to anyone. Thank you, one very happy organisation" KW - Fox's Biscuits
  • "We've purchased a range of cloud-based training courses from GO.COURSES - very accommodating in terms of price and scheduling classes." Graham Riddall, Home Office
  • "ASP.NET Training; our 5 attendees had varying levels of programming knowledge and exposure to the Dot Net environment and development tools, we needed the course to be flexible in terms of the pace of the course and the level of detail it went to. The trainer was able to accommodate how we wanted the course to be run. Moreover, he was able to change the content so that we were able to focus on some specific subject areas that we were particularly interested in. All in all, the course was well run." Tom N, Whistlebrook Limited