Designed for

This two day course is designed for first-time users of Excel who need to learn how the spreadsheet works. Some familiarity with Windows and a PC is essential.

Content

• Initial spreadsheet concepts - Keyboard vs menu vs tool bar - Distinguish rows, columns, cells - Define cell ranges - Move around a worksheet - Create a new worksheet - Enter data - Delete data - Save a worksheet - Load a worksheet
• Work with a worksheet - Recognise numeric and text - Use calculations - Format cells - Copy data and expressions - Move data and expressions - Insert and delete columns and rows
• Print a worksheet - Use page setup - Set up printer commands - Select different areas to print
• Charting - Select data to chart - Chart wizard - Display a chart - Change chart display - Insert text, legends, arrows - Print a chart
• Added features - Drag and drop - Named areas - More calculations - Windows - Splitting the screen - Titles - Linking worksheets

Award

A Certificate of Attendance will be issued at the completion of the course.

Learning Outcomes
On completion of this course participants should be able to:

• Explain the capabilities of Excel
• Describe Worksheet commands - what they do and how to use them
• Know how to use simple calculations, formatting and printing

Duration of Course

Two days 9.00am - 4.30pm

Course Fee (GST Free)

Fee Member AUD $650
Fee Non Member AUD $680

Venue

AFEI
Level 2, 97-99 Bathurst St
Sydney   NSW   2000

Other Details

Fee includes morning and afternoon tea, light lunch and course materials.

PLEASE INDICATE ON YOUR REGISTRATION WHICH VERSION OF EXCEL YOU USE.

Course ID Date(s)