Excel 97 Introduction (ECDL Module 4)

2 Day Course
Code ECDLMI04

This course has been retired. Please view currently available User ECDL Training Courses.

Modules

Topics Covered (52 topics)

  • Using the Office Assistant
  • The Excel Window
  • Understanding the Spreadsheet Concept
  • Exploring the Screen Layout
  • Working with Toolbars and Menus
  • Moving Around the Worksheet and Workbook
  • 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 of 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

Prerequisites

A knowledge of the Windows 95 environment is assumed. Delegates with no knowledge of Windows 95 should attend Windows 95 Introductory Level prior to this course

Course PDF

Print

Sections