View 2 short videos:
https://excelexposure.com/excel-video-lesson-intro-to-pivot-tables/
and
https://excelexposure.com/advanced-pivot-tables-round-1/
Use the related data sheet in the Master Workbook to answer the following questions. 5 points possible.
https://excelexposure.com/workbook/
By 11:59 pm on the due date, submit to your instructor, via Canvas email, your pivot tables to show the answers for each.
1.
Create a pivot table, using the entire spreadsheet of data.
2.
Create the field list:
a.
Units to values
b.
Items to rows
c.
Month to columns
d.
Employee to filters
3.
What is the sum of units for each item for each month?
4.
What is the grand total of each item for the year?
5.
Value field setting (units are your values)
a.
Show data as % parent row
b.
Show data as % parent column
c.
Show data as % of total