Introduction
Presentation
Courses

Introduction
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

 

Formulae

  • 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

 

Printing

  • 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