Excel Pivot Tables Demystified for Beginners

A 6-part course that demystifies pivot tables
4.3 (4 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.
144 students enrolled
25% off
Take This Course
  • Lectures 8
  • Length 32 mins
  • Skill Level Beginner 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 12/2013 English

Course Description

A 6-part course that demystifies pivot tables. This course assumes that you are a beginner to Excel. All that is required for you to do is to follow through the video and understand the basic concepts. This course is strcutured in a way to only focus on the most important elements of creating and working with Pivot tables.

What are the requirements?

  • Any version of MS Excel
  • Basic working knowledge of Excel

What am I going to get from this course?

  • This course will give the skills required to use pivot tables.
  • This course will empower you to take your data and work with it in new and different ways.

Who is the target audience?

  • This course is appropriate for users who are familiar with basic excel functions.
  • This course is also targeted to the users who want an easy and dynamic way to summarize and analyse data

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: Excel PivotTables Demystified

The first thing that the Pivot tables need is to make sure that the data which needs to be analyzed has to be in a specific format. For example if you have a blank column in your table, Pivot tables will want you to either delete that blank column or add some content to it. This lesson deals with the ways to normalise your data in a way suitable enough for the Pivot tables to use.


Now that we have the normalized data, in this lecture we will learn how do we go about creating the Pivot table.


Now that you have the Pivot table ready, you may need to customize it a bit to make sure it looks a bit more user friendly than what it is with the default options. You will learn how to apply different number formats, and how to change the layout of the Pivot tables in a way which brings the key information to the surface.


In this lecture, you take a step further and see how do we apply conditional formatting to the Pivot table results to highlight the content which would be of most interest to the audience.


In this lecture, you learn how to show the information you have in your Pivot table in charts. The default Excel charts may not work very well with the pivot table information. This is where the Pivot charts come into play with a very easy way to quickly turn your Pivot table information into graphs and charts.


In this lecture, you will learn how to use external data (the data which is not in the workbook which carries your pivot table) to create Pivot tables. You can use MS Access, MS SQL and various other data sources to use and present a pivot table summary in Excel as a client.

7 pages

Now, that you know how to create Pivot tables. This lecture provides a summary of the key tips and tricks you need to keep in mind to get best results from the Pivot tables.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Tech Nitya, Software Training, Tutorials, Instructional Design

Founded by Amit Kumar, TechNitya.com is a London based professionally managed & committed training company.

TechNitya.com is proud of its team of high energy, passionate, and professional IT trainers/consultants drawn from drawn from both the world of academics as well as active industry practice with specialized knowledge in a variety of environments.

Amit Kumar, who is an MBA with more than 16 years of business management experience, is responsible for finding and recruiting experts around the globe in various domains and helping them turn their expertise into easy to follow and inexpensive courses/tutorials.

For further details…please feel free to contact us at the link below


Ready to start learning?
Take This Course