Spreadsheets Series -

Spreadsheets III

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

Course Outline:

  1. Filling A Formula
    1. The Auto-fill feature
      1. Two cells required
      2. Move mouse to bottom right corner and drag the thin cross-hair
      3. Drag and fill the cells
    2. The problem with fixed cell values
      1. "$" and how it can solve the problem
  2. Sorting your data (data pull-down menu)
  3. Excel Charts
    1. Selecting the data to make a chart from
    2. Formatting the chart
      1. Sizing
      2. Colors
      3. Moving
      4. Printing
      5. Text changes
    3. Changing the data within the chart
  4. Multiple Sheets and how best to use them…