9780470045947

The Unofficial Guide to Microsoft Office Excel 2007

by ;
  • ISBN13:

    9780470045947

  • ISBN10:

    0470045949

  • Edition: 1st
  • Format: Paperback
  • Copyright: 2007-02-05
  • Publisher: Wiley

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $18.99 Save up to $4.75
  • Buy Used
    $14.24

    USUALLY SHIPS IN 2-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

Summary

The inside scoop...for when you want more than the official line! Microsoft Office Excel 2007 may be just what you need to crunch numbers, but to use it with confidence, you'll need to know its quirks and shortcuts. Find out what the manual doesn't always tell you in this insider's guide to using Excel in the real world. What are the secrets of pro users? Are there shortcuts for repetitive tasks? From writing formulas to using charts, first get the official way, then the best way from two experts. Unbiased coverage of how to get the most out of Excel 2007, from creating workbooks and writing formulas to comparing data Savvy, real-world advice to help you set up, enter, format, and organize your data Time-saving techniques and practical guidance on creating custom macros with VBA and using PivotTables and PivotCharts Tips and hacks with practical ways to save time, avoid pitfalls, and increase your output Sidebars, tables, and illustrations featuring toolbar buttons and more ways to be productive in Excel Watch for these graphic icons in every chapter to guide you to specific practicalinformation. Bright Ideas are smart innovations that will save you time or hassle. Hacks are insider tips and shortcuts that increase productivity. When you see Watch Out! heed the cautions or warnings to help you avoid commonpitfalls. And finally, check out Inside Scoops for practical insights from the author. It's like having your own expert at your side!

Author Biography

Julia Kelly lives in rural north Idaho with horses, cats, small garden dogs, assorted wild animals, free-range chickens, and bird dogs who’ve finally learned not to “retrieve” the free-range chickens.

Curt Simmons lives in Saint Jo, Texas, with his wife and two daughters. The author of more than 50 computing books on a wide range of topics, he primarily writes about Microsoft products. When he is not writing, Curt enjoys gardening and working on his 107-year-old home.

Table of Contents

