Course Overview

Become a Microsoft Excel master with our Excel Intermediate program. Building upon the basics, this program delves into the more complex functionalities of Excel. Pivot tables, quick analysis, intricate formulas, and functions are just part of the key learning outcomes of this program.

This program assumes knowledge of our EXCE101 - Microsoft Excel Beginners program.

What you’ll Receive

  • 3 Hour Course

  • Handbook

  • Participation eCertificate

  • Post Course Support

  • Online

    $199 + GST (Per Person)

Key Topics Covered

  • Use common worksheet functions. 
  • Use filling techniques. 
  • Apply a variety of page setup techniques. 
  • Use a range of techniques to work with worksheets. 
  • Apply borders to cells and ranges in a worksheet. 
  • Create and use defined names in a workbook. 
  • Apply conditional formatting in ranges in a worksheet. 
  • Create and work with tables. 
  • Use a variety of financial functions. 
  • Select and change the format of object in a chart. 
  • Use a range of elements and features to enhance charts. 
  • Create more complex formulas and functions. 
  • Apply a range of number formatting techniques to sheet cells. 
  • Understand and use Excel's Quick Analysis tools. 
  • Understand and create basic pivot tables 
Register Now

Who Is This Course Ideal For?

This program has been developed to enhance the skills and overall knowledge of Board Members, Executive Team members and Aged Care Managers in a diverse range of management areas.

Do you want to know more? Getting in touch.