Cover image for Excel 2000 for Windows for dummies
Title:
Excel 2000 for Windows for dummies
Author:
Harvey, Greg.
Personal Author:
Publication Information:
Foster City, CA : IDG Books Worldwide, [1999]

©1999
Physical Description:
xxiv, 398 pages : illustrations ; 24 cm.
General Note:
Includes index.
Language:
English
ISBN:
9780764504464
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library HF5548.4.M525 H372 1999 Adult Non-Fiction Central Closed Stacks
Searching...
Central Library HF5548.4.M525 H372 1999 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Just because electronic spreadsheets like Excel 2000 have become almost as commonplace on today's personal computers as word processors and games doesn't mean that they're either well understood or well used. Excel is a great organizer for all types of data, be they numeric, textual, or otherwise.

Excel 2000 For Windows For Dummies covers all the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets. In addition to showing you around the worksheet, this fun and friendly book exposes you to the basics of charting, creating databases, and converting spreadsheets into Web pages. Expect to pick up invaluable tips and tricks on

Creating a spreadsheet from the get-go Dressing up the look of your cells Printing your spreadsheet masterpiece Facing a database Making sense of multiple worksheets Editing your worksheet Web pages

Keeping things simple, this book cuts to the chase by telling you in plain terms just what it is that you need to do to accomplish a task using Excel. With spreadsheets as the focus, Excel 2000 For Windows For Dummies shows you how to

Launch Excel from a toolbar or browser Mess around with the menu bar Fabricate fabulous formulas Tamper with how text wraps Add hyperlinks to a worksheet Work with WordArt Customize and design your own toolbars Explore top features of Excel 2000

One look at the Excel 2000 screen (with all the boxes, buttons, and tabs), and you realize that there's a whole lot of stuff going on. With this book as your expert companion, you can tame your anxiety over the tech stuff and cell-abrate success with all the computing, text-editing, and formatting potential in this powerhouse program.


Author Notes

Greg Harvey is a prolific author of personal computing books that are highly informative, yet entertaining and easy to understand.

Harvey earned a B.A. in classics and American history from the University of Illinois in Urbana in 1970. He moved to San Francisco the following year and worked as a draftsman on civil engineering projects for the next 10 years

Harvey became interested in the growing computer field in the early 1980s. While teaching college computer classes at Golden Gate University, he wrote his first books, WordPerfect Desktop Companion (1987) and WordPerfect Instant Reference (1988). Since then, he has written, in his own words, "tons of books." These include Lotus 1-2-3 Instant Reference (1989), Encyclopedia Lotus 1-2-3 (1991), and WordPerfect 6 for Windows Quickstart (1993).

Since 1993, Harvey has written exclusively for Dummies Press of IDG Books, for whom he has turned out several personal computing classics, such as 1-2-3 for Dummies (1993), DOS for Dummies (third edition, 1998), and Excel 2000 for Windows for Dummies (1998).

(Bowker Author Biography)


Table of Contents

