Exceptional Excel: Advanced PivotTables (QAS)
2.0 NASBA Credits (Computer Software & Applications - Non-Technical)
This course discusses how to extract data from other sources, create simple macros that can resolve the most frustrating aspects of pivot tables, determine the number of duplicates in a list, and much more.
Apply the Custom Lists feature to override the default sort order within pivot tables.
State how to create pivot tables from information you extract from databases.
Identify pivot table data in new ways by grouping based on dates or custom arrangements that you define.
Level: Advanced
Field(s) of Study: Computer Software & Applications - Non-Technical (NASBA)
Who Should Attend: Who this course is for: Anyone interested in learning how to use Excel to capture and analyze data.
Required Knowledge: Intermediate-Level Experience with Excel Pivot Tables
Advanced Prep: None