Excel Pivot Table Masterclass: Excel Reporting & Dashboards

Course details

Building Business Intelligence with Pivot Tables is an online video course that is perfect foranyone 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 datafor reporting. As the data is cleansed, the course will show you how to present the data in away that is easy to use for analysis by presenting data in both tabular and visually. Thecourse will further explore the best ways to analyze the data and drill in and out of data Bythe end of this course, you will feel confident sourcing data, cleansing it, and analyzing itthrough pivot tables and dashboards.

This is a course aimed squarely at the beginner/intermediate Excel users looking to take theirskills to the next level. Before starting this course, you should be comfortable working inExcel. 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 liveseasier, the course is designed to take someone with absolutely no Pivot Table knowledge andteach them how to collect, clean and set up the data, present it in Pivot Tables and builddashboards 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.