Excel Advanced Course Durantion: 1 day

Databases
Database terms.
Advanced filter.
Database functions.

Pivot Tables
Creating a pivot table.
Modifying a pivot table.
Formatting data.
Refreshing data.
Using the drill down facility.
Sorting & filtering data.
Adding calculated fields.
Grouping data.

Conditional Functions
IF
AND
OR
IFS
SWITCH
Using formulae within Conditional tests.
Nesting conditional statements.

Lookup Functions
VLOOKUP
HLOOKUP
IFNA

Consolidating data
Setting up a consolidation
Consolidation by position
Consolidation by category.

Tables

Macros
Recording simple macros.
Macro storage.
Running macros.
Absolute & relative references.
Assigning shortcuts to macros.
Creating a macro button
Viewing VBA code.