Microsoft Excel Intermediate

This Live Online 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.

1 day course
4.17  (6 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:
Courseware and Handouts
Live Recorded Session copy
Capped class sizes
eCertificate
Post Course Support
Download Info Brochure Download Practice Files
Course Prerequisites:

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

Before Session:

Please ensure you have downloaded the latest version of the software Microsoft Excel Desktop for use within the session. We also require a working computer with a microphone and speaker installed, and an up-to-date web browser for this training. For the best experience we recommend downloading the latest Google Chrome browser.

It is also recommended that you have a second screen attached to your computer.  This will allow you to watch the online training session and complete the course activities at the same time.

Looking for In-House training?

Discover our Microsoft Excel Intermediate In-House training course. Can’t find what you are looking for?  Enquire for  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
You might be interested in:
Microsoft Excel Advanced
This Live Online Course exposes many advanced features of Excel including protecting your workbooks and restricting data entry, building calculations using advanced functions and how to import, clean up, and analyse data sets.
1 day course
from
$390
Microsoft Power BI Introduction
This Live Online Session is beneficial for anyone wanting to create powerful interactive dashboards, chart and a range of visualisations to display data in a user friendly way from a range of sources. 
1 day course
4.00  (2)
from
$390
4.17
4.17
from 6 reviews
4/5
“Great content, brilliant facilitator.”
Ruth, Sep 2020
5/5
Les, Jul 2020
4/5
“Michael presented the course very well and was happy to go over anything that we needed to know more on. I was made feel relaxed with my level to start with.”
David, Jul 2020
5/5
“It was my first time to attend a Webinar, but very impressed how well the trainer was managing the session remotely involving all attendees with interesting webinar functions (thumbs up/down, chatting box, etc). ”
Chieko, Jul 2020
Load more