alphabyte - Excel 2003 Introduction Course Outline

alphabyte - IT and Training Consultants

Course Outline

Course:

Excel 2003 Introduction

Duration:

1 day

Objectives:

This course is designed to introduce users to the use of Excel as a spreadsheet. By the end of this course delegates should be able to compile simple spreadsheets and charts with confidence.

Pre-Requisites:

A familiarity with Microsoft Windows is required and a working knowledge of drawing techniques is helpful although not essential.

Topics:

Excel Basics

Creating a new excel workbook

Entering labels, values & formula

Saving a workbook

Autofill

How to use Autofill

Using Autofill to copy sequences

Using Autofill to replicate

Using Functions

Entering functions

Using AutoSum

Using AVERAGE, MIN, MAX and COUNT

Formatting Worksheets

Formatting text

Formatting rows and columns

Number formatting

Modifying a worksheet

Moving and copying data and formulas

Office Clipboard

Dragging and dropping data

Inserting and deleting ranges

Printing

Preparing to print

Page setup options

Page Break Preview

Charts

Creating a chart

Printing charts

Formatting options

Creating combination charts

Adding graphic elements

Download Printer-Friendly copy (Word Format)