MS Excel 2007 Advanced
Training
Inhouse
Description
-
Type
Training
-
Methodology
Inhouse
-
Duration
1 Day
To build on previous knowledge and explore Advanced 2007 functionality within Excel, finishing with an introduction to Macros. Suitable for: Fairly experienced Excel 2007 users whom need to learn more complex functions, nesting, data manipulation and automation using basic macros.
Reviews
Subjects
- MS Excel
Course programme
Lookup & Information Functions
- Vertical Lookup (Vlookup)
- Horizontal Lookup (Hlookup)
- Match and Index
- IsText, IsValue, IsDate , IsNull , IsErr, Is Error, IsNa
Advanced List Management
- Advanced Filters
- Using List Features
- Dynamic Lists
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
What If Analysis
- Scenarios
- Custom Views
- Reports
- Goal Seek
- Solver
- Data Tables
Protecting & Sharing Files
- Sharing a file
- Tracking changes
- Accepting or rejecting changes
- Applying Data validation rules
- Inserting comments
Introduction to Macros
- Purpose of Macros
- Recording macros
- Where to save macros
- Absolute and relative record
- Running macros:
- Custom buttons, menu items, keyboard shortcuts
**You are able to include/exclude as much content as you need to create your own Excel 2007 Advanced Training Course**
Time: The course starts at 09:30 and runs until 16:30.
The course is run on a date that suits you! We do not run public scheduled courses.
Additional information
Students per class: 8
MS Excel 2007 Advanced