Table of contents
Course Objectives
This one day course covers Excel's advanced features. The course will look at the more advanced functions and analysis techniques, and particular emphasis will be given during the course to Excel's macro commands.
Who Should Attend?
Those who have used Excel 2016 yet require a more in-depth knowledge of more advanced features and macros.
Previous experience of using Excel 2016 to an intermediate level will be assumed. Delegates who do not have this level of knowledge of Excel should first attend our "Microsoft Excel 2016 Intermediate" course.
Course Contents
Excel Database Features.
- Advanced Filter
- Database Functions
- Pivot Tables
Data Tables.
Sharing Workbooks.
Using Outlines.
Using Consolidation Commands.
Advanced Analysis Techniques.
- Scenario Manager
- Goal Seek
- Solver
Advanced Reporting Techniques.
- Custom Views
Macros.
- Recording a macro
- The Macro Language
- Running a Macro
- Relative Addresses
- Range Names
- Using Input Boxes
- Using Message Boxes
