Excel_Project_Z - Week 6 Excel Project Creator Date Created...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
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
Image of page 1

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

View Full Document Right Arrow Icon
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 $19.50 20 $390.00 0% $0.00 $390.00 1,237 Produce Peacock Margaret Argentina 21-Nov-05 Manjimup Dried Apples $53.00 7 $371.00 0% $0.00 $371.00 1,794 Produce King Robert Argentina 7-Apr-06 R?ssle Sauerkraut $45.60 8 $364.80 0% $0.00 $364.80 433 Produce Leverling Janet Argentina 6-Feb-05 Tofu $18.60 12 $223.20 0% $0.00 $223.20 1,843 Produce King Robert Argentina 15-Apr-06 Uncle Bob's Organic Dried Pears $30.00 6 $180.00 0% $0.00 $180.00 532 Seafood Peacock Margaret Argentina 17-Mar-05 Boston Crab Meat $14.70 20 $294.00 0% $0.00 $294.00 720 Seafood Callahan Laura Argentina 27-May-05 Jack's New England Clam Chowder $9.65 10 $96.50 0% $0.00 $96.50 1,702 Seafood Peacock Margaret Argentina 20-Mar-06 Konbu $6.00 5 $30.00 0% $0.00 $30.00 1,661 Seafood Peacock Margaret Argentina 11-Mar-06 R?d Kaviar $15.00 10 $150.00 0% $0.00 $150.00 1,993 Seafood Suyama Michael Argentina 11-May-06 Spegesild $12.00 3 $36.00
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern