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
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
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