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  (3087 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.

Do I need to bring my own laptop?

Participants are not required to bring their own laptops as our dedicated computer training labs are equipped with the programs and files you will need access to on your training day.

Looking for Online training?

Discover our Microsoft Excel Intermediate Online training course. Can’t find what you are looking for?  Enquire for online training today!

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 3087 reviews
5/5
“I think it was all good.”
R, May 2020
4/5
“Good insight to Power BI”
Leigh, May 2020
4/5
“Learn't how to do many things I couldn't previously do”
Kevin, May 2020
4/5
“Little tricks and ways of using tools that I didn't know before”
Juanita, May 2020