Microsoft Excel 97: Total (Intermediate)

ISBN: 0-07-228450-1
Published: 8/10/1998
Pages: 293 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: Intermediate (1.3 MB)
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/Advanced) (ISBN: 0256203318)

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

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