Microsoft Excel - Intermediate Course


Objectives of this course are to enable experienced users of Microsoft Excel to consolidate their knowledge of formulae and functions and unlock the graphics and database features contained within this powerful spreadsheet application.


This is best for

Excel users with an existing Basic knowledge of spreadsheets.



Cell Referencing

  • Absolute and relative & partial cell referencing
  • Trace precedents
  • Link workbooks & calculate across sheets

Functions & Formulas

  • Work with named ranges
  • Use the IF, AND and OR functions
  • Use the VLookUp & HLookUp functions

Working with Data

  • Import/Export data
  • Use tables for sorting & filtering
  • Data validation
  • Conditional formatting
  • Summarise data by creating subtotals

Pivot Tables

  • Create and format pivot tables


  • Apply charting features


  • Protect cells, sheets & workbooks

Learning outcomes

On completion of this course, participants will have a good understanding of functions and formula and be able to sort data, filter database and create customised charts.



Completion of Excel Introduction or equivalent knowledge is required.



1 day


Certification Options - Microsoft Office Specialist

Microsoft Core Certification in Excel.


Software versions

Available for 2010, 2013, 2016 & 365


Further development

MS Excel Advanced


Is this the right course for you?

Find out here > 



Book Now





"Our suite of Computer Training courses are designed to support each participant in learning new skills and implementing them back into their workplace. We want to ensure that your organisation’s key assets, your people, are equipped to achieve maximum productivity."   



Standard Course Information


  • Take home course manual
  • Facilitator led training
  • Qualified trainer
  • Certificate of Attendance for participants
  • Post-course Help Desk support
  • Morning & afternoon refreshments
  • Lunch

Training venue:

Cloisters Level 1, 863 Hay Street
Perth CBD
Additional information:

  • IT standard training day runs from 9.00am - 4.00pm
  • 1 hour lunch break for full day courses
  • ½ day courses vary, please contact us for timings
  • Prices quoted are standard rates
  • Government and other discounts may apply and will be confirmed on invoice


Roving Training

Need IT Training? Don't have time to go on a course? We are happy to come to you!

One of our expert instructors roams your workplace calling in any users that require coaching in any desktop applications. 

Roving training is perfect if numerous employees need some tips and tricks on various programs. Training is tailored to your individual needs and we are able to train using your own documents.   


Customised Solutions

We understand one size does not always fit all. Our team of qualified trainers can create a customised solution tailored to your specific needs.

We are happy to offer closed group sessions or additional dates as you require.

To discuss customisation training, simply call 08 9218 9059 or email


Logo Bulb

Enriching lives.
Empowering organisations.