Excel Intermediate

profileShavone05
gifts.xlsx

Inventory

Vendor Item Date Category 1-Month Order Category Total Order
All Foods Tea 8/30/10 Food $ 500 Book
Epicurean Delights Jam 8/31/10 Food $ 998
All Foods Coffee 9/1/10 Food $ 900
Epicurean Delights Bottled water 9/2/10 Food $ 2,800
Souvenir Trade Short sleeve t-shirts 9/3/10 Clothing $ 2,500
Best T Long sleeve t-shirts 9/4/10 Clothing $ 2,390
Readers Vermont travel guides 9/5/10 Book $ 580
Best Sellers Vermont maps 9/6/10 Book $ 400
Readers Paperback books 9/7/10 Book $ 1,500
Best Sellers Vermont history books 9/8/10 Book $ 1,050
Epicurean Delights Candy 9/9/10 Food $ 800
Best T Baseball caps 9/10/10 Clothing $ 1,900
Souvenir Trade Robes 9/11/10 Clothing $ 2,100
Best Sellers Magazines 9/12/10 Book $ 1,200
Readers Sudoku and Crosswords 9/13/10 Book $ 800
Best Sellers Vermont cookbooks 9/14/10 Book $ 1,000
Souvenir Trade Silk Ties 9/15/10 Clothing $ 1,800
Best T Sweatshirts 9/16/10 Clothing $ 2,100
Souvenir Trade Umbrellas 9/17/10 Clothing $ 280
Souvenir Trade Postcards 9/18/10 Book $ 900
Best T Towels 9/19/10 Clothing $ 1,000
Souvenir Trade Earrings 9/20/10 Clothing $ 1,500
Souvenir Trade Bracelets 9/21/10 Clothing $ 1,300
Best Sellers Cards 9/22/10 Book $ 1,250
Souvenir Trade Swim trunks 9/23/10 Clothing $ 1,000
Best T Swimsuits 9/24/10 Clothing $ 1,500
Allmart Toothpaste 9/25/10 Personal $ 200
Allmart Toothbrushes 9/26/10 Personal $ 250
Allmart Aspirin 9/27/10 Personal $ 560
Allmart Shampoo 9/28/10 Personal $ 800
Allmart Deodorant 9/29/10 Personal $ 900
Allmart Comb 9/30/10 Personal $ 1,100
Allmart manicure sets 10/1/10 Personal $ 1,400
Vendor Item Date Category 1-Month Order

Sheet2

Sheet3