• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   User ECDL Training Courses

ECDL Module 4 Spreadsheets Using Excel 2000

View course dates

Course Duration: 2 days

Course Code: ECDLMI09

Course Description:

This course is designed for new users of Excel 2000, who have some PC and Windows experience and wish to prepare for the ECDL Module 4 Spreadsheets test.

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:

European Computer Driving Licence® (ECDL)

This course includes the following modules:

Course contents include:

• The Excel Window
• Understanding the Spreadsheet Concept
• Exploring the Screen Layout
• Working with Toolbars and Menus
• Moving Around the Worksheet and Workbook
• Using the Office Assistant and Getting Help
• 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
• Working with Formulae
• Creating and Editing Formulae
• Changing the Order of a Calculation
• Understanding Error Messages
• Understanding File Procedures
• Saving, Closing and Opening a Workbook
• Starting a New Workbook
• Saving a Workbook in Another File Format
• Saving a Workbook as a Web page
• Moving, Copying and Sorting Data
• Functions and Absolute Referencing
• Using Statistical Functions
• Using AutoSum and AutoCalculate
• Creating Absolute Cell References
• Enhancing a Spreadsheet
• 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
• Extend Formats and Formulae in a List
• Spell Checking
• Printing
• Viewing a Spreadsheet
• Changing the Page Setup and Inserting Page Breaks
• Setting Print Areas
• Manipulating 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

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course