+

 
 

 

 

 

 

home

contact

software

courses

calendar

links

 

 

 
Microsoft Excel Introduction
 
 

Microsoft Excel enables you to turn data into information with powerful tools to analyse, communicate and share results.  Numbers will never be the same again.
At the end of this one day course delegates will be able to…
use Microsoft Excel to a create spreadsheets with formulas and functions to print and share.

 
Introduction to Excel
The Excel Screen
Toolbars, Menus and Scrollbars
Worksheets, Columns, Rows & Cells
Saving, Opening and Closing worksheets

Entering Data
Entering Data using the formula bar
Editing Data in cells
Selecting Cells
Clearing and Deleting Cells
Moving around the worksheet

Cells, Rows and Columns
Column width & Row Height
Selecting Cells, Rows and Columns
Inserting and Deleting

Worksheets
Inserting & Renaming worksheets
Moving and copying worksheets
Deleting worksheets

Formulae and Functions
Entering and editing formula
AutoSum and Basic functions

Formatting Cells
Using the toolbar
Using the keyboard
Text Formats
Cell Formats
Currency, Time and Decimal formats
Text Alignment
Borders and Shading
Using the Format Painter

Moving and Copying Data
Coping cell contents
Copying row and column contents
Moving cell data

Auto functions
The AutoFill function
Auto lists
Find and Replace

Printing and Previewing

Page set up and print areas
Page breaks

Introduction to Charts
Using the chart wizard
Formatting charts

 
 
 

 

Next Course

12 & 13 Oct 06

£200.00 + VAT pp

 

 

 
 
 
 

 

 

One day course.

10.00am to 4.00pm

Refreshments and luncheon included.

 
 
 
© LEARN IT AT WORK MMVI | 028 4461 7701 | info@learnitatwork.com | TERMS