12 Days Excel: Part 1

Spreadsheet Table Instructions

Part 1: Setup and Input

Follow these directions for setting up your spreadsheet to calculate how expensive your 12 days can be.

Setup:

  1. Open/Create a New Sheet (green icon) in your Google Drive.
  2. Change the Document Title--> First & Last Name, 12 Days of (topic name here)
  3. In cell A1 type your first and last name.
  4. In cell A2 type your title (The 12 days of______).
  5. In row #4, beginning in cell B, fill across the days (etc. Day 1, Day 2, Day 3...). You should end on M4.
  6. Type "Number of Items" in N4
  7. Type "Cost Per Item" in O4.
  8. Type "Total Costs" in P4.
  9. Type "Item(s) each day" in A18
  10. Starting in A5, Begin typing your items in Column A. Be sure to include the hyperlinks to the actual item links! This is where your prep work will come in handy.
  11. Adjust the column width so all words fit properly in the area
    1. Either click and drag border lines in label header
    2. Or click the drop-down arrow next to the Column letter label--> Re-size Column--> Autofill

Information Input:

  1. Input the "Cost per Item" in column O. Refer to your Word document table.
  2. Now begin to enter data into the main part of your table. You are entering the quantity of the item each day. Pay attention to what cell you are filling in items (I find it helpful to sing the tune in my head as I fill in the table so they are in the correct location).