 Spreadsheets: Microsoft Excel 2003.
Microsoft Windows XP is used for
Spreadsheet and Database lessons. 4x2 hour Lessons:$20
The course has been prepared from material provided by SeniorNet Canterbury, whose design and layout work for the course handbook is gratefully acknowledged.
The course covers the following areas:
Screen basics; Data entry into a spreadsheet;
Editing and formatting; Using standard toolbars;
Calculations, formulas and functions;
Saving files; Copying and printing sheets;
Recording financial transactions; Constructing a database;
Managing sorting and filtering data; Using the drawing toolbar;
Creating charts; Other practical uses.
Desired Outcomes:
On completion of the course you should be able to:
- Prepare a spreadsheet, edit and format it
- Apply formulas and functions to a spreadsheet
- Use the standard and drawing toolbars
- Create charts from spreadsheet data
- Set up a database, manage, sort and filter it
- Print and copy spreadsheets or database information and
- Select from a range of other practical uses of Excel.
STYLE-->
Desired Outcomes:
When you have completed the course you should be able to:
Ø Prepare a spreadsheet, edit and format it,
Ø Apply formulas and functions to a spreadsheet,
Ø Use the standard and drawing toolbars,
Ø Create charts from spreadsheet data,
Ø Set up a database, manage, sort and filter it,
Ø Save an Excel file,
Ø Print and copy spreadsheets or database information and
Ø Select from a range of other practical uses of Excel.
|
