Microsoft Excel 2003 Introduction

Course Overview

What is Excel?

·          Understand the functions of spreadsheet application

·          Recognise the different elements of the Excel screen

Creating a Workbook

·          Create a new workbook

·          Move around the worksheet using the mouse and keyboard

·          Select cells using the mouse and the keyboard

·          Use zoom to view a worksheet at different magnification

·          Use Undo and Redo

Entering and Editing Data

·          Enter text, values, and dates in cells

·          Edit cell contents

·          Print a single copy of a worksheet

Creating a Formula

·          Understand what a formula is and how to create simple calculations

·          Use AutoSum

·          Enter a formula by typing or by using the Formula bar

·          Enter a range within a formula using the mouse

·          Use relative and absolute cell references

Moving and Copying Data

·          Use the AutoFill tool

·          Create a custom list

·          Use Drag-and-Drop to move or copy cell contents

·          Move, copy, and paste data using the Windows Clipboard

Editing a Formula

·          Create a formula using functions

·          Revise a formula

·          Use Insert Function

·          Use basic arithmetic functions (SUM, AVERAGE, COUNT, MIN, MAX)

·          Recognise and resolve common error messages

·          Interpret spreadsheet data

Formatting Cell Values

·          Apply value formats (currency, percent, date, comma)

·          Adjust the decimal place

·          Change the currency symbol

·          Apply other formats (accounting, time, text, general)

Formatting Cell Contents

·          Apply font styles (typeface, size, colour, enhancements)

·          Modify the alignment and orientation of cell contents

·          Merge and unmerge cells (to centre headings across columns)

·          Indent text in a cell

·          Use the Format Painter to copy cell formats

·          Clear cell contents or formats

Structuring a Worksheet

·          Modify the size of columns and rows

·          Insert and delete rows and columns

·          Insert and delete selected cells

Page Layout

·          Change paper size and orientation

·          Set page margins and alignment

·          Scale print output to fit a defined number of pages

·          Print column and row titles and set other options

·          View a worksheet in Print Preview

·          Change margin and column widths in Print Preview

·          Insert and remove a page break

·          Set up headers and footers

·          Add fields in headers and footers (page number, date/time, file information)

Printing Worksheets and Workbooks

·          Print a worksheet

·          Print a workbook (all sheets in book)

·          Display formulas in worksheet cells

·          Print a range of cells

·          Set, print, and clear a print area

·          Print a group of worksheets

·          Print to a file

Creating a Chart

·          Use the Chart Wizard to create different chart types

·          Reposition, resize, and delete a chart

·          Change the chart type

·          Preview and print a chart

·          Move and copy a chart

If booking for more than one delegate, please contact us on 01189 778560 for discounted prices.