 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
CLAIT Level 1 - Spreadsheets, Graphs, and Charts with Excel 2002
Course Aims
This course is designed to help people to obtain the skills and knowledge required for New CLAIT/CLAIT Plus Unit 3 "Spreadsheets" and Unit 7 "Graphs and Charts". Students will learn to use Excel 2002 to create, edit, format, and print a simple spreadsheet. Readers will also learn to use Excel to create and format charts and graphs of different types based on data stored in a spreadsheet. |
Assumed Knowledge
You should be able to use a personal computer, mouse, and keyboard to create a file and enter and edit data. Typically you will either have basic previous experience with a computer or completed a "Using the Computer" course. |
Course Audience
This course is intended for people who are pursuing the New CLAIT or CLAIT Plus qualifications and seeking basic skills in using spreadsheets. |
|
Table of Contents
|
Office 2002 - Getting Started
|
Start an Office application
|
|
Recognise the different elements of an Office application window
|
|
Display and select commands from menus and toolbars
|
|
Use the keyboard to select commands
|
|
Close an Office application
|
|
|
|
Excel 2002 - What is Excel?
|
Understand the functions of spreadsheet application
|
|
Recognise the different elements of the Excel screen
|
|
|
|
Excel 2002 - Creating a Workbook
|
Move around the worksheet using the mouse and keyboard
|
|
Select cells using the mouse and the keyboard
|
|
Use zoom to view a worksheet at different magnification
|
|
|
|
Office 2002 - Managing Office Files
|
Use Save to create a file with a specified name and location
|
|
Use Save As to create a copy of a file with a different name and location
|
|
Create a new folder in which to save a file
|
|
Locate and open an existing file
|
|
Switch between file windows
|
|
Close or save all open documents
|
|
|
|
Excel 2002 - Entering and Editing Data
|
Enter text, values, and dates in cells
|
|
|
|
Excel 2002 - Creating a Formula
|
Understand what a formula is and how to create simple calculations
|
|
Enter a formula by typing or by using the Formula bar
|
|
Enter a range within a formula using the mouse
|
|
Use relative and absolute cell references
|
|
|
|
Excel 2002 - Moving and Copying Data
|
Use Drag-and-Drop to move or copy cell contents
|
|
Move, copy, and paste data using the Windows Clipboard
|
|
|
Excel 2002 - Formatting Cell Contents
|
Apply font styles (typeface, size, colour, and styles)
|
|
Modify the alignment and orientation of cell contents
|
|
Merge and unmerge cells (to centre headings across columns)
|
|
Use the Format Painter to copy cell formats
|
|
Clear cell content and formats
|
|
|
|
Excel 2002 - Formatting Cell Values
|
Apply value formats (currency, percent, dates, and comma)
|
|
Change the currency symbol
|
|
Apply other formats (accounting, time, text, general)
|
|
|
|
Excel 2002 - Structuring a Worksheet
|
Modify the size of columns and rows
|
|
Insert and delete rows and columns
|
|
Insert and delete selected cells
|
|
|
|
Excel 2002 - Printing Worksheets and Workbooks
|
Print a workbook (all sheets in book)
|
|
Display formulas in worksheet cells
|
|
Set, print, and clear a print area
|
|
Print a group of worksheets
|
|
|
|
Excel 2002 - Creating a Chart
|
Use the Chart Wizard to create different chart types
|
|
Reposition, resize, and delete a chart
|
|
Preview and print a chart
|
|
|
|
Excel 2002 - Formatting a Chart
|
Add, remove, move, resize, and modify chart elements (titles, labels, legend, axes, gridlines)
|
|
Format chart elements (borders, patterns, font, values)
|
|
Format chart axes (number format, text, and line width)
|
|
Format data series (scale, shading, spacing, and width)
|
|
|
|
|
|
