Excel Lists

Lists (Salaries) (35min) Download Excel Tutorial Lists and open the same workbook from tutorial one. With the tutorial 3 file open, right click on the "List" sheet tab at the bottom of the worksheet like the example on the right. Then move it to your main Excel workbook and make sure it is named using the format like the example: ca2joe14 Excel Tutorials. Arrange your sheet tabs in descending order, Tut 1 should be all the way to the right and right now you only need up to Tut 3.Then follow the directions in the two tutorials (video I, video II).

Follow the directions below as you watch

1. Unhide column B, players' last names; Cut and move column D (Salary) in-between columns F and G
2. Auto-size columns B-F; freeze the panes between rows 2 and 3
3. Go to A60 and insert a comment in the Salary cell that says the following: NBA salary before taxes. Format all the salaries to currency no decimal place
4. Go to Data >Forms and insert the name Freddy Jones, Salary: 11,000,000, Position:: Guard, Team: MIA, Total Deal: 1-yr . Then change the name Freddy Jones to your name.
5. Any players whose salary is greater than or equal to 10,000,000 add a conditioning format to change the salary cell to Bold, black background, red font, & underlined.
6. If Salary gets formatted black etc, click on the cell that has Position and then click the format painter icon and then click on the Salary cell.
7. Use the find and replace tool to replace all MIA to Miami
8. Use the sort tool to sort the players by team ascending, position descending, & then by salary ascending
9. Turn on the auto filter and filter/show only the players with a Team of Miami (do not use the filter to sort)
10. The video stops early and does not finish the last three directions but you previously learned merge cells and page setup in Word so you should be able to figure it out since you already learned merge cells from tut 1 and the margin and print is like Word.

1. Change all the text on the spreadsheet to 12pt by cmd + a and select 12 pt. Set the print area to print only the text currently shown on the page. To set the print area, highlight only the cells that have content in them and then go to File > Print Area > Set Print Area.
2. Change all of the margin to 2" top/bottom and .75" Left/Right. Check-mark center on page landscape and vertical.

1. Then go to File > Print > Preview and take a screenshot of the entire screen. Make sure you can read the header/footer. When you are finished, it should look like the screenshot below:

Post your print preview screenshot and post the file to posterous and the link to the spreadsheet.