Preface p. vii
Getting Started with Excel p. 1
Introducing Excel p. 3
What Is It Good For? p. 3
Understanding Workbooks and Worksheets p. 4
Moving Around a Worksheet p. 6
Using the Excel Menus and Toolbars p. 9
Working with Dialog Boxes p. 14
Creating Your First Excel Worksheet p. 17
Entering and Editing Worksheet Data p. 25
Understanding the Types of Data You Can Use p. 25
Entering Text and Values into Your Worksheets p. 27
Entering Dates and Times into Your Worksheets p. 28
Modifying Cell Contents p. 30
Applying Number Formatting p. 37
Essential Worksheet Operations p. 43
Learning the Fundamentals of Excel Worksheets p. 43
Controlling the Worksheet View p. 52
Working with Rows and Columns p. 58
Working with Cells and Ranges p. 63
Understanding Cells and Ranges p. 63
Copying or Moving Ranges p. 71
Using Names to Work with Ranges p. 79
Adding Comments to Cells p. 83
Worksheet Formatting p. 85
Getting to Know the Formatting Tools p. 85
Using Formatting in Your Worksheets p. 87
Using Named Styles for Easier Formatting p. 98
Understanding Files and Templates p. 105
Understanding Excel Files p. 105
Understanding Excel Templates p. 115
Printing Your Work p. 121
Printing with One Click p. 121
Adjusting Your Print Settings for Better Results p. 122
Using Print Preview p. 133
Working with Formulas and Functions p. 139
Introducing Formulas and Functions p. 141
Understanding Formula Basics p. 141
Entering Formulas into Your Worksheets p. 147
Editing Formulas p. 151
Using Cell References in Formulas p. 152
Correcting Common Formula Errors p. 156
Using Advanced Naming Techniques p. 160
Tips for Working with Formulas p. 165
Creating Formulas That Manipulate Text p. 169
A Few Words about Text p. 169
Text Functions p. 171
Advanced Text Formulas p. 183
Working with Dates and Times p. 189
How Excel Handles Dates and Times p. 189
Date-Related Functions p. 198
Time-Related Functions p. 211
Creating Formulas That Count and Sum p. 221
Counting and Summing Worksheet Cells p. 221
Basic Counting Formulas p. 223
Advanced Counting Formulas p. 227
Summing Formulas p. 239
Conditional Sums Using a Single Criterion p. 242
Conditional Sums Using Multiple Criteria p. 245
Creating Formulas That Look Up Values p. 249
Introducing Lookup Formulas p. 249
Functions Relevant to Lookups p. 250
Basic Lookup Formulas p. 252
Specialized Lookup Formulas p. 257
Creating Formulas for Financial Applications p. 269
The Time Value of Money p. 269
Loan Calculations p. 270
Investment Calculations p. 283
Depreciation Calculations p. 290
Introducing Array Formulas p. 295
Understanding Array Formulas p. 295
Understanding the Dimensions of an Array p. 299
Naming Array Constants p. 302
Working with Array Formulas p. 303
Using Multicell Array Formulas p. 306
Using Single-Cell Array Formulas p. 311
Performing Magic with Array Formulas p. 317
Working with Single-Cell Array Formulas p. 317
Working with Multicell Array Formulas p. 332
Creating Charts and Graphics p. 337
Getting Started Making Charts p. 339
What Is a Chart? p. 339
How Excel Handles Charts p. 340
Parts of a Chart p. 342
Creating Charts p. 344
Hands On: Creating a Chart with the Chart Wizard p. 348
Basic Chart Modifications p. 355
Printing Charts p. 357
Understanding Chart Types p. 359
Learning Advanced Charting p. 373
Understanding Chart Customization p. 373
Changing Basic Chart Elements p. 374
Working with Data Series p. 385
Creating Custom Chart Types p. 396
Learning Some Chart-Making Tricks p. 398
Frequently Asked Questions p. 406
Enhancing Your Work with Pictures and Drawings p. 419
Using AutoShapes p. 419
Using the Drawing Toolbar p. 425
Working with Other Graphic Types p. 428
Using the Office Applets p. 432
Analyzing Data with Excel p. 435
Working with Lists p. 437
What Is a List? p. 437
What Can You Do with a List? p. 438
Designing a List p. 439
Entering Data into a List p. 439
Filtering a List p. 442
Using Database Functions with Lists p. 452
Sorting a List p. 454
Creating Subtotals p. 457
Working with a Designated List p. 460
Using External Database Files p. 463
Understanding External Database Files p. 463
Retrieving Data with Query: An Example p. 465
Working with Data Returned by Query p. 472
Using Query without the Wizard p. 474
Analyzing Data with Pivot Tables p. 479
About Pivot Tables p. 479
Creating a Pivot Table p. 484
Grouping Pivot Table Items p. 492
Creating a Calculated Field or Calculated Item p. 495
Performing Spreadsheet What-If Analysis p. 501
A What-If Example p. 501
Types of What-If Analyses p. 503
Manual What-If Analysis p. 503
Creating Data Tables p. 503
Using Scenario Manager p. 509
Analyzing Data Using Goal Seek and Solver p. 515
What-If Analysis--in Reverse p. 515
Single-Cell Goal Seeking p. 516
Introducing Solver p. 518
Solver Examples p. 524
Analyzing Data with the Analysis ToolPak p. 531
The Analysis ToolPak: An Overview p. 531
Using the Analysis ToolPak p. 532
The Analysis ToolPak Tools p. 534
Using Advanced Excel Features p. 543
Using Custom Number Formats p. 545
About Number Formatting p. 545
Creating a Custom Number Format p. 548
Custom Number Format Examples p. 553
Customizing Toolbars and Menus p. 563
Customizing Toolbars p. 563
Moving Toolbars p. 565
Using the Customize Dialog Box p. 565
Adding or Removing Toolbar Buttons p. 569
Other Toolbar Button Operations p. 570
Changing a Toolbar Button's Image p. 572
Using Conditional Formatting and Data Validation p. 575
Conditional Formatting p. 575
Data Validation p. 584
Creating and Using Worksheet Outlines p. 591
Introducing Worksheet Outlines p. 591
Creating an Outline p. 594
Working with Outlines p. 597
Linking and Consolidating Worksheets p. 599
Linking Workbooks p. 599
Consolidating Worksheets p. 605
Excel and the Internet p. 613
Understanding How Excel Uses HTML p. 613
Working with Hyperlinks p. 619
Using Web Queries p. 620
Sharing Data with Other Applications p. 623
Understanding Data Sharing p. 623
Pasting and Linking Data p. 624
Embedding Objects in Documents p. 628
Working with XML Data p. 632
Using Excel in a Workgroup p. 639
Using Excel on a Network p. 639
Understanding File Reservations p. 640
Sharing Workbooks p. 641
Mailing and Routing Workbooks p. 645
Tracking Workbook Changes p. 647
Making Your Worksheets Error-Free p. 651
Finding and Correcting Formula Errors p. 651
Using Excel's Auditing Tools p. 662
Searching and Replacing p. 670
Spell Checking Your Worksheets p. 672
Using AutoCorrect p. 673
Using AutoComplete p. 675
Programming Excel with VBA p. 677
Introducing Visual Basic for Applications p. 679
Introducing VBA Macros p. 679
Two Types of VBA Macros p. 680
Creating VBA Macros p. 683
Learning More p. 702
Creating Custom Worksheet Functions p. 703
Overview of VBA Functions p. 703
An Introductory Example p. 704
About Function Procedures p. 705
Executing Function Procedures p. 706
Function Procedure Arguments p. 708
Debugging Custom Functions p. 712
Inserting Custom Functions p. 712
Learning More p. 714
Creating UserForms p. 715
Why Create UserForms? p. 715
UserForm Alternatives p. 716
Creating UserForms: An Overview p. 720
A UserForm Example p. 723
Another UserForm Example p. 726
More on Creating UserForms p. 731
Learning More p. 732
Using UserForm Controls in a Worksheet p. 733
Why Use Controls on a Worksheet? p. 733
Using Controls p. 735
The Controls Toolbox Controls p. 739
Working with Excel Events p. 745
Understanding Events p. 745
Using Workbook-Level Events p. 747
Working with Worksheet Events p. 751
Using Non-Object Events p. 754
VBA Examples p. 757
Working with Ranges p. 757
Changing Excel's Settings p. 764
Working with Charts p. 766
VBA Speed Tips p. 768
Creating Custom Excel Add-Ins p. 773
What Is an Add-In? p. 773
Working with Add-Ins p. 774
Why Create Add-Ins? p. 775
Creating Add-Ins p. 776
An Add-In Example p. 777
Appendixes p. 785
Worksheet Function Reference p. 787
What's on the CD-ROM p. 803
Just for Fun p. 815
Additional Excel Resources p. 837
Excel Shortcut Keys p. 845
Index p. 853
End-User License Agreement p. 899
Table of Contents provided by Blackwell's Book Services and R.R. Bowker. Used with permission.
