Microsoft Excel 97: Total (Intermediate/Advanced)

ISBN: 0-256-20331-8
Published: 8/10/1998
Pages: 594 with 10 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 Source Documents: Adobe PDF: Intermediate (1.3 MB)
IRK Data/Solution Files: Solution Files: Advanced (838 KB)
IRK Data/Solution Files: Solution Files: Intermediate (579 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 (Advanced) (ISBN: 007228451X)
Microsoft Excel 97: Total (Intermediate) (ISBN: 0072284501)

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

INTERMEDIATE LEVEL

Session 1: Managing Lists

Session Outline
Learning Objectives
Working with Lists
Entering Data
Finding Data
Sorting a List
Filtering a List
Printing a List
Summary
Key Terms
Exercises
Case Study

Session 2: Summarizing Your Data

Session Outline
Learning Objectives
Working with Ranges
Analyzing Lists
Creating Subtotals
Outlining a Worksheet
Working with Pivot Tables
Summary
Key Terms
Exercises
Case Study

Session 3: Working Smarter

Session Outline
Learning Objectives
Working with Functions
Using Lookup Tables
Protecting Your Work
Documenting Your Work
Using Templates
Summary
Key Terms
Exercises
Case Study

Session 4: Analyzing Alternatives

Session Outline
Learning Objectives
Performing What-If Analysis
Entering a Data Series
Creating a One-Input Data Table
Creating a Two-Input Data Table
Using Goal Seek and Solver
Using Scenario Manager
Summary
Key Terms
Exercises
Case Study

Session 5: Presenting Your Data

Session Outline
Learning Objectives
Designing a Workbook
Applying Formatting
Using Custom Formats
Using Styles
Inserting Objects
Reporting Options
Summary
Key Terms
Exercises
Case Study

ADVANCED LEVEL

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