MS Excel 2002 Expert User

Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
This course covers skills particular to the expert user of Excel 2002. The course teaches template and database integration. The section on Workbook Capabilities deals with shared workbooks and with consolidating data across workbooks. The final section, Data Analysis and Automation, covers data importing and querying, pivot tables, macros, and data analysis tools.

Target Audience
The intended audiences for this course are End Users and Power Users who may or may not be familiar with previous versions of Microsoft Excel. Their relevant duties may include office or managerial duties. They may be involved in working with accounting and financial data. The audience will include end users, help desk/support personnel, and other network designers. It is expected that learners should have a working knowledge of Microsoft Windows 9x or later operating systems, and basic knowledge of either Microsoft Office 97 or 2000 programs. Learners should have also completed courses 74030 and 74031 or have equivalent knowledge..

Expected Duration (hours)
8.0

Lesson Objectives

MS Excel 2002 Expert User

Create a new template file.

Modify an existing template file.

Create a new workbook by using a user-defined template.

Open a spreadsheet solutions template.

Enter data in a list by using the data form.

Sort a row in a list by using multiple columns.

Sort a column in a list by using multiple rows.

Create a custom sort order.

Apply a custom filter to a list.

Summarize data in a list by using subtotals.

Create a shared workbook.

Highlight changes in a shared workbook.

Accept a change in a shared workbook.

Merge multiple workbooks.

Create a workspace file.

Import a delimited text file.

Import data from a fixed-width text file.

Import data from a database.

Create an Extensible Markup Language (XML) query.

Identify the features of the real-time data (RTD) function.

Export data in text file format.

Save a workbook in Extensible Markup Language (XML) spreadsheet format.

Create a PivotTable.

Identify different formats to apply to a PivotTable report.

Change the summary functions in a PivotTable.

Hide data in a PivotTable.

Manipulate a field in a PivotTable.

Identify features of a PivotChart.

Record a macro.

Run a macro.

Edit a macro.

Assign a macro to a Custom Button.

Create a scenario.

View a scenario.

Create a scenario report.

Forecast using the Goal Seek command.

Generate the optimal solution under set constraints by using Solver.

Course Number:
en_US_74032_ng