Microsoft Excel Version 2002 Inside Out

Mark Dodge, Craig Stinson

  • 出版商: MicroSoft
  • 出版日期: 2001-05-12
  • 售價: $1,810
  • 貴賓價: 9.5$1,720
  • 語言: 英文
  • 頁數: 1104
  • 裝訂: Paperback
  • ISBN: 0735612811
  • ISBN-13: 9780735612815
  • 相關分類: Excel
  • 已絕版

買這商品的人也買了...

商品描述

Description:

Conquer Excel—from the Inside Out!

Hey, you know your way around Excel—so now dig into Version 2002 and really put your spreadsheets to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds in concise, fast-answer format—it’s all muscle and no fluff. Discover the best and fastest ways to perform everyday tasks, and challenge yourself to new levels of Excel mastery!

• Build on what you already know about Excel and quickly dive into what’s new
• Create more-powerful worksheets—from adding graphics to inserting hyperlinks
• Perform financial, statistical, and what-if data analysis
• Custom-build charts and PivotTable® Reports
• Import online data and save it in XML format
• Manage data and lists
• Integrate Excel with Microsoft® Access, PowerPoint®, and Word
• Create spreadsheet-driven Web pages
• Work with Microsoft Visual Basic® for Applications (VBA)
• Apply macros and custom functions to your worksheets

CD-ROM FEATURES:
• Intuitive HTML interface
• Extensive collection of Microsoft add-ins and third-party utilities, demos, and trials
• Macros and code samples
• Complete eBook—easy to browse and print!
• Sample chapters from other INSIDE OUT Office XP books
• Web links to Microsoft Office Tools on the Web, online troubleshooters, and product support
• Microsoft Visio® customizable auto-demos
• Interactive tutorials
• Additional files and templates

 

Table of Contents:

Acknowledgments  xxxiii
Wed Like to Hear from You  xxxv
Conventions Used in This Book xxxvii
PART 1 EXAMINING THE EXCEL ENVIRONMENT 1
CHAPTER 1 Whats New in Microsoft Excel 2002 3
    New Microsoft Office Features 3
        The Task Pane 4
        Smart Tags 4
        Office Improvements 5
        New Office Features 6
    New Microsoft Excel Features 7
        Usability Features 7
        Data Analysis Features 9
        Collaboration and Connectivity Features 11
        Reliability Features 12
    Onward?/TD> 12
CHAPTER 2 Running Excel 13
    What Happens After You Install Excel? 13
        Registering Excel 13
        Subscribing to Excel 14
    Recovering from Crashes 16
        Using AutoRecover 17
        Heroic Measures 18
    Examining the Excel Workspace 19
        Facts About Worksheets 19
        Using the Workbook Window 20
        Exploring Menus and Dialog Boxes 25
        Understanding the Formula Bar 29
        About the Status Bar 30
        Pointers About Pointers 31
        Introducing Toolbars 31
    File Management Fundamentals 32
        Creating and Opening Workbooks 32
        Saving Files 37
        Opening Files 44
        Searching for Files 49
    Importing and Exporting Files 51
        Using the Open and Save As Commands to Import and Export Files 52
        Importing and Exporting Text Files 53
        Sharing Data with Excel for the Macintosh 54
    Online Help Works—Really! 54
        The Best Way to Use Help 55
        Managing the Assistant 56
        Using the Assistant 58
        Getting Information on the Spot 61
        Whats on the Help Menu? 63
        Help for Lotus 1-2-3 Users 64
CHAPTER 3 Custom-Tailoring the Excel Workspace 65
    Customizing Toolbars and Menus 65
    Managing Toolbars 75
    Creating New Toolbars and Menus 77
    Controlling Other Elements of the Excel Interface 83
    Enhancing Accessibility 89
PART 2 BUILDING WORKSHEETS 91
CHAPTER 4 Worksheet Design Tips 93
    Which Data Should Be in Rows, and Which in Columns? 93
    Will You Need to Print the Worksheet? 94
    Who Is the Audience? 97
    Would Your Worksheet Survive Without You? 97
    Does the Worksheet Rely on Imported Data? 98
    Do You Need More than One Worksheet? 99
    Have You Allowed Room to Insert New Rows and Columns? 99
