Objectives
Delegates will gain the confidence, knowledge and practical experience to use Microsoft Excel to create worksheets and produce printed reports.

Requirements
This course has been designed for new users of Microsoft Excel 2003. Attendance on the Microsoft Windows Introduction or experience of another Windows application would be beneficial.

Contents
Introduction to Excel
Workbook screen
Columns, rows and cells
Navigating the Worksheet
Buttons, Menu bar, Intelligent menus, Shortcut menus, Toolbars and formula bar
Task panes
Getting help

Entering Data and Simple Calculations
Entering text
AutoComplete and AutoCorrect
Smart Tags
Fill handle, Autofill and Custom Lists
Entering numbers and fractions
Entering formulae
AutoSum and AutoCalculate
Using the Count, Average, Max and min AutoFunctions
Using the Function Wizard
Correct Formulae Errors using Smart Tags
Entering dates and times
Calculating across sheets
Relative and Absolute cell references

Editing Worksheets
Selecting cells and ranges of cells
Multiple Undo
Repeat
Editing cell contents
Moving and copying data and sheets
Cut, Copy and Paste
Drag and Drop
Clearing and deleting data
Inserting and Deleting columns, rows and cells
Inserting, Deleting, Renaming and changing the Tab Colour of sheets

Formatting Worksheets
Format toolbar
Formatting numbers
Changing alignment and justifying text
Centering headings across ranges
Merging cells
Changing text direction
Changing font and font size
Adding borders and patterns
AutoFormat
Changing column width and row height
Hiding and unhiding columns
Freezing and unfreezing titles
Format Painter

Printing
Quick print and controlling printing
Page Break Preview
Page Setup
Changing margins, Headers and footers
Inserting and removing page breaks
Print Preview
Printing formulae

File Management
Opening new and existing workbooks
Saving and closing workbooks

Creating Basic Charts
Creating, editing and printing charts

Price Band A

Microsoft Excel 2003 Intermediate
Microsoft Excel 2003 Advanced
Microsoft Excel 2003 Database

Home

© Alpha Training | Telephone 020 8658 6994 | Email admin@alphatraining.com