Pivot Tables

Description

How will this course help me?

Do you  have to work with data, and then create reports from that data?  It might be adding how many sales from a particular client or how many of a product have been sold.  A Pivot Table can do this for you in minutes.  This course will show you how the data needs to be organised for a Pivot Table to work, as well as showing you how to create, edit, and manipulate a Pivot Table.  By the time you have finished, you will be a Pivot Table Whizz!

Who should do this course?

Anyone who has to produce reports based on lots of data.  People who want to improve their Excel knowledge, and career prospects.

What will you learn?

How to structure your data for a Pivot Table

How to create and amend a Pivot Table

How to extract data from a Pivot Table

How to group, count, sum in a Pivot Table

How to use Filters and Slicers

Pre Course Learning

Tables course or Excel Intermediate

What will I get out of the course?

You will learn how to get the best out of your data with a Pivot Table.  You will also receive a certificate.