Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Pivot Tables to your Wishlist.

Add to Wishlist

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.5 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
422 students enrolled
Created by eLearnExcel
Published 9/2013
$10 $20 50% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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.
View Curriculum
  • Intermediate knowledge of Excel

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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 17 Lectures Collapse All 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

Formatting the Pivot Chart

Refreshing a pivot table and pivot chart

Drill down lists

Slicer tool

Multiple headings in table

Copy and paste into other worksheets

Copy and paste into Word and PowerPoint

Using action settings

Using Calculation settings

Turning on and off option in Show group

Editing Pivot table options

Extra options in Excel 2013
About the Instructor
4.4 Average rating
145 Reviews
1,748 Students
6 Courses
Leading provider of Online Excel training

Our online eLearning courses build on 20 years experience of classroom training. Training is our business. The courses are delivered by our expert tutors and we know where topics become complex and need better explanations because we see it every day in our classrooms.

Some of the world’s most prominent businesses choose us to teach their employees Excel – including Google, Facebook, Pfizer, Zurich, Aer Lingus, Allianz, HSBC, Intel, Dell, KPMG – even Microsoft use our Excel courses to train their employees on Excel.

Report Abuse