This course provides students with the information necessary to create and modify a PivotTable. Students will learn how to calculate, format, and filter within a PivotTable. Information is also included regarding PowerPivot, used for advanced analysis of a large dataset.