An Introduction to Microsoft Excel
Duration Two Weekdays 10am -5.00pm £120
Objectives
 To give trainees an understanding of Microsoft Excel for Windows
Suitable for:
 All those who would like to use Excel for Windows
Pre-Requisite
 PC appreciation and basic keyboard skills would be advantageous
Books on
Microsoft
Excel
Course Outline
Introduction
 What is a spreadsheet
Getting Started
Starting Excel for windows
Excel 7.0 Opening Screen
The Title, Menu & Tool Bars
The Formula Bar & Name Box: Scrool Bars
Active Cells, Column & Row Headers
Sheet Tabs; Status Bar; Menu & Sub Menu
Speedkeys: Dialogue Boxes
Dialogue Box Elements; Exiting Excel
Getting Assistance
Using the office assistance
Looking up information in the Index & Contents
Manipulating the help windows
Finding out what is on the screen
Spreadsheet Basics
Creating a new workbook
Moving around the sheet
Scrolling: The Mouse Pointer
Selecting Cells with the Mouse & the keyboard
Using Go To; Spreadsheet data Types
Entering & Editing Data: Text Editing
Undoing Incorrect Edits
AutoFill:Custom Lists
Moving Data form the Sheet
Clearing Data form the Sheet
Saving & Closing a Workbook
Opening a Workbook: Deleting a Workbook
Entering Basic Calculations
AutoSum: Entering a Calculation
Statistical Functions
Using Relative & Absolute Cell Addresses
Circular References
Formatting the Worksheet & Toolbar
Enhancement, Alignment
Formatting Numbers
Resizing Columns & Rows
Structuring the Worksheet
Cut, Copy & Paste
Moving Entries (Cut & Paste)
Copying Cell Contents (Copy & Paste)
Inserting & Deleting Rows & Columns
Insertinmg & Deleting Worksheets
Printing
Printing Preview
Changing the Page Setup
Printing
Additional Formatting
Preventing Rounding Errors
Conditional Formulae
Worksheet Linking
Working with multiple sheets
Opening a second workbook
Working with large sheets
Additional Features
Protecting the worksheet
Using Zoom: AutoCirrect; Spell Check
Working with Data Lists
Setting up Lists
Charts
Creating & Printing Charts
Course will be based on The Courseware Company's superb training Material
To book onto this Course or for further information please contact
BHI Net Centre
701 High Road
Seven Kings, Ilford
Essex IG3 8RH, UK

Phone : +44 (0)20 8590 2500
Fax: +44 (0)20 8590 2589
E-Mail BHIemail: training@bhi-netcentre.co.uk
If this is the only frame you can see Click Here to see our full Training Portfolio