Microsoft Excel Introductory Course

Classroom or Online Learning

Understanding Excel from the basics

Learn formulas, formatting and present your data ready for clients and customers with our hands-on classroom course or online Excel Introductory course.

Designed for beginners, the course gives new spreadsheet users a thorough grounding in creating and working with spreadsheets.

Download Microsoft Course Guide

Enrol Now

Study Options

Online Excel Introductory Course

Study at your own pace

Complete your studies and assessments at a time that fits in with your lifestyle or other work commitments.

Electronic manual included, plus 12 months unlimited access to course material.

6 CPD hours

Commence any time

$79

Enrol Now

Classroom Excel Introductory Course

Comprehensive instructor-led training

Attend a hands-on classroom workshop delivered by an expert trainer. Ask questions, receive handy tips and see real examples.

Computers and all training material provided, refreshments and lunch included.

12 months unlimited access to electronic course material, option to purchase hard copy manual.

6 CPD hours

Perth CBD location

$339

Enrol Now

Download Microsoft Course Guide

Online Learning - 49 Part Course

Microsoft Excel 2016 Introductory Online Training is a convenient, effective and affordable way to learn. You can complete the Microsoft Excel Introductory Online Training at your own pace and your own leisure. Whether you’re a beginner, an experienced user, or somewhere in between, you’ll find valuable knowledge that can be accessed again and again at a time and pace that suits you.

Microsoft Excel Introductory Online Training utilises learning materials that are packed full of high quality content, step-by-step instructions with visuals and plenty of practice exercises offering exceptional value to the participant.

Learning Outcomes Chapters 1 to 13 - Click to View

Chapter 1-1 Getting Started Page
Chapter 2-1 Creating a New Workbook Page
Chapter 3-1 Working with workbooks Page
Chapter 4-1 Editing a Workbook Page
Chapter 5-1 Selecting Ranges Page
Chapter 6-1 Copying Data Page
Chapter 7-1 Filling Data Page
Chapter 8-1 Moving Data Page
Chapter 9-1 Special Pasting Page
Chapter 10-1 Formulas and Functions Page
Chapter 10-2 Formulas and Functions
Chapter 11-1 Formula Referencing Page
Chapter 11-2 & 3 Relative Formulas Page
Chapter 11-4 Creating Absolute References Page
Chapter 12-1 Font Formatting Page
Chapter 12-2 Changing Font Size Page
Chapter 12-3 Making Cells Bold Page
Chapter 12-4 Italicising Text Page
Chapter 12-5 Underlining Text Page
Chapter 12-7 Using The Format Painter Page
Chapter 12-8 Applying Strikethrough Page
Chapter 12-9 Subscripting Text Page
Chapter 12-10 Superscripting Text Page
Chapter 13-1 Horizontal Cell Alignment Page
Chapter 13-2 Vertical Cell Alignment Page
Chapter 13-3 Indenting Cells Page
Chapter 13-4 Rotating Text Page
Chapter 13-5 Wrapping And Merging Text Page
Chapter 13-6 Unmerging Cells Page

Learning Outcomes Chapters 14 to 17 - Click to View

Chapter 14-1 Column Widths Page
Chapter 14-2 Row Height Page
Chapter 14-3 Hiding Rows And Columns Page
Chapter 15-1 Applying General Formatting Page
Chapter 15-2 Formatting Pecentages Page
Chapter 15-3 Formatting As Fractions Page
Chapter 15-4 Formatting As Dates Page
Chapter 15-5 Using The Thousands Separator Page
Chapter 15-6 Increasing And Decreasing Decimals Page
Chapter 16-1 Printing Page
Chapter 16-2 Selecting A Printer Page
Chapter 16-3 Printing An Entire Workbook Page
Chapter 17-1 Using A Recommended Chart Page
Chapter 17-2 Creating A New Chart From Scratch Page
Chapter 17-3 Repositioning A Chart Page
Chapter 17-4 Printing An Embedded Chart Page
Chapter 17-5 Creating A Chart Sheet Page
Chapter 17-8 Printing A Chart Sheet Page
Chapter 17-9 Embedding A Chart Into A Worksheet Page
Chapter 17-10 Deleting A Chart Page

Hands-on Classroom - 1 day course

The Microsoft Excel Introductory course in Perth is designed to give the new spreadsheet user the skills to start using Excel in the workplace. From using simple formulas such as the SUM function to formatting data and the basics of spreadsheets and using Microsoft Excel. The course covers topics such as creating a workbook, functions, filtering data, charting and much more.

