Mac Excel Advanced
Training
In London
Description
-
Type
Training
-
Level
Advanced
-
Location
London
To build on previous knowledge and explore Advanced functionality within Excel, finishing with an introduction to Macros.
Facilities
Location
Start date
Start date
Reviews
Course programme
Course Contents
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
General Analysis Tools
- Scenarios
- Custom Views
- Reports
- Goal Seek
- Solver
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
- Add-ins
Introduction to Macros
- Purpose of Macros
- Recording macros
- Where to save macros
- Absolute and relative recording
- Running macros
- Custom buttons, menu items, keyboard shortcuts
Additional information
Students per class: 8
Mac Excel Advanced