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
how to slick back natural 4c hair wholesale virgin hair vendors in atlanta ga hair extensions best synthetic braiding hair bellatique virgin brazilian hair cheap hair extensions micro bead hair extensions itchy eurasian curly hair hair wigs nbhairboutique website wedding updo wigs lace front wigs

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