Skip to:Content
|
Bottom
Cover image for Microsoft Excel 2002 : complete
Title:
Microsoft Excel 2002 : complete
Personal Author:
Series:
The I-series
Publication Information:
New York : McGraw-Hill/Irwin, 2002
ISBN:
9780072459067
Added Author:

Available:*

Library
Item Barcode
Call Number
Material Type
Item Category 1
Status
Searching...
30000010023366 HF5548.4.M523 H32 2002 Open Access Book Book
Searching...

On Order

Summary

Summary

A manual on Excel 2002, written in a learn-by-doing manner. Like other titles in The I-Series, it presents step-by-step instructions, along with discussion of why the steps are important and what role they play in the overall plan for creating a document, workbook or database.


Table of Contents

About the I-Series
Your Guide to the I-Series
Common Microsoft Office XP Features
Introduction
Session 1.1 Introducing Microsoft Office XP
Making the Grade
Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Chapter 1 Creating Worksheets for Decision Makers
Chapter Case: Western University Rugby Team
Session 1.1 Getting Started
Introduction to Excel
Starting Excel and Opening a Worksheet
Anatomy of the Excel Window
Moving Around a Worksheet
Moving from Sheet to Sheet
Opening an Existing Workbook
Making the Grade
Session 1.2 Entering Data, Saving Workbooks, and Printing Worksheets
Excel Data Types
Entering Text, Values, Formulas, and Functions
Editing Cell Entries
Saving a Workbook
Getting Help
Clearing Cells
Conducting What-If Analysis
Printing a Worksheet
Closing a Workbook
Exiting Excel
Making the Grade
Session 1.3 Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 2 Planning and Creating A Worksheet
Chapter Case: Intercity Recycling Contest
Session 2.1 Writing Formulas, Using Functions, and Copying and Moving Cell Contents
Creating Workbooks
Building a Worksheet
Writing Formulas
Using Excel Functions
Copying Formulas to Save Time
Moving Text, Values, and Formulas
Renaming a Worksheet
Spell-Checking a Worksheet
Saving Your Modified Workbook
Making the Grade
Session 2.2 Formatting Cells, Print Setup, and Printing
Stress Testing a Worksheet
Modifying a Worksheet's Appearance
Adjusting Page Settings
Documenting the Workbook
Making the Grade
Session 2.3 Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 3 Formatting A Worksheet
Chapter Case: the Exotic Fruit Company
Session 3.1 Aligning Data and Applying Character Formats
Locating and Opening the Workbook
Formatting Data
Formatting Numeric Entries
Other Number Formats
Aligning Data
Changing Font and Font Characteristics
Making the Grade
Session 3.2 Advanced Formatting
Controlling Row Heights
Employing Borders, a Text Box, an Arrow, and Shading
Hiding and Unhiding Rows and Columns
Using Color for Emphasis
Controlling Gridlines
Printing
Making the Grade
Session 3.3 Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 4 Creating Charts
Chapter Case: Big Wave Surfboards
Session 4.1 Creating an Excel Chart
Data Series and Categories
Locating and Opening the Workbook
Choosing a Chart Type and Format
Creating an Embedded Column Chart
Moving and Resizing an Embedded Chart
Updating a Chart
Modifying a Chart
Embellishing a Chart
Previewing and Printing a Chart
Making the Grade
Session 4.2 Modifying and Improving A Chart
Creating a Chart in a Chart Sheet
Changing the Chart Type
Formatting Chart Text
Adding Texture for Emphasis
Saving and Printing a Chart Sheet
Deleting Charts
Saving a Chart as a Web Page
Creating a Bar Chart
Making the Grade
Session 4.3 Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands on Projects
Running Project
Chapter 5 Exploring Excel's List Features
Chapter Case: Computer Security, Inc.
Session 5.1 Creating and Using Lists
Building a List
Freezing Rows and Columns
Using a Data Form to Maintain a List
Locating and Modifying Data with Find and Replace
Sorting Data
Changing the Zoom Setting of a Worksheet
Making the Grade
Session 5.2 Creating Filters and Subtotals
Using Filters to Analyze a List
Using Subtotals to Analyze a List
Applying Conditional Formatting
Making the Grade
Session 5.3 Creating and Using Pivot Tables
Pivot Table Basics
Creating a Pivot Table with a Pivot Table Wizard
Designing the Pivot Table Layout
Changing the Formatting of a Pivot Table
Rotating Pivot Table Fields
Removing and Adding Pivot Table Fields
Hiding Field Items
Using Page Fields
Refreshing a Pivot Table
Creating a Chart from a Pivot Table
Making the Grade
Session 5.4 Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 6 Common Functions
Chapter Case: Cal Whittington Automobiles
Session 6.1 Using Data Validation, Names, and if and Index Functions
Introduction to Functions
Working with Functions
Organizing a Worksheet into Sections
Providing an Assumptions Framework
Supplying Data Validation
Defining Names
Using Names in Formulas
Using IF and Index Functions
Making the Grade
Session 6.2 Using Financial Functions
Using Financial Analysis Functions
Building Total Principal, Total Interest, and Ending Balance Formulas
Using Autofill to Complete a Series of Related Formulas
Making the Grade
Session 6.3 Maintaining and Protecting Worksheets and Using Date Functions
Maintaining Worksheets
Working with Date Functions
Protecting Worksheet Cells and Worksheets
Making the Grade
Session 6.4 Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 7 Integrating Excel and Office Objects
Chapter Case: Avicon International Art Treasures
Session 7.1 Linking Excel and Word
Introduction
Integrating Information from Different Products
Designing an Integrated Document
Pasting an Object into an Excel Worksheet
Mailing a Workbook as an E-Mail Attachment
Pasting an Object into a Word Document
Embedding an Excel Chart into a Word Document
Linking an Excel Worksheet and a Word Document
Making the Grade
Session 7.2 Merging an Excel List Into A Word Document
Designing and Creating a Letter Linked to an Excel List
Merging Source Data into the Container Document
Previewing Merged Data
Adding Merge Fields in Other Locations in the Document
Filtering and Sorting Source Records
Creating and Printing Merged Documents
Saving Crucial Files and Deleting Unneeded Ones
Making the Grade
Session 7.3 Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 8 Developing Multiple Worksheet and Workbook Applications
Chapter Case: Bridgewater Engineering Company (BECO)
Session 8.1 Working With Multiple Worksheets
Using Multiple Worksheets
Combining Multiple Worksheets into One Workbook
Adding a Worksheet to a Workbook
Grouping Worksheets
Naming Cell Ranges to Speed Worksheet Access
Consolidating and Summarizing Data with 3-D Formulas
Printing Multiple Worksheets
Making the Grade
Session 8.2 Working With Multiple Workbooks
Retrieving Data from Other Workbooks
Making the Grade
Session 8.3 Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 9 Using Data Tables and Scenarios
Chapter Case: Artistic Furniture Corporation
Session 9.1 Creating and Using Data Tables
Creating an Income Statement
Determining the Break-Even Point
Performing What-If Analysis with a One-Variable Data Table
Performing What-If Analysis with a Two-Variable Data Table
Editing Data Tables
Making the Grade
Session 9.2 Creating and Using Scenarios
Doing More Complex What-If Analysis with Scenario Manager
Creating Scenario Reports
Making the Grade
Session 9.3 Summary
Mous Objectives Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 10 Using the Solver
Chapter Case: Exercycle
Session 10.1 Using Goal Seek
Designing a Goal-Seeking Workbook
Formatting and Protecting the Documentation Worksheet
Creating a Goal Seek Worksheet
Using the Goal Seek Command
Making the Grade
Session 10.2 Solving Complex Problems
Introducing the Problem
Introducing the Solver
Installing the Solver
Formulating the Problem Concisely
Solving More Difficult Problems Using Trial and Error
Using the Solver
Saving Solver Parameters
Creating Reports with the Solver
Making the Grade
Session 10.3 Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 11 Importing Data
Chapter Case: Mission Bay Boat Works
Session 11.1 Importing Text Data and Web Data
Importing Text Files Into Excel
Working With a Fixed Length Data File
Working With a Comma-Separated Values Text File
Moving, Copying and Pasting Data between Workbooks
Formatting and Sorting the Imported Data
Copying and Pasting Data From a Web Page
Making the Grade
Session 11.2 Using Queries to Import Database Data
Retrieving Data From Databases
Using the Excel Query Wizard
Using Microsoft Query
Making the Grade
Session 11.3 Summary
Mous Objectives Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
Chapter 12 Automating Applications With Visual Basic
Chapter Case: King's Stained Glass Studio
Session 12.1 Creating Macros
What is a Macro?
Why Bother Creating a Macro?
Deciding Which Macros You Need
Recording a Macro
Running a Macro
Recording Macros for the Other Product Worksheets
Creating and Running Macros Stored in the Personal Macro Workbook
Setting the Macro Security Level
Opening a Workbook Containing Macros
Making the Grade
Session 12.2 Writing Subroutines and Custom Functions
Examining the Visual Basic Editor
Writing Subroutines
Writing Custom Functions
Making the Grade
Session 12.3 Summary
Mous Objectives Summary
Task Reference Roundup
Level 1 Review of Terminology
Level 2 Review of Concepts
Level 3 Hands-on Projects
Running Project
End-of-Book
Reference 1 Excel File Finder
Reference 2 Mous Certification Guide
Reference 3 Task Reference Roundup
Reference 4 Making the Grade Answers
Glossary
Glossary for Common Microsoft Office Features
Index
Go to:Top of Page