Pivot Tables Deep Dive

In this ‘Deep Dive’ topic, we will devote the full day to exploring Pitvot Tables and how they can be used for Data Analysis. We recommend that you have a basic to intermediate understanding of Microsoft Excel but no prior knowledge of Pivot Tables is required.

What you will learn:

• Introduction to pivot tables
• Convert data to tables
• Adjust field list settings
• Create multiple reports with one click
• Add data bars to pivot tables
• Master pivot table settings
• Add and remove calculated fields to pivot tables
• Calculate the difference between columns
• Add smart custom number formatting
• Create custom groupings to pivot tables
• Group dates as unique
• Add slicers to easily filter data
• Add dynamic charts
• Add a timeline to pivot tables
• Introduction to Microsoft Power Pivot

This seminar is also available on demand by virtual classroom. Contact us for more details.