
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 06 - working with PivotTables
Interactive Video
•
Information Technology (IT), Architecture
•
University
•
Practice Problem
•
Hard
Wayground Content
FREE Resource
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.
Read more
2 questions
Show all answers
1.
OPEN ENDED QUESTION
3 mins • 1 pt
Describe the process of applying a top five filter by sum of sales in the pivot table.
Evaluate responses using AI:
OFF
2.
OPEN ENDED QUESTION
3 mins • 1 pt
What is the final name given to the pivot table and how is it set?
Evaluate responses using AI:
OFF
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?