{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

SalesData - Week Six Excel Project Author Date Completed...

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

View Full Document Right Arrow Icon
Week Six: Excel Proje Author: Nicole Anderson Date Completed: 5/27/2011 Purpose: Demonstrate our mastery of Microsoft Excel Skills lear This particular project analyzes sales data in three diffe Sheet: 1 Original Sales Data 2 Subtotals by Sales by Country 3 CHART: Gross Revenue by Country 4 Pivot Chart of Sales Representatives Net Income 5 CHART: Net Income by Sales Rep 6 Net Sales by Month in 2005 7 CHART: Net Sales in 2005 by Month
Background image of page 1

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

View Full Document Right Arrow Icon
ect rned in BIS155 erent ways.
Background image of page 2
Nicole Anderson Sheet: 1 BIS155 - Professor Jones Page: 3 of 154 Date Printed: 05/27/2011 Northwind Traders Order Category Name Last Name First Name Country Order Date Product Unit Purchase Price Quantity 1 Dairy Products Buchanan Steven France 1-Aug-04 Mozzarella di Giovanni $34.80 5 2 Dairy Products Buchanan Steven France 1-Aug-04 Queso Cabrales $14.00 12 3 Grains/Cereals Buchanan Steven France 1-Aug-04 Singaporean Hokkien Fried Mee $9.80 10 4 Produce Suyama Michael Germany 2-Aug-04 Manjimup Dried Apples $42.40 40 5 Produce Suyama Michael Germany 2-Aug-04 Tofu $18.60 9 6 Grains/Cereals Leverling Janet France 5-Aug-04 Gustaf's Kn?ckebr?d $16.80 6 7 Seafood Peacock Margaret Brazil 5-Aug-04 Jack's New England Clam Chowder $7.70 10 8 Condiments Leverling Janet France 5-Aug-04 Louisiana Fiery Hot Pepper Sauce $16.80 20 9 Condiments Peacock Margaret Brazil 5-Aug-04 Louisiana Fiery Hot Pepper Sauce $16.80 15 10 Produce Peacock Margaret Brazil 5-Aug-04 Manjimup Dried Apples $42.40 35 11 Grains/Cereals Leverling Janet France 5-Aug-04 Ravioli Angelo $15.60 15 12 Dairy Products Peacock Margaret Belgium 6-Aug-04 Camembert Pierrot $27.20 40 13 Dairy Products Peacock Margaret Belgium 6-Aug-04 Geitost $2.00 25 14 Confections Peacock Margaret Belgium 6-Aug-04 Sir Rodney's Marmalade $64.80 40 15 Beverages Leverling Janet Brazil 7-Aug-04 Chartreuse verte $14.40 42 16 Dairy Products Leverling Janet Brazil 7-Aug-04 Gorgonzola Telino $10.00 20 17 Confections Leverling Janet Brazil 7-Aug-04 Maxilaku $16.00 40 18 Beverages Buchanan Steven Switzerland 8-Aug-04 Guaranà Fantàstica $3.60 15 19 Produce Buchanan Steven Switzerland 8-Aug-04 Longlife Tofu $8.00 21 20 Meat/Poultry Buchanan Steven Switzerland 8-Aug-04 Pät? chinois $19.20 21 21 Beverages Dodsworth Anne Switzerland 9-Aug-04 Chang $15.20 20 22 Seafood Dodsworth Anne Switzerland 9-Aug-04 Inlagd Sill $15.20 25 23 Confections Dodsworth Anne Switzerland 9-Aug-04 Pavlova $13.90 35 24 Dairy Products Dodsworth Anne Switzerland 9-Aug-04 Raclette Courdavault $44.00 30 25 Condiments Leverling Janet Brazil 12-Aug-04 Original Frankfurter grÙne So¤e $10.40 12 26 Meat/Poultry Leverling Janet Brazil 12-Aug-04 Perth Pasties $26.20 15 27 Beverages Peacock Margaret Venezuela 13-Aug-04 Chartreuse verte $14.40 6 28 Condiments Peacock Margaret Venezuela 13-Aug-04 Original Frankfurter grÙne So¤e $10.40 15 29 Confections Peacock Margaret Venezuela 13-Aug-04 Schoggi Schokolade $35.10 25 30 Beverages Davolio Nancy Austria 14-Aug-04 Chang $15.20 50 31 Condiments Davolio Nancy Austria 14-Aug-04 Chef Anton's Gumbo Mix $17.00 65 32 Dairy Products Davolio Nancy Austria 14-Aug-04 Mascarpone Fabioli $25.60 6 33 Seafood Peacock Margaret Mexico 15-Aug-04 Gravad lax $20.80 1 34 Confections Peacock Margaret Mexico 15-Aug-04 Sir Rodney's Scones $8.00 10
Background image of page 3

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

View Full Document Right Arrow Icon
Nicole Anderson
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}