Lab Objective: Get comfortable with Excel and get ready to dive right in!

Lab Overview: Congratulations! You have been hired as a data person at a small nonprofit! You will be modifying a currently existing inventory system (Link to file below) and breaking it out into inventory by location. You will then be using VLOOKUPS to give them information. What your client is looking for exactly is spelled out under What they want to know they would like it in a separate sheet called Inventory Numbers add in the following information.

Item Quantity Price Store A 3 $3.00 A B 1 $4.00 B C 2 $5.00 C D 3 $5.50 A E 0 $0.30 B F -5 $0.40 C G 5 $0.50 A H 2 $0.70 B

What they want to know

• They want the original sheet to be green and the Inventory Numbers sheet to be Blue
• They would like the sheets containing the information for the three stores hidden
• They would like the Inventory Numbers sheet to be first, and the Inventory sheet to be second
• They would like information on.
  • Given an item number(Hint: Use VLookups here!)
    • How many items are in stock in the entire inventory?
  • Make your spreadsheet look neat
    • Think about it.how would YOU like the information presented to you? Explain why you chose to organize it the way you did in your decision document.