 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
ECDL Spreadsheets with MS Excel 97
Course Aims
This course is designed to prepare readers for the ECDL module 4 examination. The course will allow readers to create, edit and print spreadsheets in Microsoft Excel 97. The course closely follows ECDL syllabus version 3.0, but can also be used in conjunction with the earlier syllabus, version 1.5. |
Assumed Knowledge
A basic understanding of PCs, familiarity with the layout of a standard keyboard plus knowledge of MS Windows is required, gained either by previous experience or by attendance on a "Using the Computer and Managing Files" course. |
Course Audience
Intending, new or recent users of MS Excel 97 who want to get to grips with the basics of this package in a short space of time. |
|
Table of Contents
|
Getting Started with Excel 97
|
What is a Spreadsheet? Starting Excel 97
|
|
The Excel 97 Opening Screen; The Title Bar
|
|
The Menu Bar; Toolbars; Formula Bar; Name Box
|
|
Scroll Bars; Active Cell, Column and Row Headers
|
|
Sheet Tabs; The Status Bar; Menus and Submenus
|
|
SpeedKeys; Dialogue Boxes; Exiting Excel
|
|
|
|
Creating Workbooks
|
Moving Around the Sheet; The Mouse Pointer
|
|
Selecting Cells with the Mouse and Keyboard
|
|
Using Go To; Spreadsheet Data Types
|
|
Entering and Editing Data; Editing Long Entries
|
|
Undoing Incorrect Edits; AutoFill; Custom Lists
|
|
Moving Data with Drag-and-Drop
|
|
Clearing Data from the Sheet
|
|
Saving, Closing and Opening a Workbook
|
|
|
|
Entering Basic Calculations
|
Using Relative and Absolute Cell Addresses
|
|
|
Formatting the Worksheet
|
Enhancements; Alignment; Resizing Columns and Rows
|
|
Adding Borders and Shading; Formatting Numbers
|
|
|
|
Structuring the Worksheet
|
Moving Entries (Cut and Paste)
|
|
Copying Cell Contents (Copy and Paste)
|
|
Inserting and Deleting Rows and Columns
|
|
Inserting and Deleting Worksheets; Sorting Data
|
|
Finding and Replacing Data; The Spelling Checker
|
|
|
|
Printing
|
Print Preview; Changing the Page Setup; Printing
|
|
|
|
Working with Multiple Sheets
|
Worksheet Linking; Preventing Rounding Errors
|
|
Opening a Second Workbook; Working with Large Sheets
|
|
Using Paste Special; Object Linking and Embedding
|
|
|
|
Charts and Graphics
|
Creating Charts; Printing Charts
|
|
Using the Drawing Tools; Inserting WordArt
|
|
Inserting Clip Art; Manipulating Objects
|
|
|
|
Working with Other Applications
|
Saving a File for Use in Another Application
|
|
Saving a Worksheet for the Web
|
|
Inserting Symbols and Special Characters
|
|
|
|
|
|
