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.