Platform: Office 2013 or 2016 on Windows PC
Working professionals often have to organize and summarize mountains of data into presentable formats to identify key trends, offer comparisons and reveal patterns and relationships to answer some common questions such as sales performances for various regions, average class size per month and which factory is producing better?
In this one day lesson, students will find out how PivotTables reports make all these so easy by allowing anyone to compare, reveal, and analyze information by transforming different views of long lists of data into information that makes sense.
Creating a PivotTable
Filtering and Sorting a PivotTable
Working with PivotTable Layout
Grouping PivotTable Items
Updating a PivotTable
Formatting a PivotTable
Creating a PivotChart