top of page
PriorityTech Logo
Excel Logo

Excel LEVEL 2


In this course, you will create advanced formulas, analyse data with functions and PivotTables, work with tables, visualise data with charts, use graphical objects and enhance workbooks.

Unit 1 Creating Advanced Formulas:

You will learn how to:

  • Use range names in formulas and functions

  • Use specialised functions.

Unit 2 Analysing Data with Logical and Lookup Functions:

Priority Management will show you how to:

  • Analyse data by using text, logical, lookup, date, and financial functions.


Unit 3 Organising Worksheet Data with Tables:

You will learn how to:

  • Create, format, and modify tables

  • Use structured references, as well as the subtotal and database functions.


Unit 4 Visualising Data with Charts:

You will learn how to:

  • Create charts

  • Modify and format existing charts

  • Create a trendline and advanced charts.


Unit 5 Analysing Data with PivotTables, Slicers, and PivotCharts:

You will learn how to:

  • Create a PivotTable

  • Filter data using slicers

  • Analyse data using PivotCharts


Unit 6 Working with Graphical Objects:

You will learn how to:

  • Insert, modify, layer, and group graphical objects

  • Incorporate SmartArt into workbooks.


Unit 7 Enhancing Workbooks:

You will learn how to:

  • Customise workbooks

  • Manage themes

  • Protect files

  • Prepare a workbook for multiple audiences.

View available public workshops here

Contact us for group rates for 8 to 20 people:



phone:  61-8 9315 1044

bottom of page