Spreadsheets Series -

Spreadsheets IV

--------------------------------------------------------------------------------------

1. A look back at the toolbars
1. Standard
2. Formatting
2. A second look at "Format" and "Tools" pull down menus
3. Linking separate sheets and files
1. =SUM(B5:B8)
2. =C11+Sheet2!C11
3. =C13+[david.xls]Sheet1!$B$9
4. Saving the file
1. choose options
2. set a password
5. Share, Protect, Lock, or Hiding data – ALWAYS PROTECT FIRST!
1. Share "tools pull down menu/protection/protect and share"
2. Protect "tools pull down menu/protection/protect"
3. Lock "right click/format cells/protection"
4. Hide "right click/hide or "right click/format cells/protection"
6. Hiding Columns
7. Databases and the next step with your data…