MENUMENU

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

Microsoft Excel Intermediate Course – Classroom or Online Learning

Enhance your day to day use of Excel

Download A Course Guide
microsoft excel 2013 training course lr

One day hands on classroom course

Online Excel Intermediate Course with 134 tutorials

Study Options

Online Excel Intermediate Course

Start Anytime
  • Over 134 Online Tutorials - Instructor demonstrated
  • Course manual - Electronic copy included
  • Unlimited 12 months course access
  • 6 Hours CPD

  • $79

Online Learning Instant Access - Start Now

Classroom Excel Intermediate Course

Hands On Classroom
  • Instructor led - Hands on classroom workshops
  • Course manual - Electronic copy included
  • Refreshments & lunch included
  • Expert Trainers

  • $339

Enrol Now - Classroom Courses

Online Learning - 134 Part Course

Microsoft Excel 2016 Intermediate Online Training is a convenient, effective and affordable way to learn. You can complete the Microsoft Excel Intermediate 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 Intermediate 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 7 - Click to View

Chapter 1

  • Chapter 1-1 Filling Data
  • Chapter 1-2 Filling A Growth Series
  • Chapter 1-3 Filling A Series Backwards
  • Chapter 1-4 Filling Using Options
  • Chapter 1-5 Creating A Custom Fill List
  • Chapter 1-6 Modifying A Custom Fill List
  • Chapter 1-7 Deleting A Custom Fill List
  • Chapter 1-8 Extracting With Flash Fill
  • Chapter 1-9 More Complex Flash Fill Extractions
  • Chapter 1-10 Extracting Dates And Numbers

Chapter 2

  • Chapter 2-1 Using IF With Text
  • Chapter 2-2 Using IF With Numbers
  • Chapter 2-3 Nesting IF Functions
  • Chapter 2-4 The CHOOSE Function
  • Chapter 2-5 The LOOKUP Function
  • Chapter 2-6 Using Counting Functions
  • Chapter 2-7 The Round Function
  • Chapter 2-8 Rounding Up And Rounding Down
  • Chapter 2-9 Manipulative Functions
  • Chapter 2-10 The MOD Function
  • Chapter 2-11 The TODAY Function
  • Chapter 2-12 The NOW Function
  • Chapter 2-13 The DATE Function
  • Chapter 2-14 The PMT Function

Chapter 3

  • Chapter 3-1 Scoping A Formula
  •  Chapter 3-2 Preparing For Complex Formulas
  •  Chapter 3-3 Creating The Base Formula
  •  Chapter 3-4 Adding More Operations
  •  Chapter 3-5 Editing A Complex Formula
  •  Chapter 3-6 Adding More Complexity
  •  Chapter 3-7 Copying Nested Functions
  •  Chapter 3-8 Switching To Manual Recalculation
  •  Chapter 3-9 Pasting Values From Formulas
  •  Chapter 3-10 Documenting Formulas

Chapter 4

  • Chapter 4-1 Understanding Defined Names
  •  Chapter 4-2 Defining Names From Worksheet Labels
  •  Chapter 4-3 Using Names in Typed Formulas
  •  Chapter 4-4 Applying Names To Existing Formulas
  •  Chapter 4-5 Creating Names Using The Name Box
  •  Chapter 4-6 Using Names To Select Ranges
  •  Chapter 4-7 Pasting Defined Names Into Formulas
  •  Chapter 4-8 Defining Names For Constant Values
  •  Chapter 4-9 Creating Names From A Selection
  •  Chapter 4-10 Scoping Names To A Worksheet
  •  Chapter 4-11 Using The Name Manager
  •  Chapter 4-12 Documenting Defined Names

Chapter 5

  • Chapter 5-1 Using Goal Seek

Chapter 6

  • Chapter 6-1 Inserting And Deleting Worksheets
  • Chapter 6-2 Copying A Worksheet
  • Chapter 6-3 Renaming A Worksheet
  • Chapter 6-4 Moving A Worksheet
  • Chapter 6-5 Hiding And Unhiding A Worksheet
  • Chapter 6-7 Changing Worksheet Tab Colours
  • Chapter 6-8 Grouping Worksheets
  • Chapter 6-9 Hiding and Unhiding Rows And Columns
  • Chapter 6-10 Freezing Rows And Columns
  • Chapter 6-11 Splitting Windows

Chapter 7

  • Chapter 7-1 Using Margins
  • Chapter 7-2 Centring
  • Chapter 7-3 Changing Orientation
  • Chapter 7-4 Specifying The Paper Size
  • Chapter 7-5 Setting The Print Area
  • Chapter 7-6 Inserting Page Breaks
  • Chapter 7-7 Setting And Clearing The Background
  • Chapter 7-8 Setting Rows As Repeating Print Titles
  • Chapter 7-9 Printing Gridlines and Headings
  • Chapter 7-10 Scaling To A Percentage
