Microsoft Excel Introduction – Virtual Class

This is a live, facilitator led training course delivered to you online at your computer. With our online Excel course, you still have all the benefits of interacting with our facilitators in real time, just with the convenience of being at your office or home desk. You can ask questions both during the training and afterwards with our free post course help desk. Please see the dates listed above for upcoming online Excel courses.

Course Times

• 9am to 4pm

Course Content

Spreadsheet Concepts

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

Working In The Worksheet

• Navigating around the worksheet
• Entering and editing text, numbers and dates
• Selecting cells and ranges
• Cutting, copying and pasting text and numbers
• Inserting and deleting cells, columns and rows
• Adding, deleting and copying sheets

Working With Excel Files

• Saving files
• Opening and closing files

Basic Formulas and Functions

• Creating formulae using addition, subtraction, multiplication, and division
• Using Excel functions: SUM, COUNT, COUNTA, AVERAGE, MIN, MAX
• Copying formulae and functions

Data Presentation

• Formatting cells
• Formatting text, numbers and dates
• Using the Format Painter

Working with Lists

• Understanding Lists
• Sorting and filtering list data
• Freezing part of the worksheet

Creating Basic Charts

• Creating simple charts
• Changing the chart type and moving charts

Print Options

• Printing worksheets
• Printing charts

Interested in taking an online Excel course?

If you’d like to take our online Microsoft Excel course, select Book A Course to register. If you’d like to know more, please get in touch with us by sending an email to hello@ati-mirage.com.au or give us a call on (08) 9218 9059.

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

Suggested Next Course: MS Excel Intermediate Online Course

This course allows experienced users of Microsoft Excel to extend their knowledge in this powerful spreadsheet application.

For our online Excel course, a familiarity with the computer keyboard, Window and Word Processing 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