Excel 2010 - Intermediate

This course has no current classes. Please join the waiting list.

Excel 2010 Training in Newcastle!

The Intermediate Excel 2010 training session is designed to introduce participants to some of the more advanced features of Microsoft Excel 2010.

By the end of the training session you will:

  • Be shown where and how to change MS Excel options;
  • Be able to use the Name Box to name cells and ranges and then be able to use the named cells and ranges in formulas;
  • Be introduced to, and be able to use Date functions such as DAY; MONTH; YEAR; TODAY; and NOW
  • Know how and when to use the most popular logical function – the IF function;
  • Be introduced to statistical functions such as COUNT, COUNTA and COUNTIF as well as mathematical functions such as SUMIF;
  • Understand how data lists are created and how to filter and sort information in those lists;
  • Know how to use conditional formatting;
  • Create and format graphical charts.


  • USB, notebook & pen


  • Participants must have successfully completed our Excel 2010 – Introduction class.

WEA Hunter offers a wide variety of Lifestyle & Leisure courses at various locations throughout Newcastle and the Hunter Region.
Course enrolment must be accompanied by a fee; we are unable to hold places for people or accept deposits on Lifestyle courses. Once enrolment is completed students will receive a course confirmation either in writing or by email. This course confirmation constitutes a receipt.

Please visit our website to read our Fee, Withdrawal and Refund Policy (https://www.weahunter.edu.au/fee-withdrawal-and-refund-policy). This policy outlines your options for situations where WEA Hunter or WEA Coast cancels a course, or where you are unable to attend the course you have enrolled in. Please contact one of our friendly staff if you have any enquiries or need to make any changes to your enrolment.