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:

  • "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
  • "Initial contact with I.T. training companies proved a waste of time as no one seemed able to accommodate our requirements. Then I contacted Course Academy, who couldn't have been more flexible and helpful in tailoring a package to suit our needs, within our tight budget and time frame. The course was conducted on-site, which really suited our needs. We could not have been more satisfied with the service received from Course Academy." LA - North East Wales NHS Trust
  • "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