Phone 1300 793 951 or visit

Odyssey Training Logo
Microsoft Excel Intermediate Training Course

Microsoft Excel Intermediate

1 Day Training Course

Book a public course

Venue – Sydney

Karstens Training Centre
Level 1, 111 Harrington Street
Sydney NSW 2000
View map and directions

Times and Dates

4 Apr 2019
1 Day     9:00 am – 4:00 pm

Need your training approved?

Computer Course Inclusions

This course is ideal for

This course has been developed for people wanting to utilise Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.

Course prerequisites

Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Introduction course.

What you will learn

  • Understand and use a range of common worksheet functions
  • Understand and utilise Absolute Referencing
  • Organise a database list by advanced filtering and subtotalling
  • Utilise Conditional Formatting to change cell appearance
  • Create, modify and format a range of charts

Topics covered in this training course

  • Functions and formulas
    • Absolute cell referencing
    • Function syntax
    • Common statistical functions
    • The COUNTIF function
    • The SUMIF function
    • The IF function
  • Working with date and time
    • Date functions – TODAY and NOW
    • The EDATE function
    • The NETWORKDAYS function
    • Working with time values
    • AutoFill date sequences
  • Conditional formatting
    • Conditional formatting from cell value
    • Conditional formatting from a formula
    • Editing conditional formatting rules
    • Adding sparklines
  • Advanced sorting and filtering
    • Sorting custom lists
    • Sorting by colour
    • Complex filtering criteria
    • Searching for criteria
    • SUBTOTAL function
    • Subtotalling a list
    • Creating a simple PivotTable
  • Tables
    • Creating a table
    • Adding a table formula
    • Adding records to a table
    • Adding totals row
    • Grouping and hiding an outline
  • Advanced charts
    • Creating a chart sheet
    • Switch columns/rows
    • Creating a secondary axis
    • Changing a series chart type
    • Moving a chart
    • 3D charts
    • 3D chart rotation

Home > Microsoft Excel Training > Excel Intermediate Course > 2016

Our Training Courses

- +