Using XLOOKUP
March 23, 2022
Managing Documents
March 23, 2022
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
Course ID Number: MSO-3003