Skip to content
Write a review
UdemyExcelPaid courseIntermediate levelCertificate

Excel Pivot Table Masterclass: Excel Reporting & Dashboards (Udemy.com)

Sourcing data, Cleansing it, and Analyzing it through Excel pivot tables and dashboards. Master reporting & data viz

4.5
224 reviews

Created by: Excel Yourself

Last updated May 2017

icon
What you will learn

  • Build Dashboards and visualizations with PivotTables
  • Build reports and quickly summarize 10s to 1,000s of rows of data quickly
  • Source and clean up source data for reporting
  • Present the data in a way that is easy to use for analysis by presenting data in both tabular and visually
  • Analyze the data and drill in and out of data
  • Source data, cleanse it, and analyze it through pivot tables and dashboards

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.5 out of 5higher than 39% of them
  • Reviews224#296 of 356 by number of reviews
  • Length6.9 hourslonger than 56% of them
  • Last updatedMay 2017earlier than 87% of them

icon
Course Description

Building Business Intelligence with Pivot Tables is an online video course that is perfect for anyone looking to build reports and quickly summarize 10s to 1,000s of rows of data quickly. This course will provide the analyst with the best ways to source and clean up source data for reporting. As the data is cleansed, the course will show you how to present the data in a way that is easy to use for analysis by presenting data in both tabular and visually. The course will further explore the best ways to analyze the data and drill in and out of data By the end of this course, you will feel confident sourcing data, cleansing it, and analyzing it through pivot tables and dashboards.

This is a course aimed squarely at the beginner/intermediate Excel users looking to take their skills to the next level. Before starting this course, you should be comfortable working in Excel. Knowledge of a variety of formula can be helpful, although is by no means necessary. While those comfortable with Pivot Tables are likely to pick up new tricks to make their lives easier, the course is designed to take someone with absolutely no Pivot Table knowledge and teach them how to collect, clean and set up the data, present it in Pivot Tables and build dashboards using Pivot Charts. 

The instructor, Ken Puls, is an Excel MVP, blogger, conference speaker, and co-author of "M is for Data Monkey" - a guide to the M language in Excel Power Query.
Read More Intermediate Intermediate Level product length iconTime: 6.9h

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Get the Udemy discount

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Excel Yourself

Excel TV is an online Excel video platform that supports the community through Q&A interviews with Excel MVPs, Excel Bloggers, Authors and Speakers.

We inspire analysts to do better with data through interviews, tips, and community engagement with Excel and BI technologies, including data visualization, dashboarding, VBA, and deep analytical practices.

Our course instructors are Microsoft Excel MVPs, Authors, Bloggers, conference speakers, and professionals known in our space. They are at the top of the field in Excel and Business Intelligence, Business Analytics, and Data Science. Every Excel TV trainer has a book published, runs a successful blog, or is a highly sought after.

Read More

icon
More courses by Excel Yourself

$44.99

All courses by Excel Yourself

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

All Excel courses

icon
Reviews

4.5

224 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

Write a review

By Paul Godwin on 10/31/2022

SO FAR SO GOOD BUT ALREAD A BIT OCNCERNED WHEN HE SAYS WE'LL BE USING EXCEL 2016... IT IS 2022 AND I'M USING Microsoft® Excel® for Microsoft 365 MSO (Version 2209 Build 16.0.15629.20196) 32-bit

By Rudi Olivier on 8/27/2022

Good course. Knew already the most of it. But still got and found some extra tweaks and hints to work better and safer that I didn't knew off. That is why one can learn from every course. There's always some knew things to discover. +++

By Sanchit Khanna on 9/9/2019

Your narration needs to improve a lot. No commas, No full stops. Just one continuous tone. Too much emphasis on 's' sound is very annoying. Use a filter on your mic. The first two lectures the pace of narration is too much. It is like someone is reading off of history text book. Couldn't really connect with what you were saying. Though the content is good but the narration style needs to improve a lot.

By Pasquale Grosso on 11/13/2018

Amazing teacher, he deeply knows the topic and can explain it perfectly. He has a very clear voice and pronunciation and is also funny. I am learning many tricks which will improve my work and the course is answering many questions I was wondering. If you want to understand pivot tables this is the course.

By Jamaine Earnest on 5/13/2018

It's really helpful to provide an overview before taking the actual steps for each tutorial. I'm also really impressed with how the instructor provides additional insight with different options ... why you should and should not perform this action.

By N Herman on 1/11/2018

Clear explanations on everything from theory, business practice to hands-on. I considered myself experienced user of pivot tables before taking this class but I picked up a lot of good info.

By Debanjan Kumar Rakshit on 7/24/2017

A detailed description of how to work with Pivot Table and how to do it the absolute correct way. Only the verbal description is a little fast

By Suresh Thavalingam on 7/13/2017

This course covers a lot of great information about all aspects of excel. Instructor very engaging and has very good delivery. Was an intermediate user coming in and still learned a lot. Thank you!

By Stuart Cooper on 6/12/2017

The instructor really seems to know the frustrations of developing solutions in a busy business environment. This common experience gives me a lot of faith that this is the correct course for my needs.

By Eugene Last on 5/18/2017

One of the best course and instructor. Instructor is very professional. Perfect pronunciation and speed. Usually I watch courses with at least 1.25x speed but this one with 1x because course is very detailed and I do not want to miss anything. Despite it is very detailed and has a LOOOOOT of information it is easy to grasp and digest.

Showing all 10 reviews on CourseDuck

Read all 224 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

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

Overall Score : 90 / 100

Excel Pivot Table Masterclass: Excel Reporting & Dashboards
Visit course on Udemy Write a review
  • Video Duration: icon 6.9h
  • Price: $69.99
  • Provider: icon Udemy
  • Updated: icon May 2017
  • Level: Intermediate Intermediate
  • Language: icon English
  • Certificate: icon Yes
30-day money-back guarantee on most paid courses

Udemy Coupon Price Tracker

Udemy price history

For any issues or feature requests please email CourseDuck's Co-Founder at mkuhlman12@gmail.com