Microsoft Excel Version 2002 Step by Step

by Microsoft Corporation

• ISBN13: 9780735612969
• ISBN10: 073561296X
• Edition: 1st
• Format: Paperback
• Copyright: 2001-06-06
• Publisher: Microsoft Press
• More Book Details
• Purchase Benefits

Summary

Microsoft Excel provides one of the most complete sets of analysis tools in any spreadsheet. Excel version 2002 simplifies existing features and offers new tools that help the user work faster and smarter, with better Web integration and collaboration capabilities, and comprehensive tools for creating and analyzing, and sharing spreadsheet information. Microsoft Excel Version 2002 Step by Step offers self-paced instruction to the beginning-to-advanced user who wants to get the most out of Excel Version 2002, and prepare for Microsoft Office User (MOUS) certification. This personal training system offers easy-to-follow lessons full of clear objectives, a wealth of task-oriented procedures, and dozens of real-world business scenarios. Each Step By Step title consists of friendly, straightforward instruction with dozens of full- colour screenshots and illustrations to help you learn exactly what you need to know at your own pace.

Author Biography

Curtis Frye is the author of numerous books on Excel and other Office products, most recently the Excel 2007 Pocket Guide. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

Table of Contents

What's New in Microsoft Excel 2002	p. vii
Getting Help	p. ix
Using the Book's CD-ROM	p. xi
Conventions and Features	p. xv
MOUS Objectives	p. xvii
Taking a MOUS Exam	p. xxi
Getting to Know Excel	p. 1
Introducing Excel	p. 2
Working with an Existing Data List	p. 4
Zeroing In on Data in a List	p. 5
Creating a Workbook	p. 10
Checking and Correcting Data	p. 16
Setting Up a Workbook	p. 22
Making Workbooks Easier to Work With	p. 23
Making Data Easier to Read	p. 28
Adding a Graphic to a Document	p. 31
Performing Calculations on Data	p. 34
Naming Groups of Data	p. 35
Creating Formulas to Calculate Values	p. 38
Finding and Correcting Errors in Calculations	p. 44
Changing Document Appearance	p. 48
Changing the Appearance of Data	p. 50
Applying an Existing Format to Data	p. 53
Making Numbers Easier to Read	p. 56
Changing Data's Appearance Based on Its Value	p. 60
Making Printouts Easier to Follow	p. 64
Positioning Data on a Printout	p. 68
Focusing on Specific Data Using Filters	p. 72
Limiting the Data That Appears on the Screen	p. 73
Performing Calculations on Filtered Data	p. 78
Defining a Valid Set of Values for a Range of Cells	p. 80
Combining Data from Multiple Sources	p. 84
Using a Data List as a Template for Other Lists	p. 86
Working with More Than One Set of Data	p. 88
Linking to Data in Other Workbooks	p. 93
Summarizing Multiple Sets of Data	p. 96
Grouping Multiple Data Lists	p. 100
Reordering and Summarizing Data	p. 102
Sorting a Data List	p. 104
Organizing Data into Levels	p. 108
Analyzing Alternative Data Sets	p. 114
Defining and Editing Alternative Data Sets	p. 116
Defining Multiple Alternative Data Sets	p. 119
Varying Your Data to Get a Desired Result	p. 123
Creating Dynamic Lists with PivotTables	p. 126
Creating Dynamic Lists with PivotTables	p. 127
Editing PivotTables	p. 134
Creating PivotTables from External Data	p. 141
Creating Charts	p. 148
Creating a Chart	p. 149
Customizing Chart Labels and Numbers	p. 156
Finding Trends in Your Data	p. 158
Creating a Dynamic Chart Using PivotCharts	p. 161
Printing	p. 168
Printing Data Lists	p. 169
Printing Part of a Data List	p. 177
Printing a Chart	p. 181
Automating Repetitive Tasks with Macros	p. 186
Introducing Macros	p. 188
Creating and Modifying Macros	p. 192
Creating a Toolbar to Hold Macros	p. 194
Creating a Menu to Hold Macros	p. 198
Running a Macro When a Workbook Is Opened	p. 201
Working with Other Microsoft Office Programs	p. 204
Including an Office Document in an Excel Worksheet	p. 206
Storing an Excel Document as Part of Another Office Document	p. 209
Creating a Hyperlink	p. 211
Pasting a Chart into Another Document	p. 215
Working with Database Data	p. 218
Looking Up Information in a Data List	p. 219
Retrieving Data from a Database	p. 223
Publishing Information on the Web	p. 230
Saving a Workbook for the Web	p. 232
Publishing Worksheets on the Web	p. 234
Publishing a PivotTable on the Web	p. 237
Retrieving Data from the Web	p. 240
Acquiring Web Data with Smart Tags	p. 243
Working with Structured Data	p. 245
Collaborating with Colleagues	p. 248
Sharing a Data List	p. 250
Managing Comments	p. 253
Tracking and Managing Colleagues' Changes	p. 254
Identifying Which Revisions to Keep	p. 258
Protecting Workbooks and Worksheets	p. 260
Quick Reference	p. 267
Getting to Know Excel	p. 267
Setting Up a Workbook	p. 269
Performing Calculations on Data	p. 271
Changing Document Appearance	p. 272
Focusing on Specific Data Using Filters	p. 275
Combining Data from Multiple Sources	p. 277
Reordering and Summarizing Data	p. 279
Analyzing Alternative Data Sets	p. 280
Creating Dynamic Lists with PivotTables	p. 282
Creating Charts	p. 284
Printing	p. 287
Automating Repetitive Tasks with Macros	p. 290
Working with Other Microsoft Office Programs	p. 293
Working with Database Data	p. 294
Publishing Information on the Web	p. 296
Collaborating with Colleagues	p. 298
Glossary	p. 303
Index	p. 307
Table of Contents provided by Syndetics. All Rights Reserved.