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
NURS 6930 Webinar 2 Makeup instructions Due Sunday October 8, 2023 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 Sheet1 Order IDOrderDateMonthRegionEmployeeItemUnitsCostTotal 100011/5/11JanMidwestAdamsBinder9419.991879.06 100021/6/11JanNew EnglandJonesPencil951.99189.05 100031/13/11JanMidwestSmithPencil671.2986.43 100041/15/11JanMidwestDwyerBinder468.99413.54 100051/22/11JanMidwestAndrewsBinder284.99139.72 100061/23/11JanMidwestStevensonBinder5019.99999.5 100071/30/11JanNew EnglandParentPen Set1615.99255.84 100082/1/11FebMidwestSmithBinder87151305 100092/7/11FebNew EnglandJonesPencil951.99189.05 100102/9/11FebMidwestAdamsPencil364.99179.64 100112/16/11FebMidwestDwyerBinder288.99251.72 100122/18/11FebNew EnglandJonesBinder44.9919.96 100132/24/11FebMidwestStevensonBinder5019.99999.5 100142/26/11FebMidwestDwyerPen2719.99539.73 100153/5/11MarMidwestSmithPen648.99575.36 100163/7/11MarWest CoastBlackBinder719.99139.93 100173/13/11MarMidwestAdamsPencil364.99179.64 100183/15/11MarWest CoastBlackPencil562.99167.44 100193/22/11MarNew EnglandJonesPen1519.99299.85 100203/24/11MarMidwestAdamsPen Set504.99249.5 100213/30/11MarMidwestDwyerPen2719.99539.73 100224/1/11AprNew EnglandJonesBinder604.99299.4 100234/8/11AprWest CoastBlackPen Set964.99479.04 100244/10/11AprMidwestAndrewsPencil661.99131.34 100254/16/11AprWest CoastBlackPencil562.99167.44 100264/18/11AprMidwestAndrewsPencil751.99149.25 100274/25/11AprMidwestAdamsPencil671.2986.43 100284/27/11AprNew EnglandHowardPen964.99479.04 100295/3/11MayNew EnglandJonesBinder604.99299.4 100305/5/11MayMidwestAdamsPencil904.99449.1 100315/12/11MayMidwestAndrewsPen Set7415.991183.26 100325/14/11MayMidwestDwyerPencil531.2968.37 100335/20/11MayMidwestAndrewsPencil751.99149.25 100345/22/11MayWest CoastThompsonPencil321.9963.68 100355/29/11MayNew EnglandHowardBinder468.99413.54 100365/31/11MayMidwestDwyerBinder808.99719.2 100376/6/11JunMidwestAdamsPencil904.99449.1 100386/8/11JunNew EnglandJonesBinder608.99539.4 100396/15/11JunMidwestDwyerBinder87151305 100406/17/11JunMidwestStevensonDesk5125625 100416/23/11JunWest CoastThompsonPencil321.9963.68 100426/25/11JunMidwestMorganPencil904.99449.1 100437/2/11JulMidwestDwyerBinder44.9919.96 100447/4/11JulNew EnglandJonesPen Set624.99309.38 100457/10/11JulNew EnglandJonesBinder608.99539.4 100467/12/11JulNew EnglandHowardBinder291.9957.71 100477/19/11JulMidwestStevensonBinder719.99139.93 100487/21/11JulMidwestMorganPen Set5512.49686.95 100497/27/11JulMidwestMorganPencil904.99449.1 100507/29/11JulNew EnglandParentBinder8119.991619.19 100518/5/11AugNew EnglandJonesPen Set504.99249.5 100528/7/11AugMidwestStevensonPen Set4223.951005.9 100538/13/11AugNew EnglandHowardBinder291.9957.71 100548/15/11AugNew EnglandJonesPencil354.99174.65 100558/22/11AugMidwestMorganPencil661.99131.34 100568/24/11AugWest CoastBlackDesk3275825 100578/30/11AugNew EnglandParentBinder8119.991619.19 100589/1/11SepMidwestSmithDesk2125250 100599/8/11SepMidwestStevensonPen964.99479.04 100609/10/11SepMidwestDwyerPencil71.299.03 100619/16/11SepNew EnglandJonesPencil354.99174.65 100629/18/11SepNew EnglandJonesPen Set1615.99255.84 100639/25/11SepWest CoastBlackPencil531.2968.37 100649/27/11SepWest CoastBlackPen761.99151.24 1006510/3/11OctMidwestSmithDesk2125250 1006610/5/11OctMidwestMorganBinder288.99251.72 1006710/12/11OctMidwestDwyerBinder808.99719.2 1006810/14/11OctWest CoastThompsonBinder5719.991139.43 1006910/20/11OctNew EnglandJonesPen Set1615.99255.84 1007010/22/11OctNew EnglandJonesPen648.99575.36 1007110/29/11OctWest CoastBlackPen761.99151.24 1007210/31/11OctMidwestAndrewsPencil141.2918.06 1007311/6/11NovMidwestMorganBinder288.99251.72 1007411/8/11NovNew EnglandParentPen1519.99299.85 1007511/15/11NovWest CoastThompsonBinder5719.991139.43 1007611/17/11NovMidwestAdamsBinder114.9954.89 1007711/23/11NovNew EnglandJonesPen648.99575.36 1007811/25/11NovMidwestStevensonPen Set964.99479.04 1007912/2/11DecMidwestAndrewsPencil141.2918.06 1008012/4/11DecMidwestAdamsBinder9419.991879.06 1008112/10/11DecNew EnglandParentPen1519.99299.85 1008212/12/11DecMidwestSmithPencil671.2986.43 1008312/19/11DecMidwestAdamsBinder114.9954.89 1008412/21/11DecMidwestAndrewsBinder284.99139.72 1008512/27/11DecMidwestStevensonPen Set964.99479.04 1008612/29/11DecNew EnglandParentPen Set7415.991183.26