 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 98 for the Macintosh Introduction
Course Aims
MS Excel 98 is the latest spreadsheet from Microsoft designed specifically for the Macintosh environment. This course is designed to give you an understanding of some of the major features and functions within Excel and the advantages of using a powerfully integrated spreadsheet running under Macintosh. The course is entirely 'hands on' and those reading will gain a good basic understanding of how to create and manage spreadsheets, graphics and databases. |
Assumed Knowledge
A working knowledge of a keyboard and mouse plus Apple MAC System 7.5 or 8.0 is assumed, gained from the workplace or by prior attendance on an " Apple MAC System 7.5 or 8.0 User Introduction " course. |
Course Audience
Intending, new or recent users of MS Excel 98 for Macintosh who want to gain a good understanding of the software in a short space of time. |
|
Table of Contents
|
|
Introduction to Excel 98
|
|
|
|
Getting Started
|
|
|
Getting Assistance
|
Using the Office Assistant
|
|
Looking up Information in the Index & Contents
|
|
Finding out What is on the Screen
|
|
|
|
Spreadsheet Basics
|
Selecting Cells with the Mouse & the Keyboard
|
|
Moving Data with Drag & Drop
|
|
Clearing Data from the Sheet
|
|
Saving & Closing a Workbook
|
|
|
|
Entering Basic Calculations
|
Using Relative & Absolute Cell Addresses
|
|
Circular References Formatting the Worksheet
|
|
|
Structuring the Worksheet
|
Moving Entries (Cut & Paste)
|
|
Copying Cell Contents (Copy & Paste)
|
|
Inserting & Deleting Rows & Columns
|
|
Inserting & Deleting Worksheets
|
|
|
|
|
Printing
|
|
|
|
Additional Formatting
|
|
|
Advanced Formula Concepts
|
Preventing Rounding Errors
|
|
|
|
Working with Multiple Sheets
|
Opening a Second Workbook
|
|
Working with Large Sheets
|
|
|
|
|
Additional Features
|
|
|
Working with Data Lists
|
Setting up Lists and Sorting Lists
|
|
Filtering and Using Lists
|
|
|
|
Charts
|
Creating & Printing Charts
|
|
Changing Chart Elements and Chart Data
|
|
|
|
|
|
