 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2000 Introduction
Course Aims
MS Excel 2000 is the popular spreadsheet from Microsoft, designed for the networked office environment. This course is designed to let users get to grips with the main features of Excel and realise the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those reading will get practice in creating and modifying actual spreadsheets. This Excel 2000 course also instructs users in year 2000 best practice. |
Assumed Knowledge
Working knowledge of using PCs, a keyboard and mouse plus Windows 95/98/NT is assumed, gained from the workplace or by prior attendance on a "Windows 95/98/NT User Introduction" course. |
Course Audience
New or intending users of MS Excel 2000 who want to gain a good understanding of how to use the software in a short space of time. |
|
Table of Contents
|
|
Microsoft Excel 2000 Introduction
|
|
|
Getting started with Excel 2000
|
Excel 2000 opening screen
|
|
Active cell, column and row headers
|
|
|
|
Getting assistance with Excel 2000
|
Using the Office Assistant
|
|
Getting help without the Office Assistant
|
|
Manipulating the help window
|
|
Finding out what is on the screen
|
|
|
|
Starting a workbook
|
Selecting cells with the mouse
|
|
Selecting cells with the keyboard
|
|
Entering and editing data
|
|
Saving, closing, opening and deleting a workbook
|
|
|
Working with worksheets and cells
|
Moving data with Drag-and-Drop
|
|
Moving entries (Cut and Paste)
|
|
Copying cell contents (Copy and Paste)
|
|
Using the Office Clipboard
|
|
|
|
|
Entering basic calculations
|
|
|
Statistical functions
|
Using relative and absolute cell addresses
|
|
|
|
Formatting cells
|
Resizing columns and rows
|
|
|
|
Structuring the worksheet
|
Inserting and deleting rows and columns
|
|
Inserting and deleting worksheets
|
|
|
|
|
Printing worksheets
|
|
|
|
|
