Total Time: 9 hour(s)

Summary: 
This course shows users how to work with a spreadsheet application to insert and manipulate data. It also shows users how to create formulas and functions, format and print a spreadsheet, import objects, and create and adjust charts. This course describes how to meet European Computer Driving Licence objectives using Microsoft Excel on a personal computer that uses a Windows operating system. The ECDL test can be taken with any spreadsheet application, and although the course demonstrates a specific application, the tasks it teaches can be applied to other applications as well.

Ojectives: 
After completing this course, students will be able to:
Create and save a spreadsheet
Open, revise, and close a spreadsheet
Use application help
Change display settings
Insert, select, copy, move, and delete data
Undo and redo actions
Search and replace data
Sort data
Create and copy a formula
Use functions such as SUM, AVERAGE and IF
Format data
Preview and prepare a spreadsheet for printing
Import an object and text file into a spreadsheet
Create, adjust, move, and delete a chart

Topics: 
Getting Started
Using Help and Display Settings
Adding and Moving Data
Manipulating Data
Using Formulas
Using Functions
Formatting a Spreadsheet
Printing a Spreadsheet
Using Advanced Features

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.