Loading...

Course Description

Build on your knowledge of PivotTable capabilities to understand and visualize your data more effectively. Organize your data through customized grouping, and quickly view date ranges using Timeline slicers. Include calculated fields to give you new insights about your data. Understand how conditional formatting interacts with PivotTables, giving you more options on how to present your data. Additional topics include creating more useful PivotTables by adding KPI indicators, working with standard deviation, and using IF statements.

In this course, you will learn to: 

  • Understanding and using less common summary methods, such as Counting and 

  • Standard Deviation. 

  • Using different ways to show your values so you can learn more information without creating a custom field. 

  • Creating custom calculated fields to show information based on your source data, but not directly present. 

  • Organizing your data by grouping fields into custom groups, numerical ranges, and nested groups. 

  • Applying Conditional Formatting to a PivotTable so that the formatting rules apply when the PivotTable changes layout. 

  • Using KPI icons to get information quickly about how well a particular field is performing relative to the goal values. 

  • Quickly and efficiently viewing different date ranges for your PivotTable through the Timeline Slicer tool. 

  • Understanding and managing the way Grand Totals and Subtotals interact with various techniques. 

Prerequisites

Introduction to PivotTables or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Intermediate Excel PivotTables
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Jun 20, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 18, 2024
Transfer Request Deadline
Jun 18, 2024
Section Title
Intermediate Excel PivotTables
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
Jun 20, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 18, 2024
Transfer Request Deadline
Jun 18, 2024
Required fields are indicated by .