Microsoft Excel 2000 Professional

Course Aims
This course is designed to give users an understanding of advanced features and functions within Microsoft Excel 2000. The course is entirely 'hands on', so those attending will get practice in using Microsoft Excel to analyse and share spreadsheet data and create spreadsheet databases.
Who Should Attend?
Existing users of Microsoft Excel who want to gain further in-depth knowledge on how to manage and audit spreadsheets. Note : A solid working knowledge of Microsoft Excel in a Windows environment is required.
Course Outline: Microsoft Excel 2000 Professional
Auditing a Worksheet
· Using Worksheet Auditing Tools · Data Entry Validation · Validating the Whole Worksheet · Auditing Data Dependency · Finding and Replacing Data
Working with Data Lists
· Setting Up Lists · Sorting Lists · Filtering Lists · Using Forms
Data Management
· Searching for Data with Advanced Filters · Compiling Consolidations · Summarising Data with Outlines · Querying a Database · Data Sources · Controlling Formatting and Layout · Refreshing External Data
PivotTables
· Creating a PivotTable · Modifying a PivotTable · Creating a PivotTable Chart · Creating Interactive PivotTables for the Web · Working with an Interactive PivotTable
Using Analysis Tools
· Goal Seeking · Using Solver · The Scenario Manager · Scenario Summaries · Merging Scenarios
Collaborating with Workgroups
· Applying Worksheet Protection · Password Protecting a File · Changing Workbook Properties · Adding Comments to the Worksheet · Shared Workbooks · Tracking Changes · Resolving Conflicts · Merging Workbooks · E-mailing Workbooks for Review