Excel 3: Data Analysis Tools - Workshop
Excel 3: Pivot Tables and Summary Tools
Description
Both Pivot Tables and functions like SUMIFS and COUNTIFS are capable of creating summaries and interactive charts in a workbook. In this session, we will see a side-by-side comparison of this functionality, and demonstrate a number of ways we can create useful summary reports. Topics include: Configuring datasets as tables within a workbook Using SUMIFS and COUNTIFS for linked summary tables Leveraging data validation and summary functions for interactive reports Creating dashboards with Pivot Tables, Pivot Charts, and Slicers