Microsoft Excel Pivot Tables

PET002104

Interactive tables summarising data quickly and easily

Who is it for?

This is the ideal course for people who regularly need to extract data and put it into a format that enables clever and quick analysis of information to inform the user.

Business benefits
  • Improved decision making from precise and specific results
  • Efficient data analysis, pattern recognition and quick report creation
  • Reduced time spent sorting or editing data
Course overview
  • Creating pivot tables and adding in data
  • Creating pivot charts
  • Changing the pivot table layout
  • Making separate pivot tables
  • Refreshing data and updating pivot tables
  • Using custom calculations in a pivot table
  • Grouping and ungrouping pivot table items

Sponsored option

This course is available as a company sponsored event, delivered at a location, date and time which is mutually agreed. The fees for this event vary depending on the location, number attending and the level of training required and the degree of customisation. Please contact us to discuss your requirements.


Next steps


Course dates and fees
Start date Location Duration Member
+VAT
Non-member
+VAT
Availability  
29 January 2019 Portsmouth 1 half-day £137.00 £162.00 Spaces Book
23 April 2019 Portsmouth 1 half-day £137.00 £162.00 Spaces Book
26 July 2019 Portsmouth 1 half-day £137.00 £162.00 Spaces Book
29 January 2019
  • Location: Portsmouth
  • Duration: 1 half-day
  • Member +VAT: £137.00
  • Non-member +VAT: £162.00
  • Availability: Spaces
Book
23 April 2019
  • Location: Portsmouth
  • Duration: 1 half-day
  • Member +VAT: £137.00
  • Non-member +VAT: £162.00
  • Availability: Spaces
Book
26 July 2019
  • Location: Portsmouth
  • Duration: 1 half-day
  • Member +VAT: £137.00
  • Non-member +VAT: £162.00
  • Availability: Spaces
Book

Group discounts are available for this course

Take advantage of these discounts when booking this course;

  • 5% off for 2-3 people
  • 8% off for 4-5 people
  • 12% off for 6 or more people
« All Corporate Courses courses


Our Courses and Services