Cover image for Excel 2002 for Windows
Title:
Excel 2002 for Windows
Author:
Langer, Maria.
Personal Author:
Publication Information:
Berkeley, CA : Peachpit Press, [2002]

©2002
Physical Description:
xiv, 305 pages : illustrations ; 23 cm.
Language:
English
ISBN:
9780201758443
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Item Holds
Searching...
HF5548.4.M523 L3628 2002 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Featuring instructions and screen shots to guide students and teachers through important tasks, these visual reference guides are for any course in Digital Graphics, Web Design, Web Scripting and Development, Multimedia, Page Layout, Office Tools, and Operating Systems. They are used for intermediate and advanced students as a quick references.


Author Notes

Maria Langer is the author of Excel 2000 for Windows: Visual QuickStart Guide (0-201-35427-6), and she has written more than a dozen other computer books, including the newly-released Mac OS X: Visual QuickStart Guide (0-201-70900-7). When not writing books, she can be found terrorizing the skies of Arizona in her helicopter.


Table of Contents

Introduction to Excel 2002p. xi
Introductionp. xi
New and Improved Features in Excel 2002p. xii
Chapter 1 The Excel Workplacep. 1
Meet Microsoft Excelp. 1
The Excel Screenp. 2
The Mousep. 4
Menusp. 5
Shortcut Keysp. 7
Toolbarsp. 8
The Task Panep. 11
Dialogsp. 12
Scrolling Window Contentsp. 14
The Office Assistantp. 15
Excel Helpp. 17
Chapter 2 Worksheet Basicsp. 21
How Worksheets Workp. 21
Running Excelp. 22
Exiting Excelp. 23
Creating a New Workbookp. 24
Activating and Selecting Cellsp. 26
Entering Values and Formulasp. 30
Valuesp. 31
Formula Basicsp. 32
Error Checking Smart Tagp. 35
Chapter 3 Editing Worksheetsp. 37
Editing Worksheetsp. 37
Editing Cell Contentsp. 38
Inserting and Deleting Cellsp. 40
Copying Cellsp. 43
Copying with Copy and Pastep. 44
The Fill Handlep. 45
The Fill Commandp. 46
Series and AutoFillp. 47
Copying Formulasp. 48
Relative vs. Absolute Cell Referencesp. 49
Mixed Referencesp. 50
Moving Cellsp. 51
The Office Clipboardp. 53
Undoing, Redoing, and Repeating Actionsp. 55
Chapter 4 Working with Filesp. 57
Excel Filesp. 57
Workbook Sheetsp. 57
Workbook Windowsp. 63
Saving Filesp. 68
Opening Existing Filesp. 70
Chapter 5 Using Functions in Formulasp. 71
Functionsp. 71
Anatomy of a Functionp. 71
Argumentsp. 72
Entering Functionsp. 73
Math and Trig Functionsp. 77
Statistical Functionsp. 83
Financial Functionsp. 86
Logical Functionsp. 91
Lookup and Reference Functionsp. 92
Information Functionsp. 93
Date and Time Functionsp. 94
Text Functionsp. 96
Chapter 6 Formatting Cellsp. 99
Formatting Basicsp. 99
Number Formattingp. 100
Alignmentp. 103
Font Formattingp. 108
Bordersp. 111
Cell Shadingp. 113
Stylesp. 114
Conditional Formattingp. 115
The Format Painterp. 116
Column Width and Row Heightp. 117
AutoFitp. 120
AutoFormatp. 121
Removing Formatting from Cellsp. 122
Chapter 7 Working with Graphic Objectsp. 123
Graphic Objectsp. 123
The Drawing Toolbarp. 124
Drawing Objectsp. 125
Inserting Picturesp. 129
Working with Graphic Objectsp. 133
Stacking Orderp. 142
Chapter 8 Creating Chartsp. 143
Chartsp. 143
The Chart Wizardp. 143
Worksheet and Chart Linksp. 148
Data Series and Pointsp. 149
Chart Elementsp. 153
Chart Typep. 154
Chart Optionsp. 156
Titlesp. 157
Axesp. 158
Gridlinesp. 159
Legendp. 160
Data Labelsp. 161
Data Tablep. 162
Formatting Chart Elementsp. 163
Other Formatting Optionsp. 167
Chapter 9 Printingp. 169
Printingp. 169
The Page Setup Dialogp. 170
Print Previewp. 178
The Print Dialogp. 181
Chapter 10 Working with Listsp. 183
List Basicsp. 183
Using the Data Formp. 185
AutoFilterp. 187
Advanced Filtersp. 189
Sortingp. 190
Subtotalsp. 192
Database Functionsp. 194
Chapter 11 Working with Othersp. 195
Collaboration Featuresp. 195
Document Propertiesp. 196
Commentsp. 198
Revision Trackingp. 200
Document Protectionp. 203
Save Options and Password Protectionp. 208
Workbook Sharingp. 210
Chapter 12 Using Other Programsp. 213
Using Excel with Other Programsp. 213
OLE Objectsp. 214
Using Word with Excelp. 217
Using Outlook with Excelp. 220
Chapter 13 Advanced Techniquesp. 223
Advanced Techniquesp. 223
Namesp. 224
3-D Referencesp. 230
Opening Worksheets with Linksp. 235
Consolidationsp. 236
Custom Viewsp. 239
Macrosp. 241
Chapter 14 Web Publishingp. 243
Web Publishingp. 243
Creating Web Pagesp. 245
Hyperlinksp. 251
Chapter 15 Setting Excel Optionsp. 255
The Options Dialogp. 255
View Optionsp. 257
Calculation Optionsp. 259
Edit Optionsp. 261
General Optionsp. 263
Transition Optionsp. 266
Custom Lists Optionsp. 268
Chart Optionsp. 270
Color Optionsp. 271
International Optionsp. 272
Save Optionsp. 273
Error Checking Optionsp. 274
Spelling Optionsp. 275
Security Optionsp. 276
Appendix A Menus and Shortcut Keysp. 279
Menus and Shortcut Keysp. 279
File Menup. 280
Edit Menup. 280
View Menup. 281
Insert Menup. 281
Format Menup. 282
Tools Menup. 282
Chart Menup. 283
Data Menup. 283
Window Menup. 284
Help Menup. 284
Appendix B Function Referencep. 285
Functionsp. 285
Financial Functionsp. 285
Date and Time Functionsp. 286
Math and Trig Functionsp. 286
Statistical Functionsp. 288
Lookup and Reference Functionsp. 292
Database Functionsp. 292
Text Functionsp. 293
Logical Functionsp. 294
Information Functionsp. 294
Indexp. 297