Excel 2000 Introduction

This course is designed to let users get to grips with the main features of Excel and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets. This Excel 2000 course also instructs users in year 2000 best practice.

Target audience

New or intending users of Excel 2000 who want to gain a good understanding of how to use the software in a short space of time. A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required, gained either by previous experience or by attendance on a "PC Fundamentals" course.

Course content

Microsoft Excel 2000 Introduction What is a spreadsheet?

Getting started with Excel 2000 Starting Excel 2000 . Excel 2000 opening screen . The Title Bar . The Menu Bar . Toolbars . Scroll bars . Active cell, column and row headers . Sheet tabs . The Status Bar . Menus and submenus . SpeedKeys . Dialogue boxes . Exiting Excel

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 Creating a new workbook . Moving around the sheet . Scrolling . The mouse pointer . Selecting cells with the mouse . Selecting cells with the keyboard . Spreadsheet data types . Year 2000 best practice . Entering and editing data . Editing long entries . Undoing incorrect edits . AutoFill . Custom lists . Saving, closing, opening and deleting a workbook

Working with worksheets and cells Using Go To . Moving data with Drag-and-Drop . Cut, Copy and Paste . Moving entries (Cut and Paste) . Copying cell contents (Copy and Paste) . Using the Office Clipboard . Using find and replace

Entering basic calculations AutoSum . Entering a calculation

Statistical functions Using relative and absolute cell addresses . Circular references

Formatting cells The formatting Toolbar . Enhancements . Alignment . Formatting numbers . Resizing columns and rows . Clearing a worksheet

Structuring the worksheet Inserting and deleting rows and columns . Inserting and deleting worksheets

Printing worksheets Print Preview . Changing the page set-up . Printing

About Courseware Company:: Instructor-led training courseware :: Self-study solutions :: Buy online today