top of page

Microsoft Excel Advanced

Customising the work area

Customise the ribbon & quick access toolbar

Create & using styles

Creating a template

Macros

Create and using basic Macros

Advanced formula Constructions

Nested functions

Using VLOOKUP and MATCH Functions

XLOOKUP, FILTER

SUMIF and SUMIFS

Validation

Group and Hide

Protect the worksheet

Consolidating information

Functions with 3 – D reference

Consolidating Workbooks

Data manipulation

Sub Totals

Convert to a table

Custom Views

Multiple File Linking

Working with workbooks

Linking individual cells

Formula auditing

Pivot tables

Creating & changing pivot tables

Pivot table views

Adding a calculation field

Pivot Chart

Creating & formatting a pivot chart

Add a Calculated field

Extras

Spin Button, Gauge Chart, 

bottom of page