Excel Deep Dive: Pivot Tables Workshop with the Office Ninja

Excel data mastery is possible! Learn how to use pivot tables in excel and learn how to use pivot tables to get a raise
61 reviews
TAUGHT BY
  • Alex Mozes Instructor Liaison with Udemy

    I am a Microsoft Certified Master Instructor and I’ve 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.

WHAT'S INSIDE
  • Lifetime access to 37 lectures and 2 quizzes
  • 2+ hours of high quality content
  • A community of 1900+ students learning together!
SHARE

Excel Deep Dive: Pivot Tables Workshop with the Office Ninja

Excel data mastery is possible! Learn how to use pivot tables in excel and learn how to use pivot tables to get a raise
61 reviews

HOW UDEMY WORKS?

Discover courses made by experts from around the world.

Take your courses with you and learn anytime, anywhere.

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

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

    • A smile and a computer with Excel '07 or '10
    • Over 37 lectures and 2 hours of content!
    • Master Excel Pivot Tables
    • Learn to Harness these skills to get a raise
    • Solve World Hunger
    • Anyone who has a lot of data in Excel

THE UDEMY GUARANTEE

30 day money back guarantee
Lifetime access
Available on Desktop, iOs and Android
Certificate of completion

CURRICULUM

  • 1
    Welcome to Office Ninja Training
    01:12
    Welcome!
  • SECTION 1:
    Introduction
  • 2
    EXERCISE FILES
    Text
  • SECTION 2:
    White Belt Training
  • 3
    Subtotals
    07:10

    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
  • 4
    Exercise: Subtotals
    2 slides
  • 5
    Answer: Subtotals
    04:21
  • 6
    Pivot Table Concept
    03:59

    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

  • 7
    Exercise: Pivot Table Concepts
    1 slide
  • 8
    Creating Your First Pivot Table
    04:48

    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
  • 9
    Exercise: Create a Pivot Table
    2 slides
  • 10
    Answer: Create a Pivot Table
    01:02
  • 11
    Check your knowledge
    4 questions
  • 12
    Changing The Values Field Settings
    03:38

    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 ...
  • 13
    Exercise: Changing the Values Field Settings
    2 slides
  • 14
    Answer: Changing Value Field Settings
    03:23
  • 15
    Drill To Feature
    01:49

    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.

  • 16
    Exercise: Drill To Feature
    1 slide
    Exercises
  • 17
    Answer: Drill-To Feature
    01:30
  • 18
    Formatting And Pivot Table Design
    03:04

    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
  • 19
    Exercise: Formatting and Pivot Table Design
    1 slide
  • 20
    Answer: Formatting and Pivot Table Design
    02:39
  • SECTION 3:
    Black Belt Training
  • 21
    Adding And Manipulating Multiple Fields
    07:03

    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
  • 22
    Exercise: Adding and Manipulating Multiple Fields
    1 slide
  • 23
    Answer: Adding and Manipulating Multiple Fields
    02:07
  • 24
    Filtering And Slicing Pivot Data
    07:50

    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
  • 25
    Exercise: Filtering and Slicing Pivot Data
    2 slides
  • 26
    Answer: Filtering & Slicing Pivot Data
    02:29
  • 27
    Creating Pivot Table Dashboards
    04:42

    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
  • 28
    Exercise: Creating Pivot Dashboards
    1 slide
  • 29
    Answer: Creating Pivot Dashboards
    02:03
  • 30
    Pivot Charts
    07:33

    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
  • 31
    Exercise: Pivot Charts
    1 slide
  • 32
    Answer: Pivot Charts
    01:07
  • 33
    Putting It All Together
    11:50

    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. 

  • 34
    Exercise: Putting it All Together
    2 slides
  • 35
    Answer: Putting It All Together
    05:11
  • SECTION 4:
    Additional Material
  • 36
    All Exercises
    16 slides
  • 37
    Finished Data
    3 MB
  • 38
    Quick Reference Guide
    649.39 KB
  • 39
    Do you know the way to San Jose?
    3 questions

UDEMY BY THE NUMBERS

5,200,000
Hours of video content
19,000,000
Course Enrollments
5,700,000
Students

RATING

  • 45
  • 14
  • 0
  • 2
  • 0
AVERAGE RATING
NUMBER OF RATINGS
61

REVIEWS

  • Aharwell
    Great Instruction

    This was my first course and I was very pleased with the quality of instruction. The instructor made the information very easy to understand and how it was applicable to real-life scenarios. I recommend this course for anyone interested in expanding their excel skills.

  • Kaye Campbell
    Excellent course

    The course was well organized and explained. Alex communicated his material well. he responds to any questions you leave in the discussion forum promptly.

  • Edu Stefanini
    Didactic course

    Alex Mozes is a great tutor! Clear english and well explained topics step by step in order to develop pivot tables in Microsoft Excel. He provided a .xls file to follow him in the lectures and practice the content in real time. Great stuff!!!!

  • Ben Van Der Westhuizen
    Well presented

    I liked the pace of the course and the level of detail covered. I certainly got my money's worth from this course.

  • Alain Sergile
    "THE" course to take for Pivot Tables!

    Very powerful course. Teacher, Alex Moses was simply Superb in explanations, demonstrations and articulation of the materials. Just started a new job and this course helped me prepare my first analysis of a big project. Any newbie to Pivot Table NEEDs this course. I just wish that Alex can teach more other courses. There are too many Teachers on here with heavy English accents that are hard to understand. Mr. Moses, Please teach other Excel courses like Charts, Vlookups, etc..- if you do please ensure that Udemy announce it so I can buy it - because I could not find them. Thank you VERY much for the course. You rock!!

  • 30 day money back guarantee!
  • Lifetime Access. No Limits!
  • Mobile Accessibility
  • Certificate of Completion