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
  • Improve decision making from precise and specific results
  • Efficient data analysis, pattern recognition and quick report creation
  • Reduce 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  
10 October 2019 Portsmouth 1 half-day £141.00 £166.00 Spaces Book
10 January 2020 Portsmouth 1 half-day £141.00 £166.00 Spaces Book
17 April 2020 Portsmouth 1 half-day £141.00 £166.00 Spaces Book
3 July 2020 Portsmouth 1 half-day £141.00 £166.00 Spaces Book
10 October 2019
  • Location: Portsmouth
  • Duration: 1 half-day
  • Member +VAT: £141.00
  • Non-member +VAT: £166.00
  • Availability: Spaces
Book
10 January 2020
  • Location: Portsmouth
  • Duration: 1 half-day
  • Member +VAT: £141.00
  • Non-member +VAT: £166.00
  • Availability: Spaces
Book
17 April 2020
  • Location: Portsmouth
  • Duration: 1 half-day
  • Member +VAT: £141.00
  • Non-member +VAT: £166.00
  • Availability: Spaces
Book
3 July 2020
  • Location: Portsmouth
  • Duration: 1 half-day
  • Member +VAT: £141.00
  • Non-member +VAT: £166.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