Microsoft Excel 97 with Data Disk

ISBN: 0-07-561009-4
Published: 2/01/1997
Pages: 222 with 5 Chapters
Binding: Spiral/Coil Bound

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

Instructor download files:
IRK Source Documents: Word Document (1.4 MB)
IRK Data/Solution Files: Solution Files (223 KB)
IRK PowerPoint Presentation (549 KB)
IRK Additional Test Bank: Test Bank Questions (98 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: MOUS Certified (ISBN: 007228255X)
Microsoft Excel 97: Total (Advanced) (ISBN: 007228451X)
Microsoft Excel 97: Total (Intermediate) (ISBN: 0072284501)
Microsoft Excel 97: Total (Intermediate/Advanced) (ISBN: 0256203318)
Microsoft Office 97 Professional (ISBN: 0256260044)

Other resource materials:
IRK Microsoft Excel 97 for Windows (ISBN: 0070005591)
IRK Microsoft Excel 97 for Windows w/ CDROM (ISBN: 0075616920)
IRK Brownstone Diploma Test Bank for Microsoft Office 97 (ISBN: 0073663166)

Session 1: Fundamentals

Session Outline
Introduction
Introducing Microsoft Office 97
Working with Microsoft Excel
Planning Your Worksheet
Starting Excel
Using the Mouse and Keyboard
The Guided Tour
Getting Help
Office Assistant
Moving the Cell Pointer
Overview of Data Entry
Editing a Cell
Erasing a Cell
Using the Undo Command
Saving and Closing a Workbook
Opening a Workbook
Leaving Excel
Summary
Key Terms
Exercises

Session 2: Working with Spreadsheets

Session Outline
Introduction
Creating a New Workbook
Introducing Cell Ranges
Spell-Checking a Worksheet
Data Entry Using Autocomplete
Calculating Totals
Changing Column Widths
Changing Row Heights
Formatting your Worksheet
Printing the Workbook
Summary
Key Terms
Exercises

Session 3: Increasing Your Productivity

Session Outline
Introduction
Absolute and Relative Cell Addresses
Copying and Moving Information
Creating a Series with Autofill
Inserting and Deleting Rows and Columns
Functions
Using Goal Seek
Summary
Key Terms
Exercises

Session 4: Managing a Workbook

Session Outline
Introduction
Freezing Titles
Splitting the Window into Panes
Filtering Worksheet Data
Working with Multiple Windows
Creating Multiple-Sheet Workbooks
Consolidating Your Work
What is a Macro?
Creating Macros
Summary
Key Terms
Exercises

Session 5: Creating Charts

Session Outline
Introduction
Forms of Business Graphics
Principles of Business Graphics
Chart Methods and Types
Creating a Chart
Working with Charts
Selecting a Chart Type
Customizing and Formatting a Chart
Printing a Chart
Embedding a Chart
Using Microsoft Data Map
Summary
Key Terms