MS Excel Introduction

Course Times

• 9am to 4pm

Course Content

Spreadsheet Concepts

• Introduction to the Excel environment & the components available to the user

Working In The Worksheet

• Moving around the worksheet
• Entering text, numbers and simple formulae
• Cell referencing in formulae
• Cell selection techniques
• Cut, copy & paste data
• Inserting & deleting cells, columns, rows, worksheets
• Change the display & freeze part of the worksheet

Working With Excel Files

• Saving files
• Opening and closing files

Excel Concepts

• Working with ranges
• Copying and moving text, numbers and formulas
• Editing data
• Creating formulae
• Introduction to Excel functions

Data Presentation

• Cell formatting options
• Number formatting
• Cell alignment options
• Creating charts
• Changing the chart type & moving charts

Print Options

• Print options
• Add comments to a worksheet

On completion of this course, participants will be able to create and print a spreadsheet using basic editing and formatting.

A familiarity with the computer keyboard and Windows is desirable.

“The trainer delivered subject in a friendly manner with lots of support and practical and user friendly examples” Pauline from Dept of Communities

“Learning more about Formulas & Functions & how they can help with data compilation at work. Jo was an excellent trainer. She made everything so easy to understand and the way she presented was easy to follow” Elizabeth from Dental Health Services

“Fantastic facilities and resources provided training. The instructors are excellent, experienced and helpful” Chang from Ord Valley Aboriginal Health Service

“I found the course well suited to my needs, within the first 40 minutes I felt as though the course was already worth it. I am really happy with what I have learnt today and look forward to putting it in to practice.” Trevor from Rio Tinto

“I would recommend to my colleagues who lack confidence in excel to do this course. I was very happy with the overall experience and have learnt a great deal.” Nikki from WA Police

“The whole course covered most of my expectations. Awesome experience!” Pinara from Rio Tinto

“Excellent training, great pace and face to face training really helped. Will definitely do the Intermediate course.” Annette from the Dept of Fire & Emergency Services

“I knew a limited amount about excel and have learnt so much today and really enjoyed the session” Louise from the City of Stirling

“Developed my basic skills in a number of areas. I got what I wanted out of the course and I’m more confident to work in Excel to build my skills further” Emily from Kimberley Aboriginal Medical Services