| |
- In House
- Public
- Computer Based
- Online
|
|
|
Further Details
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
Guide price
£395 1 to 1 and £595 per day for groups up to 8 |
