Office XP Excel 2002 | Table of Contents

Office XP Excel 2002, 2/e

Timothy O'Leary, Arizona State University

Introduction to Office XP

Overview to Excel 2002

Lab 1: Creating and Editing a Worksheet

Lab 2: Charting Worksheet Data

Lab 3: Managing and Analyzing a Workbook

Working Together: Linking, Embedding, and E-Mailing

Lab 4: Using Solver, Creating Workbook Templates, Linking Workbooks, and Creating Scenarios

Lab 5: Using Data Tables, Creating Macros, and Designing Onscreen Forms

Lab 6: Creating and Using an Excel Database

Working Together 2: Creating Hyperlinks and Web Pages; E-Mailing and Embedding

Lab 7: Financial Analysis, Lookup Functions, and Visual Basic for Applications (VBA)

Lab 8: Formula Auditing, Data Validation, Pivot Tables and Charts

Lab 9: Customizing Excel

Working Together 3: Using XML and HTML with Excel on the Web

Command Summary

Glossary

Reference 1 and 2

Index

2002 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.