Microsoft Excel 95 for Windows (ver.7.0)

ISBN: 0-256-22049-2
Published: 5/01/1996
Pages: 238 with 5 Chapters
Binding: Spiral/Coil Bound

Student download files:
Student Data Files (178 KB)

Instructor download files:
IRK Data/Solution Files: Solution Files (130 KB)

Miscellaneous Web resources:
Check for MHHE Catalog Listing

Related tutorials for students:
Advantage Interactive: Excel 95 CD-ROM (ISBN: 025623325X)
Microsoft Excel 95 (ver.7.0) w/ Data Disk (ISBN: 0256232423)
Microsoft Excel 97 for Windows (ISBN: 0256259976)
Microsoft Office 95 Professional with Windows 95 (ISBN: 0256220557)

Other resource materials:
IRK Microsoft Excel 7.0 for Windows w/ 3.5" Disk (ISBN: 0256233969)

Session 1: Fundamentals

Session Outline
Introduction
Working with Electronic Spreadsheets
Planning Your Spreadsheet
The Windows Advantage
Introducing Microsoft Office 95
Features of Microsoft Excel 7.0
Working With Microsoft Excel
Starting Excel
The Guided Tour
Getting Help
Moving the Cell Pointer
Overview of a Data Entry
Editing a Cell
Erasing a Cell
Using the Undo Command
Saving, Closing, and Opening Workbooks
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 Tools
Changing Column Widths
Changing Row Heights
Formatting Your Worksheet
Printing the Workbook
Summary
Key Terms
Exercises

Session 3: Increasing Your Productivity

Session Outline
Introduction
Using Templates
Absolute and Relative Cell Addresses
Copying and Moving Information
Creating a Series with Autofill
Inserting and Deleting Rows and Columns
Functions
Using Goal Seek
Circular References: Avoiding Them
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
Using Excel to Create Charts
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
Exercises