top of page
PriorityTech Logo
Excel Logo

Excel LEVEL 2

Objectives:

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:

email: support@priorityperth.com.au

 

phone:  61-8 9315 1044

bottom of page