The Complete Excel Pivot Table Course
4.6 (25 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.
808 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Complete Excel Pivot Table Course to your Wishlist.

Add to Wishlist

The Complete Excel Pivot Table Course

Learn to master the Pivot Table for more efficient data management and analytics.
4.6 (25 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.
808 students enrolled
Created by Alex Moore
Last updated 1/2016
English
Current price: $10 Original price: $30 Discount: 67% off
7 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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...
View Curriculum
Requirements
  • Microsoft Excel 2013 for Windows is required.
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!

Who 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 19 Lectures Collapse All 19 Lectures 01:51:02
+
Introduction
4 Lectures 08:50

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

Preview 02:20

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.

Fields, Attributes, and Values
03:31

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.

Preview 01:50
+
Basics
11 Lectures 01:15:49

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.
The Pivot Table Explained
01:47

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!

Preview 03:28

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.

Pivot Table Tools & Options, and the Field List
04:07

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.

Refresher: Attributes and Values
5 questions

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.

Nesting, Grouping & Moving Attributes
04:50

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

Formatting & Styles
02:14

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

The Layout Group
05:20

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.

Preview 05:32

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!

Sorting & Filtering
14:20

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

Slicers
20:01

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

Slicers (continued) & Timelines
08:44

Recapping Slicers and Timelines
4 questions

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!

Refreshing the Data & Changing the Data Source
05:26
+
Advanced
4 Lectures 26:23

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!

Pivot Table Calculations
10:49

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

Multiple Values & Show Values As...
07:29

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.

Conditional Formatting
03:03

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

Pivot Charts
05:02
About the Instructor
Alex Moore
4.6 Average rating
25 Reviews
808 Students
1 Course
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.