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:

bullet

Excel Basics
bullet

Creating a new excel workbook

bullet

Entering labels, values & formula

bullet

Saving a workbook

bullet

Autofill
bullet

How to use Autofill

bullet

Using Autofill to copy sequences

bullet

Using Autofill to replicate

bullet

Using Functions
bullet

Entering functions

bullet

Using AutoSum

bullet

Using AVERAGE, MIN, MAX and COUNT

bullet

Formatting Worksheets
bullet

Formatting text

bullet

Formatting rows and columns

bullet

Number formatting

bullet

Modifying a worksheet
bullet

Moving and copying data and formulas

bullet

Office Clipboard

bullet

Dragging and dropping data

bullet

Inserting and deleting ranges

bullet

Printing
bullet

Preparing to print

bullet

Page setup options

bullet

Page Break Preview

bullet

Charts
bullet

Creating a chart

bullet

Printing charts

bullet

Formatting options

bullet

Creating combination charts

bullet

Adding graphic elements

 

Download Printer-Friendly copy (Word Format)

 
 
Proprietor: Kathy Jarvis
alphabyte, 19 Leigh Drive, Wickham Bishops, Essex CM8 3JS
Tel/Fax: 01621 892336  Mobile: 07710 534128  email: kathy@alphabyte.co.uk