OS-MSO-3003 Using PivotTables

Course Description

Excel can be used to organize large amounts of data, such as sales data or customer data. A PivotTable enables you to easily organize the data in various ways, analyze it, and create reports without changing the original data.By the end of this module, you will be able to

• Describe how data should be arranged before creating a PivotTable
• Create a PivotTable
• Add and remove fields in a PivotTable
• Filter data in a PivotTable
• Add additional data to the PivotTable
• Rename fields in the PivotTable
• Sort and group data in the PivotTable
• Change how numerical data in the PivotTable is summarized and formatted
• Change the style and layout of the PivotTable

Estimated completion time (hours): 2.3