Loading...

Course Description

Learn some of the advanced settings that will allow you to set up subtotals and change your layout. Understand how to create PivotTables from multiple consolidation ranges, use macros to refresh your data, and synchronize multiple tables. Discover how to set up fiscal quarters, and perform calculations and filtering as well as work with atypical fiscal years. Understand how to create calculated items, and change the solve order for calculated fields and calculated items. Learn techniques to improve the appearance of your spreadsheets including advanced conditional formatting. Add data sets to create a data model, and then generate a PivotTable from the model. Learn to show values as an index and how this impacts your PivotTable. Additional topics include how to use ISNULL and advanced calculations such as nested IFs and logical AND/OR.

In this class, you will learn how to: 

  • Single and multi-level custom subtotals 

  • Replacing empty values cells 

  • Creating calculated items 

  • Altering the solve order for calculated fields or calculated items 

  • Establishing fiscal years and quarters 

  • Multiple consolidation range PivotTables 

  • Using an index to show impact 

  • Advanced filtering techniques 

  • Automating with macros and VBA 

  • Creating custom PivotTable and slicer styles 

Prerequisites

Intermediate PivotTables or equivalent experience.

Applies Towards the Following Certificates

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