Back to Search Results

Training Course Summary:

This in-depth two-day course introduces Microsoft Excel 2000 users to the advanced features of the software application. Participants will learn how to sort and manage data in lists; filter and query data; use outlines on worksheets, lookup and database functions, and PivotTables. In-class exercises will involve use of data tables and scenarios to make projections about data and use Goal Seek, Solver, and the Analysis ToolPak to analyze data. Students will also learn how to audit worksheets, protect worksheets and workbooks, create and use macros and templates, and import and export information and documents. Additional topics include use of workgroup features; working with custom views and Report Manager; and creating and modifying data maps. After completing ExecuTrain's Excel 2000 Introduction, Intermediate, and Advanced courses, students would have covered all the topics that map to the Microsoft Office User Specialist Expert certification exam.

Pre-Requisites:

Excel 2000 Intermediate

Training Course Overview/Content:

Sort and manage data in lists.
Filter and query data.
Use outlines on worksheets.
Use lookup and database functions.
Use PivotTables to display and chart data.
Use data tables and scenarios to make projections about data.
Use Goal Seek, Solver, and the Analysis ToolPak to analyze data.
Audit worksheets.
Protect worksheets and workbooks.
Create and use macros.
Use and create templates.
Import and export information and documents.
Use workgroup features.
Work with custom views and Report Manager.
Create and modify data maps.