Excel Pivot Table Masterclass: Excel Reporting & Dashboards
What you'll 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
Requirements
- 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.
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.
Who this course is for:
- This is a course aimed squarely at the intermediate-to-advanced Excel user looking to take their skills to the next level.
Instructor
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.