This course is recommended for any user new to Excel and wanting to get off to the right start.

Duration – 1 day | version: 2010, 2013 & 2016

Classroom Training

Hands on classroom training in our modern facilities in Perth CBD

Learning Outcomes - Click to view

At the completion of this Microsoft Excel training course in Perth, participants will be able to:

navigate your way around Microsoft Excel 2016 & 2013
create and work with a new workbook
open and navigate within workbooks and worksheets
make changes to data in a workbook
understand and work with ranges in a worksheet
copy and paste data in Excel
use the fill operations available to fill a data series
move the contents of cells and ranges within and between workbooks
understand, create and work with formulas and functions
understand and use formula cell referencing
use font formatting techniques
align the contents of cells in a number of ways
understand and use the number formatting features in Excel
format rows and columns in a worksheet
work with elements that make up the structure of a worksheet
sort data in a list in a worksheet
filter data in a table
print your workbook data
create effective charts in Microsoft Excel
obtain help for Excel whenever you need it
understand points to consider to avoid problems in your worksheets

The Microsoft Excel Introductory training course in Perth utilises learning materials that are packed full of high quality content, step-by-step instructions with visuals and plenty of practice exercises offering exceptional value to the participan

Course Contents - Click to view

Getting to Know Excel 2016

Creating a New Workbook

Working With Workbooks

Editing in a Workbook

Selecting Ranges

Copying Data

Filling Data

Formulas and Functions

Absolute Versus Relative Referencing

Font Formatting

Cell Alignment

Number Formatting

Row and Column Formatting

Working With a Worksheet

Sorting Data

Filtering Data

Printing

Creating Charts

Getting Help

PDF Course Outline

Training Manual & Comprehensive Resources Included for MS Excel Course

Each class attendee to our Microsoft Excel Course is given the following;

Microsoft Excel Introductory 2016 Manual (online electronic version)
Handy Tips guide
Handy Tips for Excel 2016 Introductory (Summarising key tips and trick for using Microsoft Excel 2016)
“Quick Reference” Guide for Excel 2016
Excel 2016 Sample Chapter Files from the course
Excel 2016 Exercise Files
Excel 2016 Exercise File Solutions
Multiple Choice Test for each chapter

Customised Group Training

Customised Group Training for Microsoft Excel 2010, 2013 or 2016

Group Training - Click to view

Pre Course Questionnaire (Suitable for group training sessions if required)
Training Needs Analysis for Microsoft Excel Course
Tests available for download (Suitable for group training sessions if required)
Onsite with up to 12 laptops and projector
Use our computer training rooms venue in Perth CBD at no additional cost
Class sizes 2 to 24 attendees
Includes all resources electronic manual for each attendee or hard copy additional

Please email us for a comprehensive details and proposal on how we can make your next corporate training event a success info@appliededucation.edu.au

Course Duration

Location: Level 1, 524 Hay St. Perth WA 6000

Duration: 9am-4pm

Hands On Classroom Workshops - Modern Computers Supplied, pens, mints, refreshments & lunch

View Dates & Enrol

See what our previous students have to say about us.

I have recently completed three courses varying in subjects through Applied Education. The course content was well covered and the assessment was clearly presented and directly related to the subject content. Thank you to the team at Applied Education for their assistance and prompt response to queries and requests. Having completed undergraduate and postgraduate degrees through other education providers in the past, I would most definitely recommend Applied Education for an organised, well presented and exceptional learning experience.read more

Jackie Doorly

03:48 13 Mar 17

It's a very good training organisation and it's professional too. Admin staffs and assessor respond your query quickly. They also offer additional help even though it's something out of the scope. The course materials are clear and easy to understand, and it's very practical too.read more

cuiming xu

04:16 10 Feb 17

I have recently completed two papers in Commercial Laws, it was fantastic experience. Highly relevant content in the course which enhance my knowledge to great extent. I highly recommend Applied Education as flexible study program and most comprehensive course content I had ever experience in my previous study courses.read more

Baljit Khare

04:52 10 Jan 17

I commenced and completed a course in Property Law recently with Applied Education, and the overall experience has been fantastic. Flexible study arrangements, easy to digest yet highly relevant content, and a great support network. Would certainly recommend to anyone who's already in the industry to further hone their knowledge as well as anyone else who might be interested in specific aspects of the financial and legal profession.read more

