Download our Directory

Download our Directory

Download our PETA Directory of Training 2016-2017


Download now



Microsoft Excel – Pivot Tables

Extract data quickly and easily with pivot tables

Who is it for?

For regular users of Excel at an Intermediate level who need to extract key data from a large data source, quickly and effectively.

What will I learn?
  • Creating and customising pivot tables
  • Manipulating the data within pivot tables
  • Interpreting the data

Course Details

  • Location: Portsmouth
  • Duration: 0.5 Day
  • Member: £129
  • Non-Member: £152

All fees subject to VAT

Book this course »
Next steps



Assessment
  • 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

Course Dates
Course commences;

30 January 2017
31 March 2017
26 May 2017
28 July 2017

Company Sponsored Option

This course is also available as a company sponsored option which is for your delegates only, this is a flexible solution and can be tailored to reflect your business needs, delivered on a date, time and place to suit you - please contact us.


Group Discounts

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 Microsoft Word, Excel, PowerPoint, Outlook courses


Our Courses and Services