SalesData.csv - Week Six: Excel Proje Author: Nicole...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: 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 ject rned in BIS155 ferent ways. 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...
View Full Document

This note was uploaded on 05/26/2011 for the course BUSN 155 taught by Professor Jones during the Spring '11 term at DeVry Chicago.

Page1 / 154

SalesData.csv - Week Six: Excel Proje Author: Nicole...

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