CHAPTER 5 How to Work a Worksheet 101
    Moving Around 101
        Navigating Regions 101
    Selecting Stuff 104
        Selecting with the Mouse 105
        Selecting with the Go To Command 107
    Entering Stuff 109
        Making Entries in Cells and in the Formula Bar 109
        Entering Symbols 114
        Making Entries in Ranges 115
        Editing and Undoing Entries 116
    Managing Worksheets 117
        Inserting and Deleting Sheets 117
        Naming and Renaming Sheets 118
        Coloring Sheet Tabs 119
        Moving and Copying Sheets 120
    Looking at Worksheets 122
        Splitting Sheets into Panes 122
        Zooming Worksheets 125
    Protecting Worksheets 127
        Unlocking Individual Cells 128
        Allowing Password Access to Specific Cell Ranges 130
        Hiding Cells and Sheets 131
CHAPTER 6 How to Work a Workbook 133
    Managing Multiple Workbooks 133
        Navigating Between Open Workbooks 134
        Arranging Workbook Windows 134
        Getting the Most out of Your Screen 137
    Opening Multiple Windows for the Same Workbook 138
        Useful Inconsistencies of New Windows 139
    Hiding and Protecting Workbooks 141
        Hiding Workbooks 141
        Protecting Workbooks 142
        Saving Workbooks or Windows as Hidden 143
        Hiding Worksheets 143
PART 3 FORMATTING AND EDITING WORKSHEETS 145
CHAPTER 7 Worksheet Editing Techniques 147
    Copying, Cutting, and Pasting 147
        Copying and Pasting 148
        Collecting Multiple Items on the Clipboard 148
        Cutting and Pasting 151
        Pasting Selectively Using Paste Special 152
        Pasting Hyperlinks 156
        Moving and Copying with the Mouse 157
    Inserting and Deleting 159
        Inserting Columns and Rows 159
        Inserting Cells 161
        Deleting Cells, Columns, and Rows 163
        Inserting, Deleting, and Clearing Cells with the Mouse 166
    Undoing Previous Actions 168
        Redoing What Youve Undone 169
        Repeating Your Last Action 169
    Editing Cell Contents 170
        Editing in the Formula Bar 170
        Editing Directly in Cells 170
        Editing Options 171
        Clearing Cell Contents and Formats 173
        Filling and Creating Data Series 174
        Extending Existing Formatting 182
    Finding and Replacing Stuff 182
        Finding Formatting 184
        Specifying Variables Using Wildcard Characters 186
        Replacing What You Find 186
    Editing Multiple Worksheets 187
        Grouping Sheets for Editing 187
        Filling a Group 191
    Getting the Words Right 191
        Fixing Errors as You Type 191
        Letting Excel Help with Typing Chores 195
        Cheking Yer Speling 197
CHAPTER 8 Worksheet Formatting Techniques 199
    Formatting Fundamentals 199
        Painting Formats 201
        Turbo Formatting with AutoFormat 202
    Formatting in Cells 204
        Formatting Individual Characters 205
        Formatting as You Type 205
        Using the General Format 207
        Formatting Numbers 207
        Formatting Currency 208
        Using the Euro Currency Tools Add-in 209
        Using Accounting Formats 211
        Formatting Percentages 212
        Formatting Fractions 212
        Formatting Scientific (Exponential) Values 213
        Understanding the Text Format 214
        Using the Special Formats 214
    Creating Custom Formats 215
        Creating New Number Formats 215
        Creating Four-Part Formats 219
        Adding Color to Formats 220
        Using Custom Format Condition Operators 222
    Aligning Data in Cells 223
        Aligning Text Horizontally 224
        Indenting Cell Contents   225
        Distributing Cell Contents   225
    Aligning Text Vertically 226
        Shrinking Text to Fit in Cells 228
        Selecting Alignment Using Toolbars 229
    Using Fonts 230
        Formatting Fonts with Toolbar Buttons 230
    Customizing Borders 231
        Applying Border Formats with Toolbar Buttons 233
        Drawing Borders 234
    Applying Colors and Patterns 235
        Adding Colors with Toolbars 237
        Adding Graphic Backgrounds to Worksheets 237
    Controlling the Size of Cells 238
        Changing Column Widths 238
        Changing Row Heights 240
        Merging and Unmerging Cells 241
