Get instant access to our learning portal today
- Work at your pace
- Choose your time & place
- Earn y our certificate
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.