Microsoft
Course Outline
Microsoft Excel 2007 - Advanced
Hands-on training in an instructor-led environment. One workstation per delegate
and exercises to consolidate learning.
Training Method:
Experienced users of Microsoft Excel 2007, or as a follow on from our Introduction
and Intermediate Microsoft Excel 2007 courses.
Prerequisites:
One day
Duration:
To examine and understand some of the more advanced features of Microsoft Excel 2007. Upon
successful completion of the course the delegate will be able to use the essential features of Excel to
enable them to analyse, customise, automate and format more complex worksheets.
Objectives
Experienced users of Microsoft Excel 2007.
Designed for:
Module 1: Conditional Formatting and Data
Analysis
Conditional formatting
Subtotals
Consolidating data
Group and outline
Module 2: Pivot Table Analysis
Pivot tables
Displaying, grouping and moving fields
Refreshing data in a pivot table
Formatting a pivot table
Pivot table report filter pages
Pivot charts
Module 3: Introduction to Macros
Introduction to Macros
The Excel macro recorder
Using macros
Recording a macro
Running a macro
Content
Module 4: Look-up and Analysing Data
Look-up formulae
Data tables
Data analysis tool pack
Module 5: More About Charting
Combination charts
Plotting missing data
Create, apply or remove a chart template
Module 6: What If Analysis
Goal seeker
What is solver?
Using solver
Scenarios
* Public Courses
* Private Courses
* Customised Courses
* On site training available
Tel: 01625 549287 anne@firsttraining.net