 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 97 Essentials
Course Aims
This intensive course is designed to give an introduction to the essential aspects of this powerful integrated spreadsheet product from Microsoft. It is entirely 'hands on' and those reading will gain a good basic understanding of spreadsheet production including formatting, editing and printing. |
Assumed Knowledge
A basic understanding of PCs, use of a keyboard and mouse plus knowledge of MS Windows 95/98/NT is required, gained either by previous experience or by attendance on a "Windows 95/98/NT User Introduction" course. |
Course Audience
Intending, new or recent users of MS Excel 97 who want to get to grips with the essentials of this package as quickly as possible. This is not a conversion course from Excel 5.0 or Excel 7.0. |
|
Table of Contents
|
|
Introduction to Excel 97
|
|
|
Getting Started
|
The Excel 97 Opening Screen
|
|
Active Cell, Column and Row Headers
|
|
|
|
Getting Assistance
|
Using the Office Assistant
|
|
Other Ways of Getting Assistance
|
|
Manipulating the Help Window
|
|
Finding Out What is on the Screen
|
|
|
|
Spreadsheet Basics
|
Selecting Cells with the Mouse and Keyboard
|
|
Entering and Editing Data
|
|
Moving Data with Drag-and-Drop
|
|
Clearing Data from the Sheet
|
|
|
Entering Basic Calculations
|
Using Relative and Absolute Cell Addresses
|
|
|
|
Formatting the Worksheet
|
Resizing Columns and Rows
|
|
|
|
Structuring the Worksheet
|
Moving Entries (Cut and Paste)
|
|
Copying Cell Contents (Copy and Paste)
|
|
Inserting and Deleting Rows and Columns
|
|
Inserting and Deleting Worksheets
|
|
|
|
|
Printing
|
|
|
|
Year 2000 Best Practices
|
|
|
|
|
