MS Excel - Advanced
One Day Training Course / £275 plus VAT
This one-day instructor led course is designed to give delegates the ability to analyse data in a variety of ways. By the end of the course delegates will be able to use the built in Excel tools to compare data and create projections and also to understand and use the macro facility of Excel.
Course Objectives
- Analyse data using pivot tables
- Develop solutions to financial and budgeting questions
- Control the output of printed work with report manager
- Verify calculations and trace errors using auditing facility
- Automate routine tasks with macros
Pre-requisites
This course is designed for experienced Excel users who have completed the Excel Intermediate course or have equivalent knowledge. Delegates should already be able to create detailed worksheets using complex formulas and should be familiar with conditional and nested functions.
Course Content
|
Review of Excel day to day features
|
|
|
Pivot Tables
|
Macros
|
|
- Creating a pivot table
|
- Recording a simple macro
|
|
- Rearranging pivot tables
|
- Editing a macro
|
|
- Formatting pivot tables
|
- Assigning a macro to keyboard or toolbar button
|
|
- Creating charts
|
|
|
|
|
|
Analytical Tools
|
Auditing Facility
|
|
- Using Goal seek and Solver
|
- Tracing Precedents/Dependents
|
|
- Creating Scenarios
|
- Checking for errors
|
|
|
- Applying data validation to cells with input text and error messages
|
|
Report Manager
|
|
|
- Using Report Manager
|
|
|
- Managing views and reports
|
|