1. Open Microsoft Excel 2007
2. Click the "Data" tab
3. On the "Data Tools" section, click the "Data Validation" button
4. On the "Data Validation" window on the "Settings" tab, choose "List" from the "Allow:" drop-down menu
5. In the "Source" field, type a list of values separated by commas
6. Click the "OK" button

Alternate method:

1. Open Microsoft Excel 2007
2. Click the "Data" tab
3. On the "Data Tools" section, click the "Data Validation" button
4. On the "Data Validation" window on the "Settings" tab, choose "List" from the "Allow:" drop-down menu
5. To the immediate right of the "Source" field, click the cell selection button (it looks like a miniature spreadsheet with a red arrow pointing to the top-left corner)
6. Select the cells to be used as values for the drop-down menu
7. Click the red X in the upper-right corner of the "Data Validation" window
8. Click "OK"

1. Open Microsoft Excel 2007
2. Click the "Office" button (it's the circle with the four multicolored squares in the upper left hand corner of the Excel window)
3. Mouse over the "Save As" item
4. Click on "Excel 97-2003 Workbook"
5. On the "Save As" window, navigate to the desired location and enter a file name in the "File name:" field
6. Click "Save"
7. Click the "Office" button
8. Click the "Excel Options" button
9. Select the "Save" option on the left navigation
10. Under the "Save workbooks" section, on the "Save files in this format:" drop-down menu, select "Excel 97-2003 Workbook (*.xls)"
11. Click "OK"

1. Go to this website: http://www.microsoft.com/downloads/details.aspx?FamilyId=4D951911-3E7E-4AE6-B059-A2E79ED87041&displaylang=en
2. Click the "Continue" button
3. On the next web page, an "Internet Explorer - Security Warning" window will pop up
4. Click the "Install" button
5. On the next web page, click "Download"
6. On the "File Download - Security Warning" window, click "Save"
7. On the "Save As" window, choose a location to which the file should be saved
8. Click the "Save" button
9. On the "Download complete" window, click the "Run" button
10. On the "Internet Explorer - Security Warning" window, click the "Run" button
11. On the "Microsoft Save as PDF or XPS Add-in for 2007 Microsoft Office programs" window, check the "Click here to accept the Microsoft Software License Terms" checkbox
12. Click the "Continue" button
13. On the "Microsoft Save as PDF or XPS Add-in for 2007 Microsoft Office programs" window, click the "OK" button
14. Open Microsoft Excel 2007
15. Click the "Office" button (it's the circle with the four multicolored squares in the upper left hand corner of the Excel window)
16. Mouse over the "Save As" option
17. Click on "PDF or XPS"
18. On the "Publish as PDF or XPS" window, select "PDF (*.pdf)" from the "Save as type:" drop-down menu
19. Click the "Publish" button

1. Open Microsoft Excel 2007
2. Select a cell or a group of cells
3. Click on the "Data" tab
4. On the "Data Tools" section, click the "Data Validation" button
5. Click the appropriate value from the "Allow:" drop-down menu, and any subsequent menus
6. Click the "OK" button

1. Open Microsoft Excel 2007
2. Click the "Zoom In" button at the bottom right of the screen (it looks like a "+" symbol on a round button)
3. Click the "Zoom Out" button (it looks like a "-" symbol on a round button)
4. Click-and-drag the slider to the right or the left to increase or decrease the zoom factor
5. Click the "Zoom Level" button (in other words, click on the zoom percentage display - e.g., 100%, 140%, 71%, etc.)
6. Click the "Cancel" button
7. Click the "View" tab
8. On the "Zoom" section, click the "Zoom" button
9. Click the "100%" button

1. Open Microsoft Excel 2007
2. Click the "Office" button (it's the circle with the four multicolored squares in the upper left hand corner of the Excel window)
3. Click on "Excel Options"
4. Select the "Save" option on the left navigation
5. Under the "Save Workbooks" section, enter a new value in the "Default file location:" field
6. Click the "OK" button

1. From within another application (e.g., Notepad), copy a selection of text that will be pasted into Excel (after the text is highlighted, right-click on it and select "Copy" from the context menu)
2. Open Microsoft Excel 2007
3. Right-click on a cell and click on the "Paste" option in the context menu
4. Click on the "Data" tab
5. On the "Data Tools" section, click on the "Text to Columns" button
6. On the "Convert Text to Columns Wizard - Step 1 of 3" window, click the "Next" button
7. On the "Convert Text to Columns Wizard - Step 2 of 3" window, uncheck the "Tab" option
8. Check other options to see how it changes the data display (as shown in the "Data preview" window)
9. Click the "Finish" button

1. Open Microsoft Excel 2007
2. Select the data to be used in the pivot table
3. Click the "Insert" tab
4. Click the "PivotTable" button on the "Tables" section
5. On the "Create PivotTable" window, click the "OK" button
6. On the resulting new worksheet on the "PivotTable Field List" section on the right, click the checkboxes in front of the field names to be added to the pivot table

1. Open Microsoft Excel 2007
2. Select an entire column or an entire row
3. Click the "View" tab
4. On the "Window" section, click the "Freeze Panes" button
5. Click the "Freeze Panes" option
6. Select the same row or column
7. Click the "Freeze Panes" button
8. Select the "Unfreeze Panes" button

1. Open Microsoft Excel 2007
2. Select an entire column or an entire row
3. Click the "View" tab
4. On the "Window" section, click the "Split" button
5. Select the same row or column
6. Click the "Split" button again