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

Relevant Certifications

  • The ECDL syllabus is designed to cover the key concepts of computing, its practical applications and their use in the workplace and society. It is broken down into seven modules, each of which ...

or call:408-759-5074

Course PDF

Print

Sections