Microsoft Excel 97: Total (Advanced)

ISBN: 0-07-228451-X
Published: 8/10/1998
Pages: 301 with 5 Chapters
Binding: Spiral/Coil Bound

Student download files:
Student Data Files (441 KB) Alternate Site

Instructor download files:
IRK Source Documents: Adobe PDF: Advanced (573 KB)
IRK Data/Solution Files: Solution Files: Advanced (838 KB)

Miscellaneous Web resources:
Check for MHHE Catalog Listing

Related tutorials for students:
Advantage Interactive: Excel 97 CD-ROM (ISBN: 0256268150)
Microsoft Excel 97 for Windows (ISBN: 0256259976)
Microsoft Excel 97 with Data Disk (ISBN: 0075610094)
Microsoft Excel 97: MOUS Certified (ISBN: 007228255X)
Microsoft Excel 97: Total (Intermediate) (ISBN: 0072284501)
Microsoft Excel 97: Total (Intermediate/Advanced) (ISBN: 0256203318)

Other resource materials:
IRK Microsoft Excel 97: Total Advantage (ISBN: 0070274797)

Session 1: Publishing Charts, Trends, and Web Documents

Session Outline
Learning Objectives
Charting Overview
Working with Chart Elements
Finding Trends and Forecasting Results
Internet Fundamentals
Using Hyperlinks
Working with HTML Documents
Posting Documents to the Web
Understanding Web Queries
Summary
Key Terms
Exercises
Case Study

Session 2: Automating Your Work

Session Outline
Learning Objectives
What Is a Macro?
Creating Macros
Editing Macros
Troubleshooting and Debugging
Customizing Your Workspace
Summary
Key Terms
Exercises
Case Study

Session 3: Working with Visual Basic for Applications

Session Outline
Learning Objectives
Introducing VBA
Touring the VBA Environment
The VBA Language
Working with Excel Objects
Controlling Your Procedures
Summary
Key Terms
Exercises
Case Study

Session 4: Some Finishing Touches

Session Outline
Learning Objectives
Planning a Workbook Application
Validating Data
Working with Controls
Interacting with the User
Creating a User Form
Summary
Key Terms
Exercises
Case Study

Session 5: Integrating Excel with Office 97

Session Outline
Learning Objectives
Object Linking and Embedding (OLE)
Exporting and Importing Data
Working with Word
Working with PowerPoint
Working with Access
Summary
Key Terms
Exercises