Microsoft Excel 2016 Level 4.2: Analyzing Data by Using PivotTables

This course takes a deeper look at how to analyze data by using PivotTables in Excel 2016. You must be able to organize your data so it is easy to understand and interpret. You can also filter the data found in a PivotTable or change the format of the PivotTable itself to ensure you have provided enough functionality without cluttering the overall experience. This course shows you how to accomplish these tasks. A PivotTable is a powerful feature in Excel. It allows you to extract specific pieces of information from a larger set of data; in short, it allows you to focus on what you determine to be the important parts of that data. Utilize the information presented here and understand how to better sort, analyze, and present your data through PivotTables.