Microsoft Excel - Pivot Tables

This course provides details of how Pivot Tables work and the structure that must be followed to create useful reports.

Created byeLearnExcel

Last updated 9/2013

English

What you'll learn

This course covers the use of Pivot Tables and Pivot Charts, one of the most powerful data analysis tools available in Excel. If you need to work with databases or tables in Excel and report on that data, chances are that Pivot Tables will provide the fastest way to report and build charts on that data.

Course content

1 section • 17 lectures • 1h 0m total length

Introduction0:42
This section includes the exercise files for Pivots Tables. Please download these before you start the course.
Why do we use a pivot table?1:42
Create a pivot table from a list5:17
Formatting the Pivot table2:43
Create a pivot chart from a list2:55
Formatting the Pivot Chart4:23
Refreshing a pivot table and pivot chart4:16
Drill down lists3:12
Slicer tool6:34
Multiple headings in table3:37
Copy and paste into other worksheets3:12
Copy and paste into Word and PowerPoint4:20
Using action settings2:33
Using Calculation settings3:26
Turning on and off option in Show group2:15
Editing Pivot table options4:01
Extra options in Excel 20135:36

Requirements

Intermediate knowledge of Excel

Description

Excel Pivot tables provide a powerful way to summarise and report on vast amounts of Data. You’ll learn in detail how Pivot Tables work and the structure that must be followed to create useful reports and charts. This course is vital to gaining the most from this powerful feature of Excel.

Who this course is for:

Anyone using Excel unfamiliar with Pivot Tables who is working with lists of data, perhaps filtering or sorting that data. Pivot Tables provide a powerful interactive way to query the data and summarise the results quickly and easily.