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.



One day: 9am to 4pm



$410 GST free per person


  • Experienced facilitator
  • Interactive, practical and hands on learning
  • Comprehensive take-home training and reference manual
  • Post-course Help Desk support
  • Certificate of Attendance for participants
  • Morning & afternoon refreshments
  • Delicious cafe lunch
  • Post course follow up


Enjoy Real People, Real Conversations, Real Results 


Certification Options - Microsoft Office Specialist

Microsoft Core Certification in Excel.


Further development

MS Excel Advanced


Is this the right course for you?

Find out here > 




4 March 2020 (One day)
30 March 2020 (One day)
9 April 2020 (One day)
29 April 2020 (One day)
13 May 2020 (One day)
26 May 2020 (One day)
4 June 2020 (One day)
26 June 2020 (One day)
8 July 2020 (One day)
27 July 2020 (One day)