Starting Out with Excel 2007p. 1
Getting In and Outp. 3
Starting Excelp. 3
The Excel environmentp. 4
Getting helpp. 10
Opening workbook filesp. 14
Using hyperlinksp. 17
Saving workbook filesp. 18
Creating and using templatesp. 21
Closing workbook filesp. 24
Quitting Excelp. 25
Just the factsp. 25
All About Worksheetsp. 27
Worksheet basicsp. 28
Selecting worksheetsp. 29
Naming worksheetsp. 31
Color-coding workbook contentsp. 32
Rearranging worksheetsp. 33
Adding and deleting worksheetsp. 35
Moving around in a worksheetp. 37
Multiple windowsp. 42
Zooming your viewp. 45
Just the factsp. 46
Crunching Numbersp. 47
Entering and Editing Datap. 49
Entering data directlyp. 49
Using data entry techniquesp. 52
Creating a dynamic list/tablep. 65
Validating data during entryp. 67
Editing cell entriesp. 69
Finding and replacing datap. 70
Moving and copying datap. 73
Inserting, deleting, and rearrangingp. 76
Breaking a column into multiple columnsp. 80
Adding worksheet commentsp. 81
Checking your spellingp. 82
Just the factsp. 84
Working Data Magic with Calculationsp. 85
Simple calculations, quick answersp. 85
About cell referencesp. 89
Writing formulasp. 92
Moving and copying formulasp. 94
Linking worksheets and workbooksp. 96
Using cell namesp. 98
Editing formulasp. 105
Tracing a formulap. 106
Locating worksheet errorsp. 108
Just the factsp. 110
Excel Functionsp. 111
Using functionsp. 111
Common and useful functionsp. 114
Combining functions for more powerp. 132
Just the factsp. 139
Dressing Up Your Datap. 141
Formatting Cellsp. 143
The Font and Alignment Ribbon groupsp. 143
Formatting the fontp. 144
Working with bordersp. 146
Adding colorsp. 148
Fitting the text in the cellp. 152
Copying formatting with Format Painterp. 160
Just the factsp. 161
Formatting Numbers and Using Stylesp. 163
Applying number formats to cellsp. 163
Ribbon buttons for formatsp. 164
The Format Cells dialog boxp. 165
Formatting dates and timesp. 167
Formatting text entriesp. 169
Creating custom formatsp. 169
Applying conditional number formatsp. 171
Converting actual values to displayed valuesp. 173
Hiding zeroesp. 174
Using styles to streamline formattingp. 175
Just the factsp. 179
Organizing Datap. 181
Organizing Datap. 183
Sorting listsp. 183
Filtering recordsp. 188
Calculating filtered recordsp. 192
The Query Wizard - A better filterp. 193
Query a Web pagep. 200
Just the factsp. 202
Finding and Comparing Answersp. 203
Consolidating a tablep. 204
Subtotaling a tablep. 206
Scenariosp. 208
Compare answers with data tablesp. 212
Goal seeking for simple answersp. 215
Answering complex questions with Solverp. 218
Just the factsp. 222
Summarizing Data Dynamically with PivotTablesp. 223
Using PivotTablesp. 223
PivotTable termsp. 224
Creating a PivotTablep. 224
The PivotTable Tools tabp. 229
Changing PivotTable arrangementp. 230
Changing PivotTable calculationsp. 237
Showing underlying detailsp. 239
Formatting numbersp. 239
Just the factsp. 239
Displaying PivotTables Graphically with PivotChartsp. 241
PivotCharts versus normal chartsp. 242
Creating PivotChartsp. 242
Rearranging PivotChartsp. 245
Formatting PivotChartsp. 246
Embedding a PivotChart on a worksheetp. 246
Just the factsp. 248
Presenting Your Datap. 249
Presenting Data Visually with Chartsp. 251
Creating a chartp. 251
The Charts groupp. 254
Types of chartsp. 256
Changing chart datap. 260
Quickly changing chart layoutp. 261
Moving and resizing an embedded chartp. 262
Changing the chart locationp. 263
Just the factsp. 264
Formatting Chartsp. 265
Chart formatting possibilitiesp. 265
Formatting chart elementsp. 266
Changing axis scalep. 269
Reordering the seriesp. 271
Enlarging and exploding a pie chartp. 272
Changing 3-D perspectivep. 274
Adding a trendlinep. 276
Adding a secondary axisp. 281
Working with data labelsp. 283
Creating picture markersp. 285
Saving and reusing your custom chart formatp. 286
Just the factsp. 289
Adding Pictures and Graphic Objectsp. 291
Using the Shapes groupp. 291
Drawing basic shapesp. 293
Formatting for all graphic objectsp. 294
Creating AutoShapesp. 299
Drawing text boxesp. 300
Creating WordArtp. 300
Inserting pictures and clip artp. 301
Creating SmartArtp. 303
Pasting pictures of cellsp. 304
Just the factsp. 306
Sharing Excel Datap. 307
Printing Just What You Needp. 309
Previewing printed pagesp. 309
Printing a quick copy of a worksheetp. 311
Printing part of a worksheetp. 311
Printing a chartp. 315
Printing several worksheetsp. 316
Just the factsp. 317
Formatting the Printed Pagep. 319
Setting page breaksp. 319
Changing the page layoutp. 321
Printing a specific number of pagesp. 328
Printing row/column labels on every pagep. 329
Creating a header or footerp. 332
Printing worksheet gridlinesp. 337
Printing in black and whitep. 337
Formatting printed chartsp. 338
Just the factsp. 340
Sharing a Workbook with Other Usersp. 343
Sharing a workbookp. 344
Reviewing changes in a shared workbookp. 346
Sending and routing workbooksp. 351
Protecting workbooks and worksheetsp. 352
Just the factsp. 356
Sharing a Workbook Between Programsp. 357
Shared-data terminologyp. 357
Sending data between Excel and Wordp. 358
Sending data between Excel and Accessp. 366
Pasting Excel data into PowerPointp. 367
Dragging a hyperlink into Excelp. 367
Saving a worksheet as a Web pagep. 368
Just the factsp. 369
Making Excel Your Ownp. 371
Customizing Your Workspacep. 373
Changing your screen displayp. 373
Minimizing the Ribbonp. 375
Customizing the Quick Access toolbarp. 376
Personalizing featuresp. 377
Proofing optionsp. 379
Setting Advanced optionsp. 380
Just the factsp. 381
Adding Controls to a Worksheetp. 383
What can worksheet controls do?p. 384
Forms Controlsp. 386
All worksheet controlsp. 388
List boxes and combo boxesp. 389
Option buttons and group boxesp. 391
Scroll bars and spinnersp. 394
Check boxesp. 397
Button controlsp. 398
Labelsp. 399
Just the factsp. 399
Using Macros to Automate Repetitive Workp. 401
Introducing macrosp. 401
Recording a macrop. 403
Running a macrop. 405
Exploring the Visual Basic Editorp. 408
Editing a macrop. 413
Deleting a macrop. 417
Setting macro virus protectionp. 417
Just the factsp. 419
Appendixesp. 421
Build Creative Worksheetsp. 423
Recommended Resourcesp. 443
Glossaryp. 447
Indexp. 465
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review