Excel Pivot Table Masterclass: Excel Reporting & Dashboards

Excel Pivot Table Masterclass: Excel Reporting & Dashboards, available at $64.99, has an average rating of 4.8, with 79 lectures, 8 quizzes, based on 201 reviews, and has 2949 subscribers.

You will learn about 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 This course is ideal for individuals who are This is a course aimed squarely at the intermediate-to-advanced Excel user looking to take their skills to the next level. It is particularly useful for This is a course aimed squarely at the intermediate-to-advanced Excel user looking to take their skills to the next level.

Enroll now: Excel Pivot Table Masterclass: Excel Reporting & Dashboards

Summary

Title: Excel Pivot Table Masterclass: Excel Reporting & Dashboards

Price: $64.99

Average Rating: 4.8

Number of Lectures: 79

Number of Quizzes: 8

Number of Published Lectures: 79

Number of Published Quizzes: 8

Number of Curriculum Items: 87

Number of Published Curriculum Objects: 87

Original Price: $89.99

Quality Status: approved

Status: Live

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

Who Should Attend

This is a course aimed squarely at the intermediate-to-advanced Excel user looking to take their skills to the next level.

Target Audiences

This is a course aimed squarely at the intermediate-to-advanced Excel user looking to take their skills to the next level.

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.

Course Curriculum

Chapter 1: Intro – The value of Pivot Tables

Lecture 1: Business Intelligence Lifecycle

Lecture 2: Why You Care About PivotTables

Lecture 3: Creating Your First Pivot Table

Lecture 4: DEMO: Creating Your First PivotTable

Chapter 2: Pivot Compliant Data Sets

Lecture 1: Required Data Layout

Lecture 2: Connecting To Your Source Data

Lecture 3: Issues Using Excel Ranges

Lecture 4: Using Excel Tables

Lecture 5: Building PivotTables Against Excel Tables

Lecture 6: Why Excel Tables Are Better Than Ranges

Lecture 7: Using Data Direct From Databases

Lecture 8: Sourcing Data Direct from Databases to PivotTables

Lecture 9: Sourcing Data Direct from Databases to a Table

Lecture 10: Sourcing Data Direct from the Database to the Data Model

Chapter 3: Controlling PivotTable Look & Feel

Lecture 1: Value Field Formats

Lecture 2: Modifying Column Names and Number Formats

Lecture 3: Report Layouts

Lecture 4: Changing PivotTable Layouts

Lecture 5: Grouping Data

Lecture 6: Grouping Data in PivotTables

Lecture 7: PivotTables Styles

Lecture 8: Creating Custom PivotTables Styles

Lecture 9: Sorting PivotTables

Lecture 10: Sorting Methods in PivotTables

Chapter 4: Creating Compliant Data Sets

Lecture 1: Using Power Query to Get And Transform Your Data

Lecture 2: Cleaning up a Text File with Power Query

Lecture 3: Appending Data Tables

Lecture 4: Simple Append Operations

Lecture 5: Consolidating flat files from folder

Lecture 6: Consolidating a Folder of CSV Files

Lecture 7: Consolidating Excel Data

Lecture 8: Consolidating External Excel Data Files

Lecture 9: Get Data From Active Workbook

Lecture 10: Consolidating Data From Within the Active Work File

Lecture 11: UnPivoting Data

Lecture 12: Unpivoting simple data sets

Lecture 13: Flattening Data Sets

Lecture 14: Flattening Tables with VLOOKUP

Lecture 15: 6 Ways To Join – Foundation

Lecture 16: Flattening Tables with Power Query – The basics

Lecture 17: Join Types

Lecture 18: 6 Ways To Join With Power Query

Chapter 5: Changing Aggregations

Lecture 1: Sum, Count & Others

Lecture 2: Introduction To Changing Aggregations

Lecture 3: Show Values As

Lecture 4: Running Totals

Lecture 5: Difference & % Difference From

Lecture 6: Difference from X & % Difference from X

Lecture 7: Ranking Items

Lecture 8: Ranking Items in PivotTables

Lecture 9: Showing the Top/Bottom X Records

Lecture 10: Displaying Top/Bottom X

Lecture 11: Calculated Fields

Lecture 12: Working With Calculated Fields

Lecture 13: Calculated Items

Lecture 14: Working With Calculated Items

Chapter 6: Slicing and Filtering

Lecture 1: Filtering with Classic Controls

Lecture 2: Working With Pivot Table Filter FIelds

Lecture 3: Filtering With Slicers

Lecture 4: Working With Slicers

Lecture 5: Filtering With Timelines

Lecture 6: Working With Timelines

Lecture 7: The "Show Details" Feature

Lecture 8: The "Show Details" Feature – DEMO

Lecture 9: Keep Your Pivots Looking Nice

Lecture 10: Toggling Pivot Table Options

Chapter 7: Building Pivot Based Dashboards

Lecture 1: Conditional Formatting On Pivots

Lecture 2: Conditional Formatting – DEMO

Lecture 3: Keeping Pivots In Sync

Lecture 4: Linking One Slicer to Multiple Pivots

Lecture 5: Tricks For Extracting Key Info

Lecture 6: Extracting Data From Pivots And Slicers

Lecture 7: Working With Pivot Charts

Lecture 8: Building Pivot Charts

Chapter 8: Data Refresh and Security

Lecture 1: Driving Pivot Table Refresh

Lecture 2: Refresh Options for External Data Sets

Lecture 3: Refresh Options for Local Data Sets

Lecture 4: How Secure Is Your Data?

Lecture 5: DEMO: Exposing Data

Instructors

Excel Yourself
Excel MVPs, Authors and Bloggers

Rating Distribution

1 stars: 1 votes
2 stars: 5 votes
3 stars: 21 votes
4 stars: 54 votes
5 stars: 120 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