Excel Advanced

Lookup Functions

Vertical Lookup (Vlookup)
Horizontal Lookup (Hlookup)
Match and Index


Informational Functions

IsText
IsValue
IsDate
IsNull
IsErr, Is Error, IsNa


Summarising Data with Pivot Tables

Using the Pivot Table Wizard
Changing the pivot table layout
Formatting
Grouping items
Inserting calculated fields
Pivot Table Options
Display and hide data in fields
Lay out reports directly on worksheet
Pivot Chart


Advanced List Management
Advanced Filters
Using List Features
Dynamic Lists


What If Analysis Tools
Scenarios
Custom Views
Reports
Goal Seek
Solver
Data Tables


Protecting and Sharing Excel Files

Sharing a file
Tracking changes
Accepting or rejecting changes
Applying Data validation rules
Inserting comments


Customisation Options

Showing / Hiding Toolbars
Customizing Toolbars
Customizing Menus
Adaptive Menus
Default Options
Addins


Introduction to Macros

Purpose of Macros
Recording macros
Where to save macros
Absolute and relative record
Running macros:
Custom buttons, menu items, keyboard shortcuts