In this webinar, attendees will learn the basics of creating and manipulating PivotTables as well as a few tricks to make your PivotTable pop! This course will go beyond the simple creation of a pivot table—attendees will learn the various formatting and uses of this wonderful tool, such as inserting a slicer or performing a custom sort within a pivot table.

Learning Objectives: 

• Recall the various areas within the pivot table fields dialog box


• Identify how to drag fields into pivot table filters, rows, columns, and values areas


• Determine how to rename a pivot table field and format pivot table fields


• Identify how to create a calculated field within a pivot table and solve for pivot table value errors


• Recall how to select multiple items within a pivot table filter box and deselect subtotals within a pivot table