Microsoft Excel Intermediate Course

Intermediate Microsoft Excel Training


Course Overview

This is an intermediate Excel course that will build on your existing Excel skills.  Following this course, you will work smarter in Excel, helping you to better organise and present your data. You will Learn to use some of Excel’s more powerful functions such as If’s, features like sorting and filtering data.  Conditional Formatting along with improvements to charts will allow you to feel much more confident in creating effective presentation of your data.  This is a hands-on course and includes plenty of chances to try out what you are being taught and ask questions.


  • A moderate English language, literacy and numeracy skill is required.
  • Participants must bring their own laptop for training days.
  • Lunch:  Catering is provided, or you are welcome to bring your own (microwave and fridge available). Tea, Coffee and biscuits available.
  • Parking is available on site, or it is a short walk from Glendalough Train Station.

Learning Outcomes

At the completion of the program Excel Intermediate participants should be able to:

  • Create If Functions to analyse data
  • Format Spreadsheets according to their values
  • Analyse Data using Sorting and Filtering
  • Apply Borders
  • Create Advanced charts.

Course Content

  • Revision Exercise
  • Complex Formulas
  • Scoping Formulas
  • Logical Functions
  • IF, AND, OR, NOT
  • Number Formatting
  • Conditional Formatting
  • Data Bars, Icon Sets, Colour Scales
  • Applying Borders
  • Working with a Worksheet
  • Adv Find and Replace
  • Page Setup
  • Print Titles
  • Creating Sparklines
  • Sorting Data
  • Filtering Data
  • Understanding Chart Elements
  • Chart Object Formatting


Choose A Date To Enrol

Course Price



MTA Training Facility in Osborne Park or;
on-site delivery with you (minimum 6 people)


Two (2) days.


Certificate of Attendance
RTO: 51586

Mine Training Australia will provide you with all the skills and knowledge you need for working in Mines in Australia

You can get in touch with us on our contact form, by email, or by phone on 1300 938 411. The x team are always here to discuss your training requirements in Perth, regional WA or throughout Australia.

WA Owned & Run Business


Nationally Recognised Certifications

Industry Specialists


Easy Help & Support

Easy & Flexible Payment Options


Specialised Trainers & Assessors