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

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

Sort & Filter

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

Hall Green Software Training

The Old Stables

Iscoyd

Shropshire SY 13 3AS

T: 01948 781175

e. a.norris@hallgreensoftwaretraining.co.uk

  • Facebook Social Icon
  • LinkedIn Social Icon