Spreadsheets Series -

Spreadsheets IV

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

Course Outline:

  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…