Hilary Heah

07:38 28 Nov 16

Recently completed my CERT IV dual qualification in Bookkeeping and Accounts online. Support staff were very prompt in their replies, and made my learning experience a very pleasant one. Will definitely recommend Applied Education to anyone.read more

Ivan Teo

04:06 27 Feb 17

I needed to complete two subjects in order to qualify for the tax agent licence. Applied Education offered the exact subjects I needed and they were at a very affordable price. I was able to study from home and if required, to communicate with their team with ease by e-mail. I feel that the assignments and exams prepared me adequately to the role of a tax agent. I would definitely recommend Applied Education to anyone who wants to study Accounting, Bookkeeping or Tax Agent courses.read more

Kalina Michalowska

15:56 14 Jul 17

I have done Advance Taxation with Applied Education. Material provided was easy to understand with practical examples. Assessors are very helpful. They are a good team. The most importantly it has very affordable fee. Thanks Applied Education Team.Regardsread more

Farah Itrana

03:33 18 May 17

Applied Education were helpful and I got my results and certificates promptly which I appreciated. I will be doing more study with them in the future.read more

Kelly Townsend

05:43 04 May 17

Just completed my Dual Cert IV in Bookkeeping and Accounting and was extremely happy with the quality of service Applied Education gave. The course content was relevant and staff always helpful. I would definitely recommend to others thinking of studying this course and may further my studies in this area through Applied Education. I really enjoyed it thank you!read more

Nicki Motuzas nicola.motuzas@google.com

06:20 30 Aug 17

I just completed Property Law through Applied Education. The unit is easy to understand and very practical. Awesome experience!!!read more

Veronica Canlas

22:33 14 Aug 17

I did BAS Agent Registration Course and found it was great. I enjoyed the course as the focus was more on learning rather than getting good marks. I would recommend it to others.read more

Mali M

07:36 07 Nov 17

I just completed Tax Return for Companies subject and found it was great learning platform through Applied education, really helpful staff & tutor. I will recommend it to others as well.read more

Hard Rock

12:06 14 Nov 17

Applied Education was very good, the lecturers were very helpful, the online materials & tutorials made learning easy. I found the turnaround for marking assignments sometimes took longer then 10 working days, but once contacting them, action was taken very quick & the marked assignment was received. The feedback on assignments was always helpful and clear. I recommend Applied Education.read more

Suzanne Robson

03:02 14 May 18

Great course with user friendly student access to online courses and learning material. Staff are very helpful and respond promptly to questions and problems. Thanks to Darren Roxburgh for assisting with RPL and required courses to be completed.read more

helen tricker

10:17 18 Apr 18

I have recently finished the Tax Agent Units and can tell they are awesome! Easy to use the dashboard, easy to understand everything and everybody was very helpful. I had got answer for all of my questions within 24 hours. Thank you!read more

Diana Takacs Juhaszne

07:31 20 Feb 18

I did BAS Agent Registration Course and found it was great. I enjoyed the course as the focus was more on learning rather than getting good marks. I would like to recommend it to others.read more

Dipendra Panta

04:39 20 Feb 18

Applied Education Platform was easy to use for a 'first time online learner' Marking of Assessments was within the time limits. Assessors are quick to respond to questions. Forums and chat groups are highly valuable. The online classrooms need to be more current, but otherwise they were good.read more

Cindav Cindav

22:23 29 May 18

Very supportive and make the process as easy as it can be. I Done BAS and Payroll courses

Christian King

03:28 04 Jul 18

I found the study material and assignments complemented the scope of the module and the relevance thereof very well. Course advisors were readily available and very competent resulting in a smooth study environment.read more

Robert Hutchons

08:27 17 Jul 18

‹

›

Level 1, 524 Hay St,
Perth WA 6000

Ph: 1800 678 073
enrol@appliededucation.edu.au

Microsoft Excel Introductory Course

Classroom or Online Learning

Understanding Excel from the basics

Study Options

Online Excel Introductory Course

$79

Classroom Excel Introductory Course

$339

Online Learning - 49 Part Course

Hands-on Classroom - 1 day course

Classroom Training

Hands on classroom training in our modern facilities in Perth CBD

Training Manual & Comprehensive Resources Included for MS Excel Course

Customised Group Training

Course Duration

See what our previous students have to say about us.

Home

Courses

Students

Contact