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 (17 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
25% off
Take This Course
  • Lectures 17
  • Length 1 hour
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 9/2013 English

Course 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.

What are the requirements?

  • Intermediate knowledge of Excel

What am I going to get from this course?

  • 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.

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.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Create a Pivot Chart from a list

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

Why do we use a pivot table?
Create a pivot table from a list
Formatting the Pivot table
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

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

eLearnExcel, 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.

Ready to start learning?
Take This Course