Technical Skills / Computer Applications, Software and Infrastructure

Microsoft Excel Pivot Tables

PET002104

Interactive tables summarising data quickly and easily

Course overview

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

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

Improved decision making from efficient data analysis using pattern recognition. Providing a report creation tool for moving ‘unorganised’ to ‘organised’ data.

Course dates and fees

Date
When is it?
Location
Where do I go?
Duration
How long is it?
Availabilty
Remaining space?
Member
Fees + VAT
Non-Member
Fees + VAT
  Book
Add delegate(s)
Date: 26 Mar 2021 Location: Portsmouth Duration: 1 half-day Availability: Spaces Member Price: £141.00 (Fees + VAT) Non-Member Price: £166.00 (Fees + VAT)
Date: 30 Jul 2021 Location: Portsmouth Duration: 1 half-day Availability: Spaces Member Price: £141.00 (Fees + VAT) Non-Member Price: £166.00 (Fees + VAT)

Enquire about this course.