Excel_Project_Z

Excel_Project_Z - Week 6 Excel Project Creator Eric...

Info iconThis preview shows pages 1–3. 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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Week 6 Excel Project Creator Eric Zakrzewski Date Created 2/7/2011 Todays Date 7/15/2011 Purpose Demonstrate our mastery of MS Excel skills. Analyze sales data Sheets Documentation: Information about Excel Project Sales Data: The original sales data and information Comments Eric Zakrzewski 07/15/2011 Julie Smith 2 Week 6 MS Excel Project Sales Data Order Category Name Last Name First Name Country Order Date Product Quantity Gross Revenue Net Revenue 1,515 Beverages Dodsworth Anne Argentina 10-Feb-06 Cªte de Blaye $263.50 2 $527.00 0% $0.00 $527.00 1,491 Beverages Fuller Andrew Argentina 4-Feb-06 Ipoh Coffee $46.00 7 $322.00 0% $0.00 $322.00 1,902 Beverages Callahan Laura Argentina 27-Apr-06 Lakkalik??ri $18.00 10 $180.00 0% $0.00 $180.00 2,076 Beverages Callahan Laura Argentina 26-May-06 Laughing Lumberjack Lager $14.00 20 $280.00 0% $0.00 $280.00 1,494 Beverages Fuller Andrew Argentina 4-Feb-06 Rh?nbr?u Klosterbier $7.75 20 $155.00 0% $0.00 $155.00 1,795 Beverages King Robert Argentina 7-Apr-06 Sasquatch Ale $14.00 20 $280.00 0% $0.00 $280.00 723 Beverages Callahan Laura Argentina 27-May-05 Steeleye Stout $18.00 3 $54.00 0% $0.00 $54.00 1,838 Condiments King Robert Argentina 15-Apr-06 Chef Anton's Gumbo Mix $21.35 20 $427.00 0% $0.00 $427.00 1,904 Condiments Callahan Laura Argentina 27-Apr-06 Original Frankfurter grÙne So¤e $13.00 15 $195.00 0% $0.00 $195.00 1,240 Condiments Peacock Margaret Argentina 21-Nov-05 Sirop d'?rable $28.50 10 $285.00 0% $0.00 $285.00 533 Confections Peacock Margaret Argentina 17-Mar-05 Gumb?r Gummib?rchen $24.90 6 $149.40 0% $0.00 $149.40 1,989 Confections Suyama Michael Argentina 11-May-06 Maxilaku $20.00 2 $40.00 0% $0.00 $40.00 1,736 Confections Davolio Nancy Argentina 27-Mar-06 Pavlova $17.45 6 $104.70 0% $0.00 $104.70 722 Confections Callahan Laura Argentina 27-May-05 Scottish Longbreads $12.50 6 $75.00 0% $0.00 $75.00 1,908 Confections Callahan Laura Argentina 27-Apr-06 Sir Rodney's Marmalade $81.00 15 $1,215.00 0% $0.00 $1,215.00 1,520 Confections Dodsworth Anne Argentina 10-Feb-06 Sir Rodney's Marmalade $81.00 5 $405.00 0% $0.00 $405.00 432 Confections Leverling Janet Argentina 6-Feb-05 Sir Rodney's Scones $8.00 12 $96.00 0% $0.00 $96.00 1,238 Confections Peacock Margaret Argentina 21-Nov-05 Sir Rodney's Scones $10.00 5 $50.00 0% $0.00 $50.00 2,074 Dairy Products Callahan Laura Argentina 26-May-06 Geitost $2.50 10 $25.00 0% $0.00 $25.00 1,400 Dairy Products Dodsworth Anne Argentina 14-Jan-06 Gorgonzola Telino $12.50 1 $12.50 0% $0.00 $12.50 1,735 Dairy Products Davolio Nancy Argentina 27-Mar-06 Mascarpone Fabioli $32.00 6 $192.00 0% $0.00 $192.00 1,839 Dairy Products King Robert Argentina 15-Apr-06 Mozzarella di Giovanni $34.80 5 $174.00 0% $0.00 $174.00 1,907 Dairy Products Callahan Laura Argentina 27-Apr-06 Queso Cabrales $21.00 30 $630.00 0% $0.00 $630.00 752 Dairy Products King Robert Argentina 5-Jun-05 Raclette Courdavault $55.00 2 $110.00 0% $0.00 $110.00 1,737 Grains/Cereals Davolio Nancy Argentina 27-Mar-06 Ravioli Angelo...
View Full Document

This note was uploaded on 07/15/2011 for the course BIS 155 taught by Professor Frye during the Spring '10 term at DeVry Chicago.

Page1 / 139

Excel_Project_Z - Week 6 Excel Project Creator Eric...

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

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