# 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

4.4/5

## Excel Deep Dive Pivot Tables Workshop

### What you’ll learn

Master Excel Pivot Tables
Learn to Harness these skills to get a raise
Solve World Hunger

### 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
Learn how to use pivot table in excel today.

### Overview

Section 1: section 1

Lecture 1 Welcome to Office Ninja Training

Section 2: Introduction

Lecture 2 EXERCISE FILES

Section 3: White Belt Training

Lecture 3 Subtotals

Lecture 4 Exercise: Subtotals

Lecture 6 Pivot Table Concept

Lecture 7 Creating Your First Pivot Table

Lecture 8 Exercise: Create a Pivot Table

Lecture 9 Answer: Create a Pivot Table

Lecture 10 Changing The Values Field Settings

Lecture 11 Exercise: Changing the Values Field Settings

Lecture 12 Answer: Changing Value Field Settings

Lecture 13 Drill To Feature

Lecture 15 Formatting And Pivot Table Design

Lecture 16 Exercise: Formatting and Pivot Table Design

Lecture 17 Answer: Formatting and Pivot Table Design

Section 4: Black Belt Training

Lecture 18 Adding And Manipulating Multiple Fields

Lecture 19 Exercise: Adding and Manipulating Multiple Fields

Lecture 21 Filtering And Slicing Pivot Data

Lecture 22 Exercise: Filtering and Slicing Pivot Data

Lecture 23 Answer: Filtering & Slicing Pivot Data

Lecture 24 Creating Pivot Table Dashboards

Lecture 25 Exercise: Creating Pivot Dashboards

Lecture 26 Answer: Creating Pivot Dashboards

Lecture 27 Pivot Charts

Lecture 28 Exercise: Pivot Charts

Lecture 30 Putting It All Together

Lecture 31 Answer: Putting It All Together

Anyone who has a lot of data in Excel

#### Course Information:

Udemy | English | 1h 42m | 1.28 GB
Created by: Alex Mozes

You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com

Scroll to Top