3-day Virtual Seminar

Master Pivot and Power Pivot Tables - Fast, Flexible Data Analysis in Excel for Busy Professionals

Overview

In this webinar, we will tackle the analysis of some realistic business data using pivot tables or Power Pivot tables. You will be sent the source data before the webinar so you can follow along and carry out the analysis on your own computer: learning by doing! After attending this webinar, you will be able to create, amend and adapt pivot tables to get the easily analyze your data in a flexible, user-friendly way.

Why you should Attend

• Join this hands-on session and level up your Excel analysis skills in just one hour
• You want to analyze your data easily and flexibly
• You've heard of pivot tables or Power Pivot but haven't explored them yet or
• You can create basic pivot tables but can’t get the results looking the way you want

You want to learn how to pivot like a pro! You want to save time, and support colleagues manager

Areas Covered in the Session

• Create and amend pivot tables
• Sort and custom sort your results
• Format your results using layout options and number formats
• Slice & dice your data using various filter methods and slicers
• Set defaults options to minimize changes needed and reduce file-size!

Note: the techniques shown can be used for standard pivot tables and for Power Pivot tables (when using Power Query)

Who Will Benefit

• Excel Users with some experience of working with data
• Analysts and Finance Professionals
• Business Controllers, and FP&A Professionals
• Anyone looking to upgrade their Excel data analysis skills