Introduction to Excel

Anyone wishing to work/is working in a commercial environment requiring Excel skills

The course provides an excellent foundation in the product giving you basic skills, formulae, formatting, printing and charting

Introduction
What is a Spreadsheet
Starting Excel
Parts of the screen
The office assistant
Quitting Excel

Basic Skills
Cursor movement
Using Go To
Highlighting areas of the worksheet
Entering data
Editing a cell entry
Deleting a cell or range of cells
Undoing the last command
Redoing the last command
Drag and drop
Filling a range
Insert and delete
AutoComplete
Inserting deleting rows and columns
Smart Tags
Opening, closing and saving
Creating a new file
Viewing a list of open files
Version compatibility
Email a spreadsheet
File search

Entering Formulae
Entering simple calculations
Circular references
Using AutoSum
Using Paste Function
Statistical functions
Relative and absolute cell referencing
Formula auditing mode
Printing cell formulae
Using AutoCalculate
Error correction
Screen tips for function arguments

Formatting
Using the formatting toolbar
Adjusting column widths and row heights
Changing cell alignment
Formatting numbers
Changing fonts and attributes
Borders and patterns
Using the shortcut menu
Copying styles
Cut, copy and paste
Copying data into Word

Printing
Print preview
Changing the page setup
Defining the print area
Printing
Inserting a page break
Page break preview

Charts and Drawing
Creating a chart
Changing the chart type
Using the drawing tools

The ability to understand spreadsheets, create your own format and chart to professional standards. A certificate awarded for attendance.