Microsoft Excel 2021365 - Beginner to Advanced - Exercise 06 - working with PivotTables

This video tutorial guides viewers through creating and customizing a pivot table in Excel. It begins with setting up the pivot table using a clean data set, followed by adding categories, towns, and sales data. The tutorial covers renaming labels, turning off Grand Totals, applying currency formatting, and filtering the top five sales items. Finally, it demonstrates naming the pivot table for clarity.

Describe the process of applying a top five filter by sum of sales in the pivot table.

Evaluate responses using AI:

OFF

What is the final name given to the pivot table and how is it set?

Evaluate responses using AI:

OFF