Learning Outcomes Chapters 8 to 14 - Click to View

  • Chapter 8

    • Chapter 8-1 Applying A Border To A Cell
    • Chapter 8-2 Applying A Border To A Range
    • Chapter 8-3 Applying A Bottom and Top And Bottom Border
    • Chapter 8-4 Removing Borders
    • Chapter 8-5 The More Borders Command
    • Chapter 8-7 Erasing Borders
    • Chapter 8-8 Formatting The Drawing Pencil

    Chapter 9

    • Chapter 9-1 Applying Alternate Currencies
    • Chapter 9-2 Applying Alternate Date Formats
    • Chapter 9-3 Formatting Clock Time
    • Chapter 9-4 Formatting Calculated Time
    • Chapter 9-5 Creating Descriptive Custom Formats
    • Chapter 9-6 Custom Formatting Large Numbers
    • Chapter 9-7 Custom Formatting For Fractions
    • Chapter 9-8 Padding numbers Using Custom Formatting
    • Chapter 9-9 Aligning Numbers Using Custom Format
    • Chapter 9-10 Customising The Display Of Negative Values

    Chapter 10

    • Chapter 10-1 Formatting Cells Containing Values
    • Chapter 10-2 Clearing Conditional Formatting
    • Chapter 10-3 More Cell Formatting Options
    • Chapter 10-4 Top Ten Items
    • Chapter 10-5 More Top And Bottom Formatting Options
    • Chapter 10-6 Working With Data Bars
    • Chapter 10-7 Working With Colour Scales
    • Chapter 10-8 Working With Icon Sets
    • Chapter 10-9 Creating Sparklines
    • Chapter 10-10 Editing Sparklines

    Chapter 11

    • Chapter 11-1 Quick Formatting
    •  Chapter 11-2 Quick Charting
    •  Chapter 11-3 Quick Totals
    •  Chapter 11-4 Quick Sparklines
    •  Chapter 11-5 Quick Tables

    Chapter 12

    • Chapter 12-1 Creating A Table From Scratch
    • Chapter 12-2 Working With Table Styles
    • Chapter 12-3 Inserting And Deleting Table Columns
    • Chapter 12-4 Converting A Table To A Range
    • Chapter 12-5 Creating A Table From Data
    • Chapter 12-6 Inserting Or Deleting Table Records
    • Chapter 12-7 Removing Duplicates
    • Chapter 12-8 Sorting Tables
    • Chapter 12-9 Filtering Tables
    • Chapter 12-10 Renaming A Table
    • Chapter 12-11 Splitting A Table
    • Chapter 12-12 Deleting A Table

    Chapter 13

    • Chapter 13-1 Adding A Chart Title
    • Chapter 13-2 Adding Axes Titles
    • Chapter 13-3 Repositioning The Legend
    • Chapter 13-4 Showing Data Labels
    • Chapter 13-5 Showing Gridlines
    • Chapter 13-6 Formatting The Chart Area
    • Chapter 13-7 Adding A Trendline
    • Chapter 13-8 Adding Error Bars
    • Chapter 13-9 Adding A Data Table
    • Chapter 13-9 Adding A Data Table

    Chapter 14

    • Chapter 14-1 Selecting Chart Objects
    • Chapter 14-2 Using Shape Styles
    • Chapter 14-4 Changing The Colour Of A Series
    • Chapter 14-5 Changing Line Chart Colours
    • Chapter 14-6 Using Shape Effects
    • Chapter 14-7 Colouring The Chart Background
    • Chapter 14-8 Using The Format Pane
    • Chapter 14-9 Exploding Pie Slices
    • Chapter 14-11 Formatting Text
    • Chapter 14-12 Formatting With WordArt
    • Chapter 14-13 Changing WordArt Fill
    • Chapter 14-14 Changing WordArt Effects

Instant Access to Online Learning - Sign Up & Start Now

Classroom Course

1 Day Hands On Classroom Course

The Excel Intermediate training course is designed for users familiar with Excel basics and want to really improve their productivity and get more out of their spreadsheets.

Use detailed functions and complex formulas to enhance your spreadsheet. Use simple tools like Goal Seek to quickly adjust your results in excel.

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

Classroom Training

Hands on classroom training in our modern facilities in Perth CBD

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 Intermediate 2016 Manual (online electronic version)
Handy Tips guide
Handy Tips for Excel 2016 Intermediate (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

Classroom Dates & Schedule - Perth

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.

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
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
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 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 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 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
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
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
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
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
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
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 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
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
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
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
‹
›
Download A Course Guide
css.php