Excel Deep Dive: Pivot Tables Workshop
4.5 (439 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.
4,639 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Deep Dive: Pivot Tables Workshop to your Wishlist.

Add to Wishlist

Excel Deep Dive: Pivot Tables Workshop

Excel data mastery is possible! Learn how to use pivot tables in excel and learn how to use pivot tables to get a raise
Bestselling
4.5 (439 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.
4,639 students enrolled
Created by Alex Mozes
Last updated 3/2016
English
English
Current price: $10 Original price: $90 Discount: 89% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Article
  • 13 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Master Excel Pivot Tables
  • Learn to Harness these skills to get a raise
  • Solve World Hunger
View Curriculum
Requirements
  • A smile and a computer with Excel '07 or '10
Description

Master Excel Pivot Tables and save the world!

This course discusses one of the most powerful tools of the Office Ninja's arsenal, Excel Pivot Tables and how to use pivot tables. It's potential for analyzing and summarizing data is legnendary, but few have mastered its intricacies. Through a series of easy to follow lessons on how to use pivot table in excel, you will be introduced to the concepts, techniques and powerful features of this mysterious excel tool, and can follow along with each step with the included sample file.

We will cover:

● Pivot Table Concepts

● Creating A Pivot Table

● Modifying Pivot Table Elements

● Filtering Extraneous Data (the Slicer tool)

● Creating Multiple Pivot Tables

● Creating Pivot Charts

● Advanced Analysis Techniques

Learn how to use pivot table in excel today.

Who is the target audience?
  • Anyone who has a lot of data in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
02:02:46
+
Introduction
2 Lectures 01:26

EXERCISE FILES
00:14
+
White Belt Training
17 Lectures 37:23

This First lecture sets the stage for understanding Pivot Tables by first explaining how to create automatic Subtotals.  In this lecture you will learn how to:

  • Analyze large data sets by the different types of field data
  • Quickly create subtotals
  • Collapse lists for a given type of groupable data
Preview 07:10


Answer: Subtotals
04:21

This Lecture explains the fundamental concepts behind what a Pivot Table is and why it is useful. At the end of this lecture you will understand what a pivot table is doing and how it acts as a "Super Subtotal

Preview 03:59


In this lesson you will create your first pivot table.  Learn how to:

  • Insert a pivot table to your workbook
  • Work with the Field List
  • Modify your Pivot Table
  • Remove fields
Creating Your First Pivot Table
04:48

Exercise: Create a Pivot Table
2 pages

Answer: Create a Pivot Table
01:02

Take this quiz and see if you've been paying attention :)

Check your knowledge
4 questions

Now that you have created a Pivot Table, we want to learn how to control how values are displayed in that table.  In this lesson, you will learn how to:

  • Change the Pivot Table function from the default Sum to other functions
  • Change the Way values are displayed to % of ...
Changing The Values Field Settings
03:38

Exercise: Changing the Values Field Settings
2 pages

Answer: Changing Value Field Settings
03:23

In this lesson, we uncover a nifty feature of Pivot Tables, the Drill To feature which allows you to easily display the original records that made up a specific value in the pivot table.

Drill To Feature
01:49


Answer: Drill-To Feature
01:30

This lesson explores how to format your Pivot Table so it looks the way you want, and so you can share it with other people in a professional format.  You will learn how to:

  • Apply a Style to your Pivot Table
  • Change the Number Format of your values
Formatting And Pivot Table Design
03:04

Exercise: Formatting and Pivot Table Design
1 page

Answer: Formatting and Pivot Table Design
02:39
+
Black Belt Training
15 Lectures 51:55

In this lesson, we raise the stakes and begin to explore the true power of Pivot Tables by adding more than one field to the row and column areas.  This will allow you to get even more specific on the type of trends you are able to extract from your data.  You will learn how to:

  • Add multiple fields to the Row and Column labels
  • Re-organize the layout of the fields
  • Manage multiple fields in the Pivot Table
Adding And Manipulating Multiple Fields
07:03

Exercise: Adding and Manipulating Multiple Fields
1 page

Answer: Adding and Manipulating Multiple Fields
02:07

When dealing with large data sets, it's often important to be able to filter ou the extraneous data that is cluttering the answers you're looking for.  In this lesson, you learn how to do that from within the Pivot Table, and with a new filtering tool to Office 2010, the Slicer.

  • Filter the row and column labels to hide certain values
  • Create a slicer to filter the entire table without showing values
  • Use the slicer tool to quickly manipulate your data
Filtering And Slicing Pivot Data
07:50

Exercise: Filtering and Slicing Pivot Data
2 pages

Answer: Filtering & Slicing Pivot Data
02:29

This lesson explores how to create a dashboard, or rollup of lots of different aspects of your dataset onto one sheet with multiple Pivot Tables.  This is especially useful when the data is changing regularly or you want to look at different trends in your data at the same time.

  • Add multiple Pivot Tables to the same sheet
  • Manage multiple Pivot Tables
  • Connect one Slicer to multiple Pivot Tables
Creating Pivot Table Dashboards
04:42

Exercise: Creating Pivot Dashboards
1 page

Answer: Creating Pivot Dashboards
02:03

By graphically representing data, you can more easily identify trends or key performance indicators in your data, and make it easier to explain your findings to others.  In this lesson, we see how to create a Pivot Chart that reflects the Pivot Table, and how to manipulate that chart

  • Create a Pivot Chart
  • Format a Pivot Chart
  • Add additional elements to a Pivot Chart
Pivot Charts
07:33

Exercise: Pivot Charts
1 page

Answer: Pivot Charts
01:07

In this final lesson, we explore more real world examples of how Pivot Tables can answer important business questions using the tools we've discussed. 

Putting It All Together
11:50

Exercise: Putting it All Together
2 pages

Answer: Putting It All Together
05:11
+
Additional Material
3 Lectures 00:00
All Exercises
16 pages

Finished Data
3.2 MB

Quick Reference Guide
665.0 kB

This is a test of Udemy's new quiz system.  Stay tuned for real questions!

Do you know the way to San Jose?
3 questions
About the Instructor
Alex Mozes
4.6 Average rating
473 Reviews
4,834 Students
2 Courses
Instructor Liaison with Udemy

Alex Mozes has been a proud Udemy employee since 2012. Prior to joining Udemy, Alex was a Microsoft Certified Master Instructor, and spent the better part of a decade teaching companies throughout Silicon Valley how to leverage Microsoft Office to accomplish more, in less time, with better results. Now, the same interactive, engaging, powerful training is available to you through these online courses.