Module 1
Module 2
Module 3
Module 4
Module 5
Module 6
Module 7

Excel 2000 Introduction:

Course Code: ECDLLSL04

Duration: 1day


Course aimed at:

This course is designed for new users of Excel 2000 who have some PC and windows experience.


Previous knowledge required:

Knowledge of Windows environment is assumed.



Course Contents:

Using the Office Assistant


The Excel Window

  • Understanding the Spreadsheet Concept
  • Exploring the Screen Layout
  • Working With Toolbars and Menus


Creating a Worksheet

  • Entering and Editing Data
  • Selecting Ranges and Entering a Range of Data
  • Erasing Data
  • Using the Undo Facility and Search and Replace
  • Using AutoComplete



  • Creating and Editing Formulae
  • Changing the Order if a Calculation
  • Understanding Error Messages


File Procedures

  • Saving, Closing and Opening a Workbook
  • Starting a New Workbook
  • Saving a Workbook in Another File Format
  • Saving a Workbook for the Internet


Moving, Copying and Sorting Data


Functions and absolute References

  • Using Statistical Functions
  • Using AutoSum and AutoCalculate
  • Absolute Cell References

Spreadsheet Presentation

  • Inserting and Deleting Rows and Columns
  • Modifying Row Heights and Column Widths
  • Aligning and Rotating Data
  • Changing the Font Size and Type
  • Altering the Number Display
  • Adding Borders and Shading
  • Spell Checking



  • Viewing a Spreadsheet
  • Changing the Page Setup and Inserting Page Breaks
  • Setting Print Areas


Working With Multiple Sheets and Files

  • Creating Multiple Sheets and Linking Them
  • Copying and Pasting Between Worksheets
  • Working With Multiple Workbooks


Producing Charts

  • Creating Embedded and Separate Charts
  • Changing the Chart Type and Adding Text
  • Adding a Legend and Gridlines
  • Changing the Scale
  • Modifying the colours in the Chart


Working With Images and Other Objects

  • Inserting Clipart Pictures
  • Importing and Manipulating Images and Other Objects