Introductionp. 1
About This Bookp. 1
How to Use This Bookp. 2
What You Can Safely Ignorep. 2
Foolish Assumptionsp. 2
How This Book Is Organizedp. 3
Conventions Used in This Bookp. 5
Keyboard and mousep. 5
Special iconsp. 6
Where to Go from Herep. 6
Part I Getting In on the Ground Floorp. 7
Chapter 1 What Is All This Stuff?p. 9
What the Hell Would I Do with Excel?p. 10
Little boxes, little boxesp. 10
Send it to my cell addressp. 11
So just how many cells are we talking about here?p. 13
Assigning 26 letters to 256 columnsp. 14
What you should know about Excel at this pointp. 14
What you still need to know about Excelp. 15
Getting the Darn Thing Startedp. 16
Starting Excel 2000 from the Programs or Desktop Office 2000 shortcut barp. 16
Starting Excel 2000 from the Windows 95/98 Start Menup. 17
Starting Excel 2000 from the Windows Explorerp. 18
Creating an Excel 2000 shortcutp. 19
Automatically opening Excel every time you turn on your computerp. 20
Mousing Aroundp. 21
Minding your mouse mannersp. 22
Getting your mouse pointer in shapep. 22
So What Do All These Buttons Do?p. 24
Turning on to the title barp. 24
Messing around with the menu barp. 25
Scrutinizing the Standard and Formatting toolbarsp. 26
Fumbling around the formula barp. 30
Winding your way through the workbook windowp. 33
Manually manipulating the workbook windowp. 34
Slipping through the sheetsp. 35
Scoping out the status barp. 36
You AutoCalculate my totalsp. 37
The Num Lock indicator and the numeric keypadp. 37
You Gotta Get Me Out of This Cell!p. 37
The secrets of scrollingp. 38
Calling up new columns with the horizontal scroll barp. 38
Raising up new rows with the vertical scroll barp. 38
Scrolling from screen to screenp. 39
Scrolling with the IntelliMousep. 39
The keys to moving the cell pointerp. 41
Block movesp. 42
When you gotta go to that cell right now!p. 43
Lotsa luck with Scroll Lockp. 44
Ordering Directly from the Menusp. 44
Penetrating the pull-down menusp. 44
Now you see 'em, now you don'tp. 46
Comprehending shortcut menusp. 47
Digging Those Dialog Boxesp. 49
Ogling the Online Helpp. 53
Conferring with your Office Assistantp. 53
Things to do when Clippit doesn't understand youp. 55
Putting Clippit back in his drawerp. 56
Choosing a new persona for the Office Assistantp. 56
Taking tips from the Office Assistantp. 57
Carving out context-sensitive Helpp. 58
Tackling the Help topicsp. 58
When It's Time to Make Your Exitp. 59
Chapter 2 Creating a Spreadsheet from Scratchp. 61
So What Ya Gonna Put in That New Workbook of Yours?p. 62
The ins and outs of data entryp. 62
You must remember thisp. 63
Doing the Data-Entry Thingp. 63
It Takes All Typesp. 66
The telltale signs of textp. 66
How Excel evaluates its valuesp. 67
Making sure that Excel's got your numberp. 68
How to get your decimal places fixed (when you don't even know if they're broken)p. 69
Tapping on the old ten-keyp. 71
Entering dates with no debatep. 72
"All the way in Y2K!"p. 73
Fabricating those fabulous formulas!p. 74
If you want it, just point it outp. 78
Altering the natural order of operationsp. 78
Formula flub-upsp. 79
Fixing Up Those Data Entry Flub-upsp. 80
You really AutoCorrect that for mep. 81
Cell editing etiquettep. 82
Taking the Drudgery Out of Data Entryp. 84
I'm just not complete without youp. 84
Fill 'er up with AutoFillp. 86
Working with a spaced seriesp. 87
Copying with AutoFillp. 88
Creating custom lists for AutoFillp. 89
Entries all around the blockp. 90
Data entry expressp. 91
How to Make Your Formulas Function Even Betterp. 92
Inserting a function into a formula with the Paste Function and the Formula Palettep. 93
Editing a function with the Edit Formula buttonp. 96
I'd be totally lost without AutoSump. 97
Making Sure the Data's Safe and Soundp. 99
Part II Editing without Tearsp. 103
Chapter 3 Making It All Look Prettyp. 105
Choosing a Select Group of Cellsp. 106
Point-and-click cell selectionsp. 107
Shifty cell selectionsp. 107
Nonadjacent cell selectionsp. 108
Going for the "big" cell selectionsp. 108
Selecting the cells in a table of data, courtesy of AutoSelectp. 108
Keyboard cell selectionsp. 110
Extend that cell selectionp. 111
AutoSelect keyboard stylep. 111
Nonadjacent cell selections with the keyboardp. 112
Cell selections a la Go Top. 112
Trimming Your Tables with AutoFormatp. 113
Festooning Your Cells with the Formatting Toolbarp. 116
Transient toolbarsp. 116
Toolbar docking maneuversp. 118
Using the Format Cells Dialog Boxp. 119
Getting to know the number formatsp. 120
Currying your cells with Currency Stylep. 121
"Look Ma, no more format overflow!"p. 122
Currying your cells with the Comma Stylep. 122
Playing around with the Percent Stylep. 123
Deciding how many decimal placesp. 124
The values behind the formattingp. 125
Ogling the other number formatsp. 126
Sorting through the Special number formatsp. 126
Creating custom number formatsp. 127
Calibrating Columnsp. 128
Rambling rowsp. 130
Now you see it, now you don'tp. 131
Hiding columns and rows, courtesy of the pull-down and shortcut menusp. 131
Hiding columns and rows with the mousep. 132
Futzing with the Fontsp. 133
Altering the Alignmentp. 134
Intent on Indentsp. 136
From top to bottomp. 136
Tampering with how the text wrapsp. 137
Reordering the orientationp. 138
Shrink to fitp. 140
Bring on the borders!p. 141
Putting on new patternsp. 142
Showing Off in Stylesp. 144
Fooling Around with the Format Painterp. 146
Conditional Formattingp. 147
Chapter 4 Going through Changesp. 151
Opening the Darned Thing Up for Editingp. 152
Opening more than one workbook at a timep. 152
Opening recently edited workbooks from the File menup. 153
When you don't know where to find themp. 154
Searching the wide disk overp. 154
Playing favoritesp. 155
File hide-and-seekp. 155
Making a positive IDp. 158
Opening files with a twistp. 159
Much Ado about Undop. 160
Undo is Redo the second time aroundp. 160
What ya gonna do when you can't Undo?p. 161
Doing the Old Drag-and-Drop Thingp. 162
Copies, drag-and-drop stylep. 163
Insertions courtesy of drag and dropp. 164
Formulas on AutoFillp. 166
Relatively speakingp. 167
Some things are absolutes!p. 168
Cut and paste, digital stylep. 171
Paste it again, Samp. 172
So what's so special about Paste Special?p. 174
Let's Be Clear about Deleting Stuffp. 175
Sounding the all clear!p. 176
Get these cells outta here!p. 176
Kindly Step Asidep. 177
Stamping Out Your Spelling Errorsp. 178
Chapter 5 Printing the Masterpiecep. 181
Starting the Show with Print Previewp. 182
The Page Stops Herep. 185
Printing it right awayp. 185
Printing it your wayp. 186
Printing in particularp. 187
Setting and clearing the Print Areap. 188
My Page Was Setup!p. 188
Getting the lay of the landscapep. 190
Packing it all on one pagep. 190
Massaging the marginsp. 191
From header to footerp. 193
Getting a standard jobp. 193
Getting a custom jobp. 195
Sorting out the sheet settingsp. 197
Putting out the print titlesp. 199
When Ya Gonna Give Your Page a Break?p. 201
Letting Your Formulas All Hang Outp. 204
Part III Getting Organized and Staying That Wayp. 205
Chapter 6 Oh, What a Tangled Worksheet We Weave!p. 207
Zeroing In with Zoomp. 208
Splitting the Differencep. 210
Fixed Headings Courtesy of Freeze Panesp. 213
Electronic Sticky Notesp. 216
Adding a comment to a cellp. 216
Comments in reviewp. 217
Editing the comments in a worksheetp. 219
Getting your comments in printp. 220
The Cell Name Gamep. 220
If I only had a namep. 220
Name that formula!p. 221
Naming formulas with data table headingsp. 222
"Seek and Ye Shall Find ..."p. 224
You Can Be Replaced!p. 226
You Can Be So Calculatingp. 227
Putting On the Protectionp. 228
Chapter 7 Maintaining Multiple Worksheetsp. 231
Juggling Worksheetsp. 232
Sliding between the sheetsp. 232
Editing en massep. 235
Don't Short-Sheet Me!p. 236
A sheet by any other namep. 238
Getting your sheets in orderp. 239
Opening Windows on Your Worksheetsp. 240
Passing Sheets in the Nightp. 245
To Sum Upp. 247
Part IV Life beyond the Spreadsheetp. 251
Chapter 8 The Simple Art of Making Chartsp. 253
Conjuring Up Charts with the Chart Wizardp. 254
Moving and resizing a chart in a worksheetp. 259
Changing the chart with the Chart toolbarp. 260
Editing the chart directly in the worksheetp. 262
Changing the Chart Optionsp. 264
Telling all with a text boxp. 265
Formatting the x- or y-axisp. 267
Vacillating values mean changing chartsp. 268
Changing perspectivesp. 269
Picture This!p. 270
Getting clip art onlinep. 272
Drawing your ownp. 273
Working with WordArtp. 274
One on Top of the Otherp. 276
Nixing the Graphicsp. 277
Printing Charts Onlyp. 278
Chapter 9 How to Face a Databasep. 279
Designing the Data Formp. 280
Adding records to the databasep. 282
Adding e-mail and Web addresses to a hyperlink fieldp. 285
Locating, changing, and deleting recordsp. 287
Scrolling the night away!p. 288
Finders keepersp. 289
Sorting It All Outp. 292
You AutoFilter the Database to See the Records You Wantp. 296
Viewing the top ten recordsp. 297
Getting creative with custom AutoFiltersp. 298
Chapter 10 Of Hyperlinks and Web Pagesp. 301
Adding Hyperlinks to a Worksheetp. 302
Follow those hyperlinks!p. 306
Editing and formatting hypertext linksp. 310
Editing and formatting graphics with hyperlinksp. 311
Spreadsheets on the Web?p. 312
Saving a static Web pagep. 314
Saving an interactive Web pagep. 316
Acting out with interactive worksheet datap. 318
Acting up with an interactive databasep. 323
Acting on an interactive chartp. 326
Adding worksheet data to an existing Web pagep. 328
Editing your worksheet Web pagesp. 329
Editing a worksheet Web page in Excel 2000p. 331
Exporting an interactive Web page to Excelp. 332
"Drag and drop tables, anyone?"p. 333
Previewing and Publishing Your Web Pagesp. 334
Previewing Web pages with your browserp. 335
Creating Web folders for publishing your Web pagesp. 336
Setting up FTP locations for publishing your Web pagesp. 338
Sending Worksheets via E-Mailp. 341
Part V Doing a Custom Jobp. 345
Chapter 11 Macros Like Your Mom Used to Makep. 347
Recording Macrosp. 348
Personally Speakingp. 349
A Macro a Dayp. 349
It's playback time!p. 352
A macro for all monthsp. 353
Relative macro recordingp. 355
Re-recording a macrop. 356
Chapter 12 Button Up That Toolbar!p. 357
Toolbars--Now You See 'em, Now You Don'tp. 358
Customizing the Built-In Toolbarsp. 360
Adding buttons from the Customize dialog boxp. 360
Removing buttons from a toolbarp. 361
Playing musical chairs with buttonsp. 362
What a bunch of spaced-out buttons!p. 362
It's not my default!p. 362
Designing Your Own Toolbarsp. 363
Adding custom buttons that play macrosp. 365
Assigning a macro to a menu itemp. 367
Assigning a hyperlink to a custom buttonp. 368
Cute as a buttonp. 370
Part VI The Part of Tensp. 373
Chapter 13 Top Ten New Features in Excel 2000p. 375
Chapter 14 Top Ten Beginner Basicsp. 377
Chapter 15 The Ten Commandments of Excel 2000p. 379
Indexp. 381
Book Registration Information

Google Preview