Microsoft Excel Intermediate

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. Secure your spot in our course in Brisbane, Sydney or Melbourne by booking online today.

1 day course
4.65  (3074 reviews)
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 and modify charts to create static dashboards
What you'll get:
Workbook
Refreshments
Capped class sizes
eCertificate
Course prerequisites

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

Topics covered in this training course:
  • Absolute cell referencing
  • Function syntax
  • Common statistical functions
  • The COUNTIF function
  • The SUMIF function
  • The IF function
  • Date functions – TODAY and NOW
  • EDATE and NETWORKDAYS
  • Work with time values
  • AutoFill date sequences
  • Format cell value
  • Format using a formula
  • Editing conditional formatting rules
  • Adding sparklines
  • Sorting custom lists
  • Sorting by colour
  • Complex filtering criteria
  • Searching for criteria
  • SUBTOTAL function
  • Subtotalling a list
  • Creating a simple PivotTable
  • Creating a chart sheet
  • Switch columns/rows
  • Create a dual axis chart
  • Changing a series chart type
  • Moving a chart
  • 3D charts
  • 3D chart rotation
  • Create a simple, static dashboard
    Reset options
- +

Need your training approved? Get a quote

Need your training approved? Get a quote
4.65
4.65
from 3074 reviews
5/5
“Great structure, just the right detail. Overall happy. Thank you Annie!”
Annika, May 2019
5/5
“Very knowledgeable instructor. Very enthusiastic and engaging.”
Oliver, May 2019
5/5
“Annie was lovely and very knowledgeable. ”
Kelly, May 2019
5/5
“The trainer Katherine was excellent and was able to teach additional knowledge based on questions of the class that was not covered in the structure.”
Joey, May 2019