PivotTables are Excel’s most powerful feature! Plan to participate in this session to learn about eight key PivotTable features to enhance your Excel-based reporting processes. Upon completing this session, you’ll be stunned at what PivotTables can do!
Learning Objectives
• Identify three types of user-defined calculations in PivotTables
• Differentiate the steps necessary to add Key Performance Indicators to PivotTables
• Identify at least two benefits of using PivotTables for data consolidation needs
• Differentiate between Slicer and Timeline filters
• Distinguish examples of potential benefits associated with linking data into PivotTable reports
Major Topics
• Adding user-defined calculations to PivotTables
• Enhancing PivotTables with Key Performance Indicators
• Using PivotTables to consolidate “standard” Excel reports
• Creative ways to filter PivotTables
• Linking accounting software data into PivotTables