Excel Deep Dive: Pivot Tables Workshop

Excel Deep Dive: Pivot Tables Workshop, available at $99.99, has an average rating of 4.54, with 31 lectures, 1 quizzes, based on 4700 reviews, and has 20354 subscribers.

You will learn about Master Excel Pivot Tables Learn to Harness these skills to get a raise Solve World Hunger This course is ideal for individuals who are Anyone who has a lot of data in Excel It is particularly useful for Anyone who has a lot of data in Excel.

Enroll now: Excel Deep Dive: Pivot Tables Workshop

Summary

Title: Excel Deep Dive: Pivot Tables Workshop

Price: $99.99

Average Rating: 4.54

Number of Lectures: 31

Number of Quizzes: 1

Number of Published Lectures: 31

Number of Published Quizzes: 1

Number of Curriculum Items: 32

Number of Published Curriculum Objects: 32

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Anyone who has a lot of data in Excel

Target Audiences

Anyone who has a lot of data in Excel

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.

Course Curriculum

Chapter 1: section 1

Lecture 1: Welcome to Office Ninja Training

Chapter 2: Introduction

Lecture 1: EXERCISE FILES

Chapter 3: White Belt Training

Lecture 1: Subtotals

Lecture 2: Exercise: Subtotals

Lecture 3: Answer: Subtotals

Lecture 4: Pivot Table Concept

Lecture 5: Creating Your First Pivot Table

Lecture 6: Exercise: Create a Pivot Table

Lecture 7: Answer: Create a Pivot Table

Lecture 8: Changing The Values Field Settings

Lecture 9: Exercise: Changing the Values Field Settings

Lecture 10: Answer: Changing Value Field Settings

Lecture 11: Drill To Feature

Lecture 12: Answer: Drill-To Feature

Lecture 13: Formatting And Pivot Table Design

Lecture 14: Exercise: Formatting and Pivot Table Design

Lecture 15: Answer: Formatting and Pivot Table Design

Chapter 4: Black Belt Training

Lecture 1: Adding And Manipulating Multiple Fields

Lecture 2: Exercise: Adding and Manipulating Multiple Fields

Lecture 3: Answer: Adding and Manipulating Multiple Fields

Lecture 4: Filtering And Slicing Pivot Data

Lecture 5: Exercise: Filtering and Slicing Pivot Data

Lecture 6: Answer: Filtering & Slicing Pivot Data

Lecture 7: Creating Pivot Table Dashboards

Lecture 8: Exercise: Creating Pivot Dashboards

Lecture 9: Answer: Creating Pivot Dashboards

Lecture 10: Pivot Charts

Lecture 11: Exercise: Pivot Charts

Lecture 12: Answer: Pivot Charts

Lecture 13: Putting It All Together

Lecture 14: Answer: Putting It All Together

Instructors

Alex Mozes
Teacher and learner

Rating Distribution

1 stars: 22 votes
2 stars: 58 votes
3 stars: 411 votes
4 stars: 1661 votes
5 stars: 2548 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu