Microsoft Excel Advanced 2007

Overview
This course is a continuation of the Excel Intermediate course, and looks at the advanced features of Excel. It covers using charts to analyse data and make predictions. Working with pivot tables and features such as the scenario manager and goal seek.

Course objectives
This course will enable delegates to work more efficiently in their work environment, by using data analysis techniques and forecasting tools.

By the end of this course, you will have learned

• How to create custom charts
• How to create pivot tables
• How to create data tables
• How to use scenario manager
• How to use goal seek
• How to use data validation
• How to protect worksheets
• How to use templates.

Who should attend
Excel users who have a comprehensive knowledge of Excel, and are ready to investigate the advanced features of Excel in order to improve their productivity.

Pre-requisites
Delegates should have a good understanding of the Windows environment and have attended previous Excel courses, preferably to intermediate level.

Course synopsis

• Custom charts
  Creating user defined charts; using combination charts
• Data tables
  One-input and two input data tables
• Goal seek
• Scenario manager
  Creating, viewing and reporting with scenarios
• Pivot tables
  Working with data and item fields; using pivot tables to consolidate data
• Data validation
• Protecting worksheets and workbooks
• Templates
  Using templates in Excel