Course Objectives

On completion of this course, delegates will be able to create, modify and format Spreadsheets using a number of features, as well as creating basic charts. A number of commonly used timesaving features are also introduced giving the necessary skills to use the product effectively.

 

What skills will the delegate gain?

This course will enable delegates to:

Navigate around Microsoft Excel.
Enter and Edit data.
Print spreadsheets.
Use Copy, Cut and Paste in Excel.
Create basic formula using functions.
Create charts and graphs.
Understand the Web functionality of Excel.

Who will the course benefit?

Anyone with a need to acquire the basic skills to use Excel 2003 for the creation of spreadsheets and data manipulation. It would also benefit those working towards the ECDL certification.

 

Prerequisites

This course requires that you have a good working knowledge of Microsoft Windows. 

 

Examinations

This course, along with Intermediate and Advanced, covers the curriculum for the ECDL spreadsheet module and exam.

 

Additional Notes

Training is available on previous versions.

 

Course Content

Excel Basics:
Spreadsheet terminology.
Exploring the Excel window.
Opening and navigating a workbook.
Closing a workbook.

 

Entering and Editing Data:
Creating a new Excel workbook.
Entering and editing labels and values.
Entering and editing formulas.
Saving and updating a workbook.

 

Printing:
Preparing to print.
Page set up options.

 

Using Functions:
Entering Functions.
Using Autosum.
Using AVERAGE, MIN, MAX, and COUNT.

 

Formatting Worksheets:
Formatting text.
Formatting rows and columns.
Number formatting.
Other formatting features.

 

Creating Charts:
Creating a chart.
Printing charts.

 

Web Features:
Saving a worksheet as a web page.
Adding hyperlinks.
Sending a workbook via email.