Microsoft Excel - Pivot Tables
4.1 (30 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
445 students enrolled

Microsoft Excel - Pivot Tables

This course provides details of how Pivot Tables work and the structure that must be followed to create useful reports.
4.1 (30 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
445 students enrolled
Created by eLearnExcel
Last updated 9/2013
English
English [Auto-generated]
Current price: $13.99 Original price: $19.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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.
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.
Course content
Expand 17 lectures 01:00:44
+ Create a Pivot Chart from a list
17 lectures 01:00:44

This section includes the exercise files for Pivots Tables. Please download these before you start the course.

Preview 00:42
Create a pivot chart from a list
02:55
Formatting the Pivot Chart
04:23
Refreshing a pivot table and pivot chart
04:16
Drill down lists
03:12
Slicer tool
06:34
Multiple headings in table
03:37
Copy and paste into other worksheets
03:12
Copy and paste into Word and PowerPoint
04:20
Using action settings
02:33
Using Calculation settings
03:26
Turning on and off option in Show group
02:15
Editing Pivot table options
04:01
Extra options in Excel 2013
05:36