Microsoft Courses:
Microsoft Excel 2000 Advanced Training Course

Students will learn how to work with advanced features of Excel 2000.

Students will probably get the most out of this course if they want to learn the skills and concepts necessary to work with advanced features of Excel 2000. Students should have a basic knowledge of the concepts involved in using Excel 2000. For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.

Students enrolling in this course should understand the basic concepts involved in using Excel 2000. For example, they should be familiar with data types (text and values), copying data, basic formulas and functions, and opening and saving files.

To ensure students’ success with this course, we recommend that they first take the following PTR Associates courses or have equivalent knowledge:

Excel Charting & Organising Data

Topics covered on the 2 day Microsoft Excel 2000 Advanced course

Customizing the Work Area

Working with Built-in Toolbars

Using Custom Toolbars

Creating and Using Styles

Using Templates

Advanced Formula Construction

Using Names

Using the IF Function

Using the VLOOKUP Function

Using IS Functions and the Auditing Features

Using Pivot Tables

Creating Pivot Tables

Modifying Pivot Tables

Grouping and Summarizing Data in a Pivot Table

Creating Interactive PivotTables for the Web

Working with Multiple Worksheets

Working with Workbooks

Linking Cells in Different Workbooks

Workbook versus Links and Workspaces

Sharing and Merging Workbooks

Consolidating and Analyzing Data

Consolidating Data from More than One Worksheet

Using the Goal Seek and Solver Utilities

Using Scenario Manager to View a Worksheet with Different Input Values

Using Protection and Display Options

Using Comments

Protecting Workbooks

Using Custom Views

Introduction to Macros

Running Macros

Recording a Macro

Viewing and Editing VBA Code

Working with Interactive Excel Web Documents

Saving Excel Worksheets as Web Documents

Spreadsheet Web Components

   (excl.VAT)

PTR Associates Limited

21A Peach Street, Wokingham, Berkshire, RG40 1XJ, United Kingdom
Tel: 0118 979 4000 Fax: 0118 979 4035
Email: training@ptr.co.uk