Notes_Tutorial4

Notes_Tutorial4 - 4) Check the sort / filter features 5)...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Sample Daily Sales at WildOutfitters.com DATA ORGANIZED PROPERLY for Pivot Table Wizard Sale Date Sales Associate Item Code Item Type Retail Price Units Sold 38930 MPG BP Backpack 165 2 38930 MPG HB Hiking Boots 110 4 38930 MPG SB Sleeping Bag 100 2 38930 KLL TT Tent 385 1 38931 MPG BP Backpack 165 4 38931 HMW HB Hiking Boots 110 6 38931 HMW SB Sleeping Bag 100 3 38931 KLL TT Tent 385 2 38932 PCA BP Backpack 165 0 38932 KLL HB Hiking Boots 110 3 38932 PCA SB Sleeping Bag 100 1 38932 KLL TT Tent 385 1 38933 MPG BP Backpack 165 0 38933 HMW HB Hiking Boots 110 1 38933 PCA SB Sleeping Bag 100 0 38933 MPG TT Tent 385 0 38934 MPG BP Backpack 165 1 38934 HMW HB Hiking Boots 110 1 38934 KLL SB Sleeping Bag 100 0 38934 KLL TT Tent 385 0 38935 MPG BP Backpack 165 2 38935 HMW HB Hiking Boots 110 6 38935 PCA SB Sleeping Bag 100 2 38935 KLL TT Tent 385 1 38936 KLL BP Backpack 165 3 38936 HMW HB Hiking Boots 110 2 38936 PCA SB Sleeping Bag 100 5 38936 HMW TT Tent 385 3 1) Format data as table 2) See how to enter a new row / column 3) Name Table as "Sales"
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4) Check the sort / filter features 5) Create a Pivot Table for analyzing weekly sales data 6) Examine gross profit for each sales associate by item type 7) Filter data by sales associate MPG 8) Add sales date to the Pivot Table 9) Move Sales Date to the top of the hierarchy 10) What insights can you get about the sales associates? 11) How can we better visualize the performance of each sales associate? 12) Format Pivot Table 13) Use currency format 14) Create a Pivot Chart (Stacked Cylinder) Our Cost Gross profit 80 170 50 240 45 110 100 285 80 340 50 360 45 165 100 570 80 50 180 45 55 100 285 80 50 60 45 100 80 85 50 60 45 100 80 170 50 360 45 110 100 285 80 255 50 120 45 275 100 855...
View Full Document

This note was uploaded on 08/06/2009 for the course MGCR mgcr-331 taught by Professor Addas during the Winter '09 term at McGill.

Page1 / 4

Notes_Tutorial4 - 4) Check the sort / filter features 5)...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online