Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.
Excel 3: Pivot Tables and Summary Tools
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