Maximising Pivot Tables With Excel

Description

By the end of the course, you will be introduced to the benefits of Pivot tables/reports, update your Pivot table and manipulate only the data you are interested in and make it easier to read. Delegates must be experienced in using Windows and a mouse and at least one other Windows package (for example Word or Excel).

What you will learn

  • Manipulate your pivot table, such as, rearranging the layout, adding and removing fields
  • Group data manually
  • Display subtotals
  • Change the look of your pivot table
  • Show numerical information so it appears as a percentage of the total
  • Use the GETPIVOTDATA function to extract data from a pivot table

Further information

Happy
Provider:
Happy
Duration:
1 Day
Price:
£300 (ex VAT)
Availability:
Scheduled dates
Course type:
Classroom
Locations:
London

Contact Information

Happy

3rd Floor
9 Alie Street
London
E1 8DE

Locations