INTRODUCTION TO EXCEL

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

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)