MENUMENU

Courses & Training | Certificate IV in Bookkeeping | Certificate IV in Accounting | Diploma of Accounting | Advanced Diploma of Accounting

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 Course Guide

Study Options

ONLINE (Instant Access)
Excel Introductory Course

Study at your own pace

Enrol now and get instant access to the online course. You can log in at any time to access the course material and continue your studies.

Study the course 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 & Start Now

CLASSROOM (Perth)
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

Join a Class

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.

Sample Videos:

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
  •  

Instant Access to Online Learning
- Enrol Now & Start Now!

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

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

Duration: 9am-4pm

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

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

View Dates & Enrol

Customised Group Training

Customised Group Training for Microsoft Excel 2010, 2013 or 2016

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
I found Applied Education to be an excellent provider of education. Helpful assessors, relevant material for the course I did and a really reasonable cost for the course and materials needed. I highly recommend Applied Education to anyone wanting to study onlineread more
Robyn Milligan
09:05 24 Jul 18
I have completed Property Law unit for my tax agent licence. The course was focused on learning and practical work. The assessments are marked fairly quick. Both the admin staff and the assesors are always there to answer your questions. I would recommend this course to anyone.read more
Nico SETIAWAN
08:18 12 Aug 18
I am a Tax Agent and had to complete 1 further unit of study as requested by the Tax Practitioners Board which was Property Law. The Unit offered by Applied Education was practical and relevant to my line of work, and very happy to say I have learnt quite a bit of useful information to help me with my practice. The course was also self paced and whenever I contacted the team to ask a question, or ask for an assessment to be escalated due to time constraints I had, they were very happy to accommodate me or discuss to manage my expectations. All in all I am very happy to recommend Applied Education to any tax agents in training who need to complete one further course.read more
Tristan Perry
13:06 12 Aug 18
I completed the Certificate IV in Bookkeeping & Accounting in August 2018. I did it online. I found the course content had a good mix of theory and practice. The support team was helpful. Upon completion I got the job I wanted: Office and Finance Manager. I keep the motion going and have now enrolled for the Diploma of Accounting with this RTO.read more
Johanna Hersey
04:36 05 Sep 18
Completed the cert IV in bookkeeping and accounting. Very much enjoyed the online aspects of the course and the support from the Applied Education staff was always prompt and clear. Highly recommend if you are wanting to do an online course at your own pace.read more
Audrey
06:56 13 Sep 18
‹
›
css.php