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 |