Microsoft Excel Intermediate - 1 Day Course - Melbourne

This course is ideal for

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.

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, modify and format a range of charts.

Topics covered in this training course

Functions and formulas

• Absolute cell referencing

• Function syntax

• Common statistical functions

• The COUNTIF function

• The SUMIF function

• The IF function

Working with date and time

• Date functions – TODAY and NOW

• The EDATE function

• The NETWORKDAYS function

• Working with time values

• AutoFill date sequences

Conditional formatting

• Conditional formatting from cell value

• Conditional formatting from a formula

• Editing conditional formatting rules

• Adding sparklines

Advanced sorting and filtering

• Sorting custom lists

• Sorting by colour

• Complex filtering criteria

• Searching for criteria

• SUBTOTAL function

• Subtotalling a list

• Creating a simple PivotTable

Tables

• Creating a table

• Adding a table formula

• Adding records to a table

• Adding totals row

• Grouping and hiding an outline

Advanced charts

• Creating a chart sheet

• Switch columns/rows

• Creating a secondary axis

• Changing a series chart type

• Moving a chart

• 3D charts

• 3D chart rotation