The Complete Excel Pivot Table Course

Learn to master the Pivot Table for more efficient data management and analytics.
4.6 (24 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.
797 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 19
  • Length 2 hours
  • 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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

About This Course

Published 8/2015 English

Course Description

The Complete Excel 2013 Pivot Table course will take a student who knows nothing about Excel Pivot Tables to a competent and confident power user in no time.

We will be discussing topics such as

  • Records, Attributes, and Values
  • Proper Pivot Table Data Formats
  • Nesting, Grouping, and Moving Attributes
  • Field Settings
  • Sorting and Filtering within a Pivot Table
  • Slicers and Timelines
  • Conditional Formatting
  • Pivot Charts
  • and more...
The best part about my course is the Excel Data Workbook you will receive at no extra charge! This will allow you to follow along with me click for click, and even practice on your own, using the mock data I have provided! If you have a working knowledge of basic Excel principles, and you're looking to step up your game, sign up for The Complete Excel 2013 Pivot Table Course now, and add that extra something to your current analytics and reporting.

I will be right there with you throughout the entirety of the course. If you need anything, be sure to post in the course forum for your classmates and me to address any questions!

What are the requirements?

  • Microsoft Excel 2013 for Windows is required.

What am I going to get from this course?

  • Create and manage Pivot Tables from a raw data source
  • Style a Pivot Table to match any theme you'd like
  • Sort and Filter data dynamically
  • Refresh data in a Pivot Table or change the data source altogether
  • Utilize Slicers, Timelines, and Pivot Charts
  • and much more...

What is the target audience?

  • This course is meant for students looking to improve their Excel skills by using Pivot Tables.
  • You should probably not take this course if you are looking for a deep dive into more Advanced Excel topics.

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.

Curriculum

Section 1: Introduction
Welcome!
Preview
01:09
02:20

Let's get started by setting up your Quick Access Toolbar, and downloading the Data Workbook!

03:31

In this lecture we'll discuss the basic building blocks of the Pivot Table: Fields, Attributes, and Values. Gaining a firm grasp on these concepts now will pay dividends later, as you build and maintain your own Pivot Tables in analysis, reporting, or dashboards.

01:50

Ensuring your data is in a proper Pivot Table-ready format will save you tremendous headaches in the long run. This lecture will walk you through the dos and don'ts of Pivot Table data prep.

Section 2: Basics
01:47

Here we will take a moment to broadly explain the Pivot Table, answering the following questions:

  • What is it used for?
  • When should I use a Pivot Table?
  • Why are Pivot Tables so popular?
  • Why should I learn how to use a Pivot Table?
  • ... and more.
03:28

Finally! Let's explore the options we have available to create your very first Pivot Table. Also, this first table is what we will be working with the rest of the course!

04:07

There are a lot of Pivot Table-specific options available to us in Excel, so let's take a few minutes to ground ourselves in these new features, and begin working with the field list, including Filters, Columns, Rows, and Values.

5 questions

Let's pause from the course lectures and make sure you have a firm understanding of Attributes and Values before we continue. Remember, this foundational knowledge will make your life much easier later on.

04:50

Creating custom groups and nesting attributes are just a couple of the many perks of using a Pivot Table. In this lecture, we will discuss exactly just how to do this.

02:14

Easily create a beautiful Pivot Table of your own after just 2 short minutes of instruction.

05:20

The Layout Group allows for incredible flexibility in your Pivot Table. Let's explore some of what we can do here.

05:32

Sum? Average? Count? Min? Max? The Pivot Table can display your data in many ways, and Field Settings serves as the control panel for your values.

14:20

Dynamically sort and filter any amount of data you'd like. And don't worry, when you update your Pivot Table, your sorting and filtering rules will still apply!

20:01

My favorite part about Pivot Tables, the Slicer allows for very flexible and very aesthetically pleasing multi-layered quick filtering.

08:44

The not too distant cousin of the Slicer, the Timeline creates a very dynamic way to filter dates in a Pivot Table.

Recapping Slicers and Timelines
4 questions
05:26

One of the most useful aspects of the Pivot Table, here I will show you how to refresh data or add/delete data from the data source, all without losing your current Pivot Table's layout!

Section 3: Advanced
10:49

Everyone knows it's a mathematical faux-pas to average averages, so let the Pivot Table dynamically calculate functions for you, and style them any way you'd like!

07:29

Want to see absolute sales AND share of sales. Piece of cake when you use the Show Values As... functionality.

03:03

Never apply a conditional formatting rule more than once. The Pivot Table will take one rule, and intelligently apply it wherever you want, no matter how much data or what the layout is.

05:02

A brief introduction to creating and styling Pivot Charts to Pivot Tables: the gateway to beautiful, fully dynamic data dashboards.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Alex Moore, Excel Expert

I am a Microsoft Excel guru and I have a passion for teaching. I've been using my advanced technical skills for years in multiple facets of my life, and it is my pleasure to serve others through sharing this knowledge via the terrific platform Udemy has created. No matter what your goals are, my mission is to aid every student I teach in reaching their full potential.

I am currently teaching The Complete Excel 2013 Pivot Table course in order to aid you in improving your analytical and reporting prowess, especially if it will benefit your career. My goal for this course is to ensure every student can unleash the power of the Pivot Table to efficiently create stunning reports and dashboards to impress clients, supervisors, etc. I sincerely hope you find the course beneficial.

Ready to start learning?
Take This Course