Excel Deep Dive: Pivot Tables Workshop (Udemy.com)

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

Created by: Alex Mozes

Produced in 2019

icon
What you will learn

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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100

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

Who this course is for:
Anyone who has a lot of data in Excel

icon
Instructor Details

Alex Mozes

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.

icon
More excel courses

Excel Skills for Business: Essentials

Free

Excel Skills for Business: Intermediate I

Free

Excel Dynamic Arrays - Beginner to Expert (Microsoft 365)

$11.99

Visually Stunning Microsoft Excel Dynamic Dashboard Course

$11.99

Excel with Top Microsoft Excel Hacks

$11.99

Microsoft Excel  Complete Excel Guide (Excel 2007  2021)

$11.99

icon
Reviews

4.6

309 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Gabriel Atwater on 12/20/2020

Can't open the resource doc. Version of Excel in the tutorial is antiquated.

By Rohan Macky on 10/22/2020

This course gave me one of those 'click' moments that has helped immensely in grasping the design of pivot tables, and understanding the power they hold in the right hands. Will recommend to colleagues... that I'm not competing with for jobs ;)

By Tan Li Lian Olga (MSF) on 10/15/2020

Clear explanation

By Elizabeth Morrissey on 10/15/2020

I would be nice if the instructor slowed down a bit

By Eleanor Broome on 10/13/2020

Super useful! Clear explanations plus some more advanced features to stretch and challenge.

By Deepak Bagal on 10/3/2020

Excellent Topic Related knowledge, Good Display of Exercises

By Heather Staufenberg on 10/2/2020

Learned a lot about pivot tables that I didn't already know. Exercises and explanations were super helpful.

By Sumaya Abo-ElHamd on 9/6/2020

Resources are not working and some videos are outdated

By Gloria Dipela on 9/4/2020

Thank you, it helped me to understand Pivot clearly now. I love everything about this course.

By Jeanette Sisson on 8/18/2020

Very helpful. Moved at a speed that was easy to follow along.

By Randy Robbins on 8/13/2020

Very informative class. Great examples and demonstration.

By Colt Saint Baptiste on 8/9/2020

I strongly recommend this course. You will not be disappointed!