Description

Excel Level 5 is a one-day instructor-led class that focuses on the most powerful feature in Microsoft Excel Pivot Tables. With advanced topics teaching participants how to scrub, summarize, and sort their data using advanced techniques inside PivotTables. Then creating visually appealing Pivot Charts to present the data. Upon completion of the Excel Level 5 course, participants will be experts in using PivotTables to manipulate and display large data sets. With the ability to quickly sort, filter, group, summarize, and format data with ease and efficiency using Pivot Tables. This course features units on:

Creating Pivot Tables

• Setting up your source data
• Creating a Pivot Table
• Pivoting Your Data

Drilling Down

• Accessing the underlying details of pivot table fields

Sorting

• Sorting Pivot Table data

Grouping

• Grouping by rows
• Grouping by columns
• Date grouping

Filtering

• Filter Pivot Table data to only see rows of interest

Slicers

• Visually filtering Pivot Table data using slicers

Setting Pivot Table Options

• Naming your Pivot Table and other Pivot Table options

Report Layout

• Exploring the three report layouts available for Pivot Tables

Calculations

• Calculating Pivot Table values

Pivot Charts

• Generating a Pivot Chart and manipulating it to suit your needs

Show Commands

• Controlling what shows and what doesn’t in your Pivot Table