CHAPTER 9 Advanced Formatting and Editing Techniques 245
    Applying Conditional Formats 245
    Formatting with Styles 247
        Applying a Style 249
        Defining Styles from Scratch 250
        Modifying a Style 252
        Overriding a Style with Direct Formatting Changes 252
        Merging Styles from Different Workbooks 252
        Deleting a Style 253
    Using Template Files to Store Formatting 253
        Adding Templates to the XLStart Folder 255
    Auditing and Documenting Worksheets 256
        Checking for Errors 257
        Evaluating and Auditing Formulas 258
        Watching Formulas 260
        Tracing Cell References 261
        Adding Comments to Cells 266
        Using Go To Special 268
        Having Excel Read Cells to You 271
    Outlining Worksheets 272
        Collapsing and Expanding Outline Levels 275
        Hiding or Clearing an Outline 275
        Displaying a Specific Outline Level 277
        Selecting Only Visible Cells 277
        Ungrouping and Grouping Columns and Rows 277
    Consolidating Worksheets 278
        Consolidating by Position 279
        Consolidating by Category 281
PART 4 ADDING GRAPHICS AND PRINTING 285
CHAPTER 10 Creating Spiffy Graphics 287
    Using the Drawing Tools 287
        Drawing Constrained Objects 289
        Using Tear-off Palettes 291
    Creating Graphic Objects 291
        Drawing Freehand Lines and Polygons 291
        Working with Text Boxes 294
        Working with AutoShapes 296
        Creating WordArt 298
    Working with Graphic Objects 300
        Selecting and Grouping Objects 300
        Formatting Objects 302
        Positioning Objects 308
        Protecting Objects 310
    Inserting Other Objects 311
        Using Clip Art and Other Media 313
        Importing Graphics 318
        Inserting Pictures 319
    Formatting Pictures 322
    More Tricks With Objects 325
        Assigning Macros to Objects 326
        Taking Pictures of your Worksheets 326
    Gallery of Spiffy Examples 329
CHAPTER 11 Printing and Presenting 335
    Controlling the Appearance of Your Pages 335
        Setting Page Options 335
        Setting Margins 337
        Creating a Header and Footer 338
        Adding Pictures to Headers and Footers 340
        Setting Sheet Options 341
    Adjusting Page Breaks 344
        Inserting and Removing Manual Page Breaks 345
    Using Print Preview 346
    Specifying What and Where to Print 347
        Defining a Default Print Area 349
    Setting Printer Driver Options 351
PART 5 CREATING FORMULAS AND PERFORMING DATA ANALYSIS 353
CHAPTER 12 Building Formulas 355
    Formula Fundamentals 355
        Understanding the Precedence of Operators 355
        Using Cell References in Formulas 356
        Editing Formulas 363
    Using Functions: A Preview 365
        Using the AutoSum Button 365
        Inserting Functions 366
        Creating Three-Dimensional Formulas 367
        Formula-Bar Formatting 367
        Creating Natural-Language Formulas 367
    Naming Cells and Cell Ranges 371
        Using Names in Formulas 371
        Defining and Managing Names 372
        Editing Names 374
        Workbook-Wide vs. Worksheet-Only Names 374
        Creating Names Semiautomatically 376
        Naming Constants and Formulas 376
        Creating Three-Dimensional Names 377
        Pasting Names into Formulas 377
        Creating a List of Names 378
        Replacing References with Names 378
        Using Go To with Named Ranges 380
    Understanding Error Values 380
    Worksheet Calculation 381
        Recalculating Manually 382
        Copying Formulas and Pasting Only Their Resulting Values 383
        Evaluating Part of a Formula 383
        Using Circular References 384
        Understanding the Precision of Numeric Values 386
    Using Arrays 387
        One-Dimensional Arrays 387
        Array Formula Rules 388
        Two-Dimensional Arrays 389
        Single-Cell Array Formulas 389
        Using Array Constants 391
        Understanding Array Expansion 391
    Linking Workbooks 392
        Saving Linked Workbooks 392
        Opening a Dependent Workbook 393
        Editing Links 393
        Copying, Cutting, and Pasting in Linked Workbooks 394
    Creating Conditional Tests 396
        Using the Conditional Sum and Lookup Wizards 397
        Creating Conditional Sum Formulas 397
        Creating Lookup Formulas 400
CHAPTER 13 Using Functions 403
    Using Excels Built-In Function Reference 403
    Installing the Analysis ToolPak 405
    Exploring the Syntax of Functions 406
        Expressions as Arguments 407
        Types of Arguments 407
    Inserting Functions 408
        Inserting References and Names 411
CHAPTER 14 Everyday Functions 413
    Understanding Mathematical Functions