Microsoft Excel - Advanced Course


Objectives of this course are to enable experienced users of Microsoft Excel to increase their knowledge of the advanced features of this powerful spreadsheet application.


This is best for

Power end Excel users who want to develop their skills using a range of formulas and use various advanced techniques to manipulate Excel data.



Review of Intermediate concepts

  • Overview of topics covered during Intermediate Excel course

Working with Multiple Sheets & Workbooks

  • Add, remove and copy sheets
  • Grouping sheets for editing & linking data from multiple sheets
  • Create 3 dimensional formulae

Advanced Data Tools

  • Consolidating data with identical and different layouts
  • Filter data - auto & advanced filter
  • Data validation & conditional formatting
  • Sensitivity analysis with goal seek, scenarios & data tables
  • Using outlines

Excel Functions

  • Working with specific function groups
  • Nesting & combining functions
  • Using named ranges

 Charts & Pivot Tables

  • Apply advanced concepts to Excel charts
  • Create pivot tables & charts
  • Using calculated fields and other pivot table techniques

Excel Automation

  • Working with templates & styles
  • Creating and editing simple Excel macros
  • Assigning macros to buttons, toolbars and other objects
  • Customising toolbars & ribbons
  • Applying protection to worksheets & workbooks

Learning outcomes

On completion of this course, participants will be able to use multiple files, link these with formulas, and work with three dimensional ranges; as well as perform Data distribution analysis, attach passwords and have a fuller understanding of the features of Excel.



Completion of Microsoft Excel Introduction and Intermediate course or equivalent knowledge is required.



Two days: 9am to 4pm


$890 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.


Is this the right course for you?

Find out here > 




19 March 2020 (Two days)
30 April 2020 (Two days)
21 May 2020 (Two days)
30 June 2020 (Two days)
20 July 2020 (Two days)