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

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