Seniors helping seniors use computers and the internet


Spreadsheets Synopsis

 Spreadsheet programs are used for organizing, formatting, and calculating numeric data.  They display data in a row-and-column format, with gridlines between the rows and columns, similar to accounting ledger books or graph paper.  Consequently, they are well suited for working with numeric data for accounting, scientific research, statistical recording, and any other situation that can benefit from organizing data in a table-like format.  Related worksheets can be grouped in a workbook for convenience.

A spreadsheet program will provide for:

  1. Creating, saving and re-opening a workbook (including from prepared templates)
  2. Entering and editing data in worksheets - numbers, text and dates
  3. Accessing, adding, removing and renaming worksheets
  4. Formatting worksheet data
  5. Performing arithmetical operations on worksheet data (including between worksheets)
  6. Sorting and selective display of worksheet data
  7. Printing worksheets
  8.  Using functions on worksheet data
    • Inserting functions
    • Absolute and relative data references
    • Text manipulation
  9. Numbered series and autofill
  10. Data entry forms
  11. Charts
  12. Mail merging from worksheet data

In order to allow members to consolidate their knowledge, the topics above are split between two courses. Spreadsheets I covers items 1-7, and Spreadsheets II continues with items 8-12.

Microsoft Excel is the spreadsheet program which will be used in these courses.



Copyright © Ken Curwen 2012 - 2019