Mac Excel Advanced
Training
Inhouse
Description
-
Type
Training
-
Level
Advanced
-
Methodology
Inhouse
To build on previous knowledge and explore Advanced functionality within Excel, finishing with an introduction to Macros.
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
Mac Excel Advanced