Loading Events

« All Events

  • This event has passed.

Microsoft Excel Intermediate

August 31, 2018 @ 9:00 am - 3:30 pm


A full-day workshop with Nicholas Jankovic for those who wish to learn correct spreadsheet procedures, develop powerful skills and learn time-saving techniques.

Excel Intermediate/Advanced is an ideal course for people who currently use Excel and wish to increase their skills to beyond that of most corporate workers.  The subjects covered in this course are ideal for standing out amongst your colleagues as a talented Excel user without entering the advanced skills of Excel Advanced.

Subjects covered in this course include:

  • Working with VLOOKUP
  • Linking cells between Excel tabs
  • Templates
  • PivotTable and PivotChart basics
  • Drop-down menus in cells
  • Working with SUMIF and COUNTIF
  • Sorting in depth
  • Filtering in depth
  • Naming cells
  • Calculating with dates
  • Absolute referencing
  • Working with SUBTOTAL
  • Protecting worksheets
  • Logic tests (eg: IF, AND, OR)
  • Conditional formatting
  • Print area, page breaks and page scaling

Group discount available

Click here to register

Click here to download a flyer for this event


August 31, 2018
9:00 am - 3:30 pm


Nicholas Jankovic


The Hartley Institute
54 Capper Street
Kent Town , South Australia Australia
+ Google Map