Pagoda Training Ltd - Course Outline

Pagoda Training Ltd
Helping clients deliver effective IT training projects

Microsoft Excel 2007 Advanced - Course outline

Duration	One Day
Objectives	Delegates will learn how create and edit templates and how to protect worksheets and workbooks. They will also learn how to create and edit simple macros. The course also provides delegates with an introduced to “What-If” analysis using Scenarios, Goal Seek and Data Tables. Delegates will also learn how to use other features in the Data Tools group.
Who should attend	Those who are already using Excel to an intermediate level, but who wish to analyse their data further with some of Excel's more advanced features.
Experience needed	Delegates should have attended an intermediate Excel course, or gained the relevant experience through working with Excel.

Content	Templates Creating Templates Editing Templates Using Templates Worksheet Protection Locking Cells Protecting Worksheets Protecting Workbooks File Protection Data Tools Data Validation Text to Columns Remove Duplicates Consolidating Data Using Data Consolidate Consolidate By Position Consolidate By Category Consolidate Using A Function Working with Macros Recording Macros Running Macros Editing Macros Assigning Macros Scenario Manager Creating Scenarios Editing Scenarios Viewing Scenarios Producing A Summary Report Goal Seek and Solver Finding Solutions With Goal Seek Using Solver Adding Constraints Solver Reports Data Tables Creating a one variable Data Table Creating a two variable Data Table

Pagoda Training Ltd, 2nd Floor, Thornborough Hall, Leyburn, North Yorkshire, DL8 5AB
Tel 01969 625596 Email training@pagoda.co.uk
Incorporated in England Registration No. 3132465