1 Microsoft Excel Introduction 2003, XP or 2000 1 Day Training Course

£ 175.00 

Course Outline

Excel Overview

Screen Overview

Sheet Tabs

Formula Bar

Zoom View


Spreadsheet Basics

Navigation

Selecting

Data Entry

New, Open, Close & Save Workbooks

New, Copy, Move, Rename & Delete Sheets

Inserting

Deleting

Clearing

Formatting

Cut, Copy, Paste, Drag & Drop

AutoFill

AutoCalculate


Calculations and Formulae

Simple Calculations

AutoSum

Sum, Average, Max, Min

+ - * /

Overview of Absolute vs. Relative

Data Lists

AutoFilter

Criteria

Sort

Forms


Printing

Print Preview

Margins

Page Break View

Print Selection


Charts

Creating Charts

Chart Data

Colour Options

Data Changes

Chart Types


Additional Features

AutoCorrect

Window Panes

Freezing Panes

Splitting Windows

Hiding Columns

Find & Replace