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:
- Creating, saving and re-opening a workbook (including from prepared templates)
- Entering and editing data in worksheets - numbers, text and dates
- Accessing, adding, removing and renaming worksheets
- Formatting worksheet data
- Performing arithmetical operations on worksheet data (including between worksheets)
- Sorting and selective display of worksheet data
- Printing worksheets
- Using functions on worksheet data
- Inserting functions
- Absolute and relative data references
- Text manipulation
- Numbered series and autofill
- Data entry forms
- Charts
- 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.