Collection: Intermediate Excel

EXCE201

Build on your skills to become an Excel master user!

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.

Need a quote for In-Person training?

What you’ll Receive

  • 3 Hour Course
  • Handbook
  • Participation eCertificate
  • Post Course Support

Download Brochure

  • Online

    $199 + GST (Per Person)

Offers

Register to attend both Beginners Excel and Excel Intermediate and get both courses for just $298! That's a saving of $100!

Book 5 or more people to attend this course and save $50 per person!

* Offers automatically applied at checkout, participants can attend different dates of the same course. Offers cannot be combined.

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 

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.