ADVANCED EXCEL - Stage 3 Course

Overview

Previous training, and use of Excel, has provided the student with a solid foundation in the basic and intermediate skills for working with Excel spreadsheets. Excel will have been used to perform tasks such as running calculations on data, and sorting and filtering numeric data. In this course, the objective is to extend knowledge into the more specialised and advanced capabilities of Excel by automating some common tasks, applying advanced analysis techniques to complex data sets, and share Excel data with other appications.

Prior Knowledge Requirements

A course for people who have previously attended Stage 1 and 2, or who have been working with spreadsheets and have a good knowledge of basic and intermediate Excel use, and wish to take their knowledge to an advanced level.

The course covers the following areas:

Templates & Styles

• Using Templates
• Creating a Template
• Applying Templates
• Using Styles
• Creating a Style
• Appling a Style
• Editing a Style
• Copying Styles from another Workbook

Streamlining Spreadsheets

• Outlining
• Sub-totals & Grand Total
• Cell Comments
• Data Validation
• Consolidation

Analyzing Data

• What-if Analysis
• Goal Seek
• Data Tables
• Scenario Manager
• Solver

Macros & Custom Controls

• Working with Macros
• Recording Macros
• Running Macros
• Creating Macro Buttons
• Adding Custom Controls

Contact: Sheila Fletcher

Phone: 01827 61906, 07751 879723

Email: sheila@arrowtraining.co.uk