- After Following The Tutorial To Create A Pivottable Your Final Table Should Match The Table Shown Below Agendas 110 0 1 (26.99 KiB) Viewed 26 times
- After Following The Tutorial To Create A Pivottable Your Final Table Should Match The Table Shown Below Agendas 110 0 2 (53.23 KiB) Viewed 26 times
- After Following The Tutorial To Create A Pivottable Your Final Table Should Match The Table Shown Below Agendas 110 0 3 (42.27 KiB) Viewed 26 times
- After Following The Tutorial To Create A Pivottable Your Final Table Should Match The Table Shown Below Agendas 110 0 4 (31.24 KiB) Viewed 26 times
- After Following The Tutorial To Create A Pivottable Your Final Table Should Match The Table Shown Below Agendas 110 0 5 (93.27 KiB) Viewed 26 times
- After Following The Tutorial To Create A Pivottable Your Final Table Should Match The Table Shown Below Agendas 110 0 6 (84.66 KiB) Viewed 26 times
- After Following The Tutorial To Create A Pivottable Your Final Table Should Match The Table Shown Below Agendas 110 0 7 (79.54 KiB) Viewed 26 times
Office Warehouse Inc. currently makes four products. The Sales Director has asked you to run a = preliminary analysis on last year's sales data, which has been cleaned and is given on the Original Data tab. The products made by the company and sales price per unit are listed below. Use the different data visualization methods recommended in each requirement to analyze the company's sales data. Products Available Price per Unit Paper $ 21.00 per case Pens $ 8.00 per box Sticky Notes $ 10.00 per package Envelopes $ 4.00 per box Required Create a Pivot Table to answer each question below while analyzing the data. Which product had the highest total units ordered and highest total sales? Product Total Units Ordered Total Sales Which rep has the highest total sales forleach region?
Which rep has the highest total sales for each region? G Rep Name Total Sales Region East Midwest South West What is the total annual sales for each region? Total Sales Region East Midwest South West Using the data above, create a pie chart lo determine the sales percentage for each region. Sales Percentage Region East Midwest
Using the data above, create a pie chart to determine the sales percentage for each region Sales Percentage Region East Midwest South West Now, create a Pivot Table to determine the monthly sales eamed by each region. Use that data to create a 2D clustered column chart, Based on that column bar chart, identify the regions that had the highest and lowest monthly sales for the entire year. Region Month Total Sales Region with Highest Earning Month Region with Lowest Earning Month
8 $ 10 $ 20 $ 9 $ 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 4-Jan 4-Jan 5-Jan 6-Jan 6-Jan 7-Jan 8.Jan 8-Jan 9. Jan 10-Jan 10-Jan 11-Jan 12-Jan 12-Jan 13-Jan 14-Jan 14-Jan 15-Jan 16.Jan 16-Jan 17-Jan 18-Jan 18-Jan 19-Jan 20-Jan 20-Jan 21-Jan 22-Jan 22-Jan 23-Jan 24-Jan 24.Jan 25-Jan 26.Jan 26.Jan 27an Region East East East East East East South East West Midwest South West South East East West East West Midwest South South East Midwest South South South East South Midwest South Midwest East South East Midwest Gauth пер Hanks Hanks Hanks Allen Smith Smith Harris Hanks Moore Phillips Wilson Garcia Harris Allen Smith Moore Allen Garoia Johnson Brown Brown Hanks Johnson Brown Wilson Brown Allen Harris Johnson Harris Johnson Allen Harris Smith Peters Wils Paper Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes Paper Paper Sticky Notes Envelopes Paper Paper Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes Papet Paper Sticky Notes Etiolanec 10 $ 23 $ 9 $ 10 $ 10 $ 25 $ 10 $ 11 $ 10 $ 27 $ 9 $ 12 $ 10$ 30$ 7 $ 13 $ 10 $ 29 $ 12 $ 14 $ 10 $ 28 $ 13 $ 15$ 11 $ 21 $ 9 $ 13 $ 12 $ 23 21.00 $ 8.00 $ 10.00 $ 4.00 $ 21.00 $ 8.00 $ 10.00 $ 4.00 $ 21.00 $ 21.00 $ 10.00 $ 4.00 $ 21.00 $ 21.00 $ 10.00 $ 4.00 $ 21.00 $ 8.00 $ 10.00 $ 4.00 21.00 $ 8.00 $ 10.00 $ 4.00 $ 21.00 $ 8.00 $ 10.00 $ 4.00 $ 21.00 $ 8,00 $ 10.00 $ 4.00 $ 21.00 $ 21.00 $ 10.00 $ 168.00 80.00 200.00 32.00 189.00 80.00 230,00 36.00 210.00 210.00 250,00 40.00 231.00 210.00 270.00 36.00 252,00 80.00 300.00 28.00 273.00 80.00 290.00 48.00 294.00 80.00 280.00 52.00 315.00 88.00 210.00 36.00 273.00 252.00 230.00 031 032 033 034 035 AS
8$ Envelopes Paper Paper Sticky Notes Envelopes Paper 37 38 39 40 41 42 43 44 45 46 47 48 49 50 036 037 038 039 040 041 042 043 044 045 046 047 048 049 050 051 052 053 054 055 阳形如印而 52 53 54 55 56 57 58 59 60 27.Jan 28-Jan 28.Jan 29. Jan 30-Jan 30-Jan 31-Jan 1.Feb 1-Feb 2.Feb 3.Feb 3-Feb 4.Feb 5-Feb 5.Feb 6.Feb 7-Feb 7.Feb 8.Feb 9.Feb 9.Feb 10-Feb 11. Feb 11. Feb 12-Feb 13-Feb 13-Feb 14-Feb 15-Feb 15 Feb 16-Feb 17.Feb 17-Feb 18-Feb 19-Feb 19.Feb 20. NRY 2X98X28.8 28889898 South Midwest South West Midwest East Midwest Midwest Midwest South East West Midwest Midwest Midwest Vest Midwest West Midwest Midwest Midwest Midwest West East East Midwest East South East West South East Midwest Midwest West East BRE Wilson Johnson Wilson Garcia Johnson Allen Johnson Peters Johnson Wilson Allen Moore Peters Peters Peters Moore Phillips Garcia Phillips Phillips Peters Johnson Garcis Hanks Hanks Phillips Hanks Brown Smith Williams Brown Hanks Phillips Peters Moore Smith Diten 130$ 24 $ 11 $ 8 $ 10 $ 27 $ 12 $ 7$ 10 $ 29 $ 10 $ 10$ 10$ 26 $ 8$ 9 $ 10$ 20$ 9 $ 15$ 105 23 3 Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes Papel Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes Papet Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes 4.00 $ 32.00 21.00 $ 231.00 21.00 $ 273.00 10.00 $ 240.00 4.00 $ 44.00 21.00 $ 168.00 8.00 $ 80.00 10.00 $ 270.00 4.00 $ 48.00 21.00 $ 147.00 8.00 $ 80.00 10.00 $ 290.00 4.00 $ 40.00 21.00 $ 210.00 8,00 $ 80.00 10.00 $ 260.00 14.00 $ 32.00 21.00 $ 189.00 8,00 $ 80.00 10.00 $ 200.00 4.00 $ 36.00 21.00 $ 315.00 8.00 $ 80.00 10.00 $ 230.00 4.00 $ 40.00 21.00 $ 168.00 8.00 $ 80,00 10.00 $ 250.00 4.00 $ 36.00 21.00 $ 189.00 8.00 $ 80.00 10.00 $ 270.00 4.00 $ 28.00 21.00 $ 169.00 21.00 210.00 300.00 056 25$ 62 63 64 65 66 67 68 69 70 71 72 057 058 059 060 061 062 063 064 065 066 067 068 069 070 071 072 10 275 7 Paper Paper Sticky Notes ELE 10$ 305 10.00 $
Envelopes Paper Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes Papet Pens Sticky Notes Envelopes 13 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 Papel U12 073 074 075 076 077 078 079 080 081 082 083 084 085 086 087 088 089 090 091 092 093 094 095 096 097 098 099 100 101 102 103 104 105 106 107 th Pens Sticky Notes Envelopes 20-Feb 21-Feb 21-Feb 22-Feb 23-Feb 23-Feb 24-Feb 25 Feb 25-Feb 26 Feb 27 Feb 27 Feb 28 Feb 1-Mar 1-Mar 2-Mar 3.Mar 3.Mar 4. Mar 5.Mar 5.Mar 6-Mar 7.Mar 7.Mar 8.Mar 9.Mar 9-Mar 10-Mar 11. Mar 11.Mar 12-Mar 13-Mar 13.Mar 14.Mar 15-Mar 15-Mar SAM 12 $ 9 $ 10 $ 29 $ 13 $ 10 $ 10$ 28. $ 9 $ 11 $ 10$ 21 $ 8$ 12$ 10 $ 23 $ 11 $ 13 $ 10$ East East South South West Midwest South East South Midwest South East West East Midwest South West East Midwest East South East South West South East Midwest Midwest South East East South South East South Vest Midno Allen Hanks Harris Harris Garcia Phillips Wilson Smith Brown Phillips Brown Allen Moore Smith Johnson Wilson Williams Hanks Peters Allen Harris Hanks Harris Garcia Harris Allen Phillips Johnson Wilson Smith Hanks Harris Wilson Smith Wilson Moore Lahasan Paper 4.00 $ 21.00 $ 8.00 $ 10.00 $ 4.00 $ 21.00 $ 8.00$ 10.00 $ 4.00 $ 21.00 $ 8.00 $ 10.00 $ 4.00 $ 21.00 $ 8.00 $ 10.00 $ 4.00 $ 2100 $ 8.00 10.00 $ 4.00 $ 21.00 $ 8.00 $ 10.00 $ 4.00 2100 8.00 $ 10.00 $ 4.00 $ 21.00 $ 8.00 $ 10.00 $ 4.00 $ 2100 $ 2100 $ 10.00 48.00 189.00 80.00 290.00 52.00 210.00 80.00 280.00 36.00 231.00 80.00 210.00 32.00 252.00 80.00 230,00 44.00 273.00 80.00 240.00 48.00 168,00 80.00 200.00 40.00 189,00 88.00 280.00 32.00 210.00 96.00 250.00 36,00 23100 273.00 270.00 24 $ Pens Stioky Notes Envelopes Paper Pens Sticky Notes Envelopes Paper Pens Sticky Notes Envelopes 12 $ 8 $ 10 $ 20$ 10 $ 9 $ 11 $ 23 $ 8 10 $ 125 255 8 $ 11 $ 13 $ 275 10 Paper Pens Sticky Notes Envelopes Paper Paper 108 100 Sticky Notes Bademar