This Microsoft excel course is a self study workbook. It will be available for immediate download when payment has been received.
The user can study the areas described below in their own time.
It will be necessary to have access to a computer with excel 2000 application installed (this is not supplied with this course).

Overview and objectives Excel 2000 is a spreadsheet package from Microsoft, designed for either the home or office environment. This course is designed to let users get to grips with the main features of Excel and realize the advantages of using a powerful computer-based spreadsheet. The course is entirely 'hands on', so those using this course will get practice in creating and modifying actual spreadsheets. Who is the course intended for ? 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. 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 • Selecting cells • 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 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