Excel 2003 Bible

Excel 2003 Bible......Page 1
About the Author......Page 7
Credits......Page 8
Software Versions......Page 9
Mouse conventions......Page 10
What the Icons Mean......Page 11
How to Use This Book......Page 12
Smart tag improvements......Page 13
What\'s on the Companion CD and Web Site......Page 14
Contents at a Glance......Page 15
Contents......Page 17
Part I: Getting Started with Excel......Page 37
What Is It Good For?......Page 39
Understanding Workbooks and Worksheets......Page 40
Moving Around a Worksheet......Page 42
Navigating with your keyboard......Page 43
Navigating with your mouse......Page 44
Using menus......Page 45
Using shortcut menus......Page 47
Excel\'s Most Useful Built-In Toolbars......Page 48
Moving toolbars......Page 49
Understanding dialog box controls......Page 50
Navigating dialog boxes......Page 51
Using tabbed dialog boxes......Page 52
Creating Your First Excel Worksheet......Page 53
Filling in the month names......Page 54
Summing the values......Page 55
Making your worksheet look a bit fancier......Page 56
Creating a chart......Page 57
Saving your workbook......Page 58
Understanding the Types of Data You Can Use......Page 61
Understanding text entries......Page 62
Entering Text and Values into Your Worksheets......Page 63
Entering Dates and Times into Your Worksheets......Page 64
Entering time values......Page 65
Replacing the contents of a cell......Page 66
Editing the contents of a cell......Page 67
Automatically moving the cell pointer after entering data......Page 68
Entering decimal points automatically......Page 69
Forcing text to appear on a new line within a cell......Page 70
Entering numbers with fractions......Page 71
Entering the current date or time into a cell......Page 72
Improving readability by formatting numbers......Page 73
Number-Formatting Buttons on the Formatting Toolbar......Page 74
Formatting numbers using the Format Cells dialog box......Page 75
Adding your own custom number formats......Page 78
Working with Excel\'s windows......Page 79
Switching among windows......Page 81
Making a worksheet the active sheet......Page 82
Adding a new worksheet to your workbook......Page 83
Changing the name of a worksheet......Page 84
Rearranging your worksheets......Page 85
Hiding and unhiding a worksheet......Page 87
Viewing a worksheet in multiple windows......Page 88
Comparing sheets side by side......Page 89
Keeping the titles in view by freezing panes......Page 90
Zooming in or out for a better view......Page 91
Saving your view settings......Page 93
Working with Rows and Columns......Page 94
Inserting rows and columns......Page 95
Hiding rows and columns......Page 96
Changing column widths......Page 97
Changing row heights......Page 98
Understanding Cells and Ranges......Page 99
Selecting ranges......Page 100
Selecting noncontiguous ranges......Page 101
Selecting multisheet ranges......Page 102
Selecting special types of cells......Page 104
Go To Special Options......Page 105
Copying or Moving Ranges......Page 107
Copying by using toolbar buttons......Page 108
Copying by using drag-and-drop......Page 109
Copying to adjacent cells......Page 110
Copying a range to other sheets......Page 111
Using the Office Clipboard to paste......Page 112
Pasting in special ways......Page 113
Skipping blanks when pasting......Page 114
Using Names to Work with Ranges......Page 115
Creating range names in your workbooks......Page 116
Deleting names......Page 118
Adding Comments to Cells......Page 119
Getting to Know the Formatting Tools......Page 121
Using the Format Cells dialog box......Page 122
Using different fonts......Page 123
Choosing horizontal alignment options......Page 126
Choosing vertical alignment options......Page 127
Merging worksheet cells to create additional text space......Page 128
Controlling the text direction......Page 129
Using colors and shading......Page 130
Adding borders and lines......Page 131
Adding a background image to a worksheet......Page 132
Using AutoFormat for quick and easy worksheet formatting......Page 133
Using Named Styles for Easier Formatting......Page 134
Applying styles to your worksheets......Page 136
Creating new styles......Page 137
Merging styles from other workbooks......Page 138
Controlling styles with templates......Page 139
Creating a new workbook......Page 141
Opening an existing workbook......Page 143
Using the Tools menu......Page 145
Saving and closing your workbooks......Page 146
Using AutoRecover......Page 147
Setting the file-saving options......Page 148
Setting the workbook summary information......Page 149
Safeguarding your work......Page 150
Understanding Excel Templates......Page 151
Using the workbook template to change workbook defaults......Page 152
Using the worksheet template to change worksheet defaults......Page 153
Creating custom templates......Page 154
Ideas for creating templates......Page 155
Printing with One Click......Page 157
Adjusting the settings in the Print dialog box......Page 158
Choosing your printer......Page 159
Printing multiple copies of a report......Page 160
Selecting your page appearance settings......Page 161
Adjusting the report margins......Page 162
Adding a header or footer to your reports......Page 163
Custom Header/Footer Buttons and Their Functions......Page 165
Setting the sheet printing options......Page 166
Preventing certain cells from being printed......Page 168
Viewing the print preview......Page 169
Changing print settings while previewing......Page 170
Using Page Break Preview mode......Page 171
Creating custom views of your worksheet......Page 173
Part II: Working with Formulas and Functions......Page 175
Understanding Formula Basics......Page 177
Operators Used in Formulas......Page 178
Understanding operator precedence in formulas......Page 179
Operator Precedence in Excel Formulas......Page 180
Examples of formulas that use functions......Page 181
Function arguments......Page 182
Entering Formulas into Your Worksheets......Page 183
Pasting range names into formulas......Page 184
Inserting functions into formulas......Page 185
Function entry tips......Page 186
Editing Formulas......Page 187
Using relative, absolute, and mixed references......Page 188
Changing the types of your references......Page 190
Referencing cells in other workbooks......Page 191
Correcting Common Formula Errors......Page 192
Handling circular references......Page 193
Changing when formulas are calculated......Page 195
Using Advanced Naming Techniques......Page 196
Using names for formulas......Page 197
Using range intersections......Page 198
Reference Operators for Ranges......Page 199
Applying names to existing references......Page 200
Using the formula bar as a calculator......Page 201
Converting formulas to values......Page 202
How many characters in a cell?......Page 205
Numbers as text......Page 206
Working with character codes......Page 207
The CHAR function......Page 208
Joining two or more cells......Page 209
Displaying formatted values as text......Page 211
Repeating a character or string......Page 212
Creating a text histogram......Page 213
Padding a number......Page 214
Changing the case of text......Page 215
Extracting characters from a string......Page 216
Replacing text with other text......Page 217
Searching and replacing within a string......Page 218
Counting the occurrences of a substring in a cell......Page 219
Extracting the last word of a string......Page 220
Extracting first names, middle names, and last names......Page 221
Counting the number of words in a cell......Page 223
Understanding date serial numbers......Page 225
Entering dates......Page 226
Date Entry Formats Recognized by Excel......Page 227
Understanding time serial numbers......Page 228
Times of Day and Their Corresponding Serial Numbers......Page 229
Time Entry Formats Recognized by Excel......Page 230
Formatting dates and times......Page 231
Excel\'s leap year bug......Page 232
Inconsistent date entries......Page 233
Date-Related Functions......Page 234
Displaying any date......Page 235
Generating a series of dates......Page 236
Converting a non-date string to a date......Page 237
Calculating the number of days between two dates......Page 238
Calculating the number of workdays between two dates......Page 239
Calculating the number of years between two dates......Page 240
Calculating a person\'s age......Page 241
Determining the day of the week......Page 242
Determining the nth occurrence of a day of the week in a month......Page 243
New Year\'s Day......Page 244
Independence Day......Page 245
Determining the last day of a month......Page 246
Time-Related Functions......Page 247
Displaying any time......Page 248
Calculating the difference between two times......Page 249
Summing times that exceed 24 hours......Page 250
Converting decimal hours, minutes, or seconds to a time......Page 253
Adding hours, minutes, or seconds to a time......Page 254
Working with non-time-of-day values......Page 255
Counting and Summing Worksheet Cells......Page 257
Basic Counting Formulas......Page 259
Counting the total number of cells......Page 260
Counting nonblank cells......Page 261
Counting error values in a range......Page 262
Counting cells by using the COUNTIF function......Page 263
Counting cells by using multiple criteria......Page 264
Using And criteria......Page 265
Using Or criteria......Page 266
Counting the most frequently occurring entry......Page 267
Entire cell contents......Page 268
Partial cell contents......Page 269
Counting the number of unique values......Page 270
Creating a frequency distribution......Page 271
The FREQUENCY function......Page 272
Using formulas to create a frequency distribution......Page 273
Using the Analysis ToolPak to create a frequency distribution......Page 274
Summing Formulas......Page 275
Summing all cells in a range......Page 276
Computing a cumulative sum......Page 277
Conditional Sums Using a Single Criterion......Page 278
Summing only negative values......Page 279
Summing values based on a different range......Page 280
Conditional Sums Using Multiple Criteria......Page 281
Using And criteria......Page 282
Using And and Or criteria......Page 283
Introducing Lookup Formulas......Page 285
Functions Relevant to Lookups......Page 286
The VLOOKUP function......Page 288
The HLOOKUP function......Page 289
The LOOKUP function......Page 290
Combining the MATCH and INDEX functions......Page 291
Looking up an exact value......Page 293
Looking up a value to the left......Page 294
Choosing among multiple lookup tables......Page 296
Determining letter grades for test scores......Page 297
Calculating a grade-point average......Page 298
Performing a two-way lookup......Page 299
Performing a two-column lookup......Page 301
Determining the cell address of a value within a range......Page 302
Looking up a value by using the closest match......Page 303
The Time Value of Money......Page 305
Loan Calculations......Page 306
The PMT function......Page 307
The IPMT Function......Page 308
The PV Function......Page 309
A loan calculation example......Page 310
Credit card payments......Page 311
Creating a loan amortization schedule......Page 313
Formulas Used to Calculate an Amortization Schedule......Page 314
Creating a one-way data table......Page 315
Creating a two-way data table......Page 316
Calculating a loan with irregular payments......Page 318
Investment Calculations......Page 319
Calculating simple interest......Page 320
Calculating compound interest......Page 321
Calculating interest with continuous compounding......Page 323
Future value of a series of deposits......Page 324
Depreciation Calculations......Page 326
Understanding Array Formulas......Page 331
A multicell array formula......Page 332
A single-cell array formula......Page 333
Creating an array constant......Page 334
Understanding the Dimensions of an Array......Page 335
One-dimensional vertical arrays......Page 336
Two-dimensional arrays......Page 337
Naming Array Constants......Page 338
Entering an array formula......Page 339
Editing an array formula......Page 340
Expanding or contracting a multicell array formula......Page 341
Creating an array constant from values in a range......Page 342
Performing operations on an array......Page 343
Transposing an array......Page 344
Generating an array of consecutive integers......Page 345
Counting characters in a range......Page 347
Summing the three smallest values in a range......Page 348
Counting text cells in a range......Page 349
Eliminating intermediate formulas......Page 350
Using an array in lieu of a range reference......Page 351
Working with Single-Cell Array Formulas......Page 353
Counting the number of error values in a range......Page 354
Summing based on a condition......Page 355
Summing the n largest values in a range......Page 356
Computing an average that excludes zeros......Page 357
Determining whether a particular value appears in a range......Page 358
Returning the location of the maximum value in a range......Page 359
Determining whether a range contains valid values......Page 360
Summing the digits of an integer......Page 361
Summing rounded values......Page 362
Summing every nth value in a range......Page 363
Determining the closest value in a range......Page 365
Returning the last value in a column......Page 366
Ranking data with an array formula......Page 367
Returning only positive values from a range......Page 368
Returning nonblank cells from a range......Page 369
Displaying a calendar in a range......Page 370
Part III: Creating Charts and Graphics......Page 373
What Is a Chart?......Page 375
How Excel Handles Charts......Page 376
Embedded charts......Page 377
Parts of a Chart......Page 378
Creating a chart with one keystroke......Page 380
Creating a chart with a mouse click......Page 381
Using the Chart Wizard......Page 382
Selecting the data......Page 384
Chart Wizard - Step 1 of 4......Page 385
Chart Wizard - Step 2 of 4......Page 386
Specifying the category data and series data......Page 387
Chart Wizard - Step 3 of 4......Page 389
Chart Wizard - Step 4 of 4......Page 390
Basic Chart Modifications......Page 391
Copying a chart......Page 392
Printing Charts......Page 393
Choosing a chart type......Page 395
Column charts......Page 397
Line charts......Page 399
Pie charts......Page 400
Area charts......Page 402
Doughnut charts......Page 403
Radar charts......Page 404
Bubble charts......Page 405
Stock charts......Page 406
Cylinder, cone, and pyramid charts......Page 407
Understanding Chart Customization......Page 409
Selecting with the mouse......Page 410
Selecting with the Chart toolbar......Page 411
Modifying properties by using the Format dialog box......Page 412
Modifying the Plot Area......Page 413
Working with chart titles......Page 414
Working with the legend......Page 415
Changing the chart gridlines......Page 417
Modifying the axes scales......Page 418
Working with time-based axes......Page 420
Working with Data Series......Page 421
Adding a new data series to a chart......Page 422
Changing the data range by dragging the range outline......Page 423
Editing the Series formula......Page 424
Displaying data labels in a chart......Page 425
Controlling a data series by hiding data......Page 426
Adding error bars......Page 427
Modifying 3-D charts......Page 428
Formatting a surface chart......Page 429
Creating combination charts......Page 430
Displaying a data table......Page 431
Create a chart......Page 432
Test and refine......Page 433
Creating picture charts......Page 434
Creating a thermometer chart......Page 435
Creating a gauge chart......Page 436
Creating a comparative histogram......Page 437
Creating a Gantt chart......Page 438
Creating a chart that updates automatically......Page 439
Plotting mathematical functions with one variable......Page 440
Plotting mathematical functions with two variables......Page 441
Questions about chart settings......Page 442
Chart formatting questions......Page 444
Chart series questions......Page 448
Chart type questions......Page 450
Miscellaneous chart questions......Page 451
The AutoShapes toolbar......Page 455
Inserting AutoShapes......Page 456
Adding text to an AutoShape......Page 458
Moving objects......Page 459
Grouping objects......Page 460
Aligning objects......Page 461
Adding shadows and 3-D effects......Page 462
Printing objects......Page 463
Using the Microsoft Clip Organizer......Page 464
Importing from a digital camera or scanner......Page 466
Modifying pictures......Page 467
Creating diagrams and org charts......Page 468
Creating WordArt......Page 470
Part IV: Analyzing Data with Excel......Page 471
What Is a List?......Page 473
What Can You Do with a List?......Page 474
Entering Data into a List......Page 475
Other uses for the Data Form dialog box......Page 477
Using autofiltering......Page 478
Multicolumn autofiltering......Page 479
Custom autofiltering......Page 480
Top 10 autofiltering......Page 481
Setting up a criteria range......Page 482
Multiple criteria......Page 484
Examples of Text Criteria......Page 485
Computed criteria......Page 486
Using Database Functions with Lists......Page 488
Simple sorting......Page 490
More-complex sorting......Page 491
Using a custom sort order......Page 492
Creating Subtotals......Page 493
Creating a designated list......Page 496
Adding rows or columns to a designated list......Page 497
Advantage in using a designated list......Page 498
Understanding External Database Files......Page 499
The database file......Page 501
Selecting a data source......Page 502
Query Wizard: Choosing the columns......Page 504
Query Wizard: Filtering data......Page 505
Query Wizard: Finish......Page 506
Specifying a location for the data......Page 507
Adjusting the external data range properties......Page 508
Refreshing a query......Page 509
Using Query without the Wizard......Page 510
Creating a query manually......Page 511
Using multiple database tables......Page 512
Learning more about Query......Page 513
About Pivot Tables......Page 515
A pivot table example......Page 516
Data appropriate for a pivot table......Page 518
Step1: Specifying the data location......Page 520
Step 2: Specifying the data......Page 521
Step 3: Completing the pivot table......Page 522
Using a dialog box to lay out a pivot table......Page 523
Using the PivotTable Field List toolbar to lay out a pivot table......Page 524
The finished product......Page 525
Grouping Pivot Table Items......Page 528
Creating a Calculated Field or Calculated Item......Page 531
Creating a calculated field in a pivot table......Page 532
Inserting a calculated item into a pivot table......Page 533
A What-If Example......Page 537
Creating Data Tables......Page 539
Creating a one-input data table......Page 540
Creating a two-input data table......Page 542
Defining scenarios......Page 545
Three Scenarios for the Production Model......Page 546
Displaying scenarios......Page 548
Generating a scenario report......Page 549
What-If Analysis - in Reverse......Page 551
A goal-seeking example......Page 552
More about goal seeking......Page 553
Appropriate problems for Solver......Page 554
A simple Solver example......Page 555
Constraints Summary......Page 557
More about Solver......Page 559
Minimizing shipping costs......Page 560
Allocating resources......Page 563
Optimizing an investment portfolio......Page 564
The Analysis ToolPak: An Overview......Page 567
Installing the Analysis ToolPak add-in......Page 568
Using the Analysis ToolPak functions......Page 569
The Analysis of Variance tool......Page 570
The Correlation tool......Page 571
The Exponential Smoothing tool......Page 572
The Histogram tool......Page 573
The Random Number Generation tool......Page 574
The Regression tool......Page 576
The Sampling tool......Page 577
The z- Test (Two-Sample Test for Means) tool......Page 578
Part V: Using Advanced Excel Features......Page 579
Automatic number formatting......Page 581
Number-Formatting Buttons on the Formatting Toolbar......Page 582
Using the format cells dialog box to format numbers......Page 583
Creating a Custom Number Format......Page 584
About custom number formats......Page 585
Parts of a number format string......Page 586
Codes Used to Create Custom Number Formats......Page 587
Codes Used in Creating Custom Formats for Dates and Times......Page 588
Examples of Displaying Values in Thousands......Page 589
Displaying values in millions......Page 590
Examples of Displaying Values in Millions......Page 591
Examples of Displaying a Value with Extra Zeros......Page 592
Displaying fractions......Page 593
Displaying a negative sign on the right......Page 594
Displaying text with numbers......Page 595
Suppressing certain types of entries......Page 596
Filling a cell with a repeating character......Page 597
Customizing Toolbars......Page 599
Types of customizations......Page 600
The Toolbars tab......Page 601
Renaming a custom toolbar......Page 602
Attaching a toolbar to a workbook......Page 603
The Options tab......Page 604
Adding or Removing Toolbar Buttons......Page 605
Other Toolbar Button Operations......Page 606
Editing a button image......Page 608
Copying another button image......Page 609
Conditional Formatting......Page 611
Formatting types you can apply......Page 612
Simple conditions......Page 613
Formula-based conditions......Page 614
Be careful when pasting......Page 615
Locating cells that contain conditional formatting......Page 616
Using references to other sheets......Page 617
Identifying above-average cells......Page 618
Displaying alternate-row shading......Page 619
Data Validation......Page 620
Specifying validation criteria......Page 621
Types of validation criteria you can apply......Page 622
Creating a drop-down list......Page 623
Accepting a larger value than the previous cell......Page 625
Accepting text that begins with......Page 626
Introducing Worksheet Outlines......Page 627
Preparing the data......Page 630
Creating an outline automatically......Page 631
Creating an outline manually......Page 632
Removing an outline......Page 633
Hiding the outline symbols......Page 634
Why link workbooks?......Page 635
Understanding the link formula syntax......Page 636
Pasting links......Page 637
Opening a workbook with external reference formulas......Page 638
Changing the link source......Page 639
Modifying a source workbook......Page 640
Consolidating Worksheets......Page 641
Consolidating worksheets by using formulas......Page 642
Consolidating worksheets by using Paste Special......Page 643
Consolidating worksheets by using the Consolidate command......Page 644
An example......Page 645
More about consolidation......Page 647
Understanding How Excel Uses HTML......Page 649
How does it work?......Page 650
Adding some complexity......Page 651
What about interactivity?......Page 652
Saving as an XML spreadsheet......Page 653
Inserting a hyperlink......Page 655
Using Web Queries......Page 656
Understanding Data Sharing......Page 659
Using the Clipboards......Page 660
Linking data......Page 662
Pasting without a link......Page 663
Embedding Objects in Documents......Page 664
Embedding an Excel range in a Word document......Page 665
Creating a new Excel object in Word......Page 666
Working with XML Data......Page 668
What is XML?......Page 669
Importing XML data by using a map......Page 670
Exporting XML data from Excel......Page 672
Using Excel on a Network......Page 675
Understanding File Reservations......Page 676
Sharing Workbooks......Page 677
Designating a workbook as a shared workbook......Page 678
Tracking changes......Page 679
Resolving conflicting changes between users......Page 680
E-mailing a worksheet or workbook......Page 681
Routing a workbook to others......Page 682
Turning Track Changes on and off......Page 683
Reviewing the changes......Page 685
Finding and Correcting Formula Errors......Page 687
Mismatched parentheses......Page 688
Cells are filled with hash marks......Page 689
Formulas returning an error......Page 690
#DIV/0! errors......Page 691
#NULL! errors......Page 692
#VALUE! errors......Page 693
Absolute/relative reference problems......Page 694
Formulas are not calculated......Page 695
Floating point number errors......Page 696
Identifying cells of a particular type......Page 698
Viewing formulas......Page 699
Comparing two windows......Page 700
Tracing cell relationships......Page 701
Identifying precedents......Page 702
Using background error-checking feature......Page 703
Using Excel Formula Evaluator......Page 705
Searching for information......Page 706
Searching for formatting......Page 707
Spell Checking Your Worksheets......Page 708
Using AutoCorrect......Page 709
Using AutoComplete......Page 711
Part VI: Programming Excel with VBA......Page 713
Introducing VBA Macros......Page 715
VBA Sub procedures......Page 716
VBA functions......Page 717
Recording your actions to create VBA code: The basics......Page 719
Recording a macro: An example......Page 720
Examining the macro......Page 721
Testing the macro......Page 722
Another example......Page 723
Absolute versus relative recording......Page 725
Storing macros in the Personal Macro Workbook......Page 726
Writing VBA code......Page 727
The basics: Entering and editing code......Page 728
How VBA works......Page 729
Objects and collections......Page 731
Properties......Page 732
Controlling execution......Page 734
A macro that canÌt be recorded......Page 736
Get another book......Page 738
Overview of VBA Functions......Page 739
Using the function in a worksheet......Page 740
About Function Procedures......Page 741
Executing Function Procedures......Page 742
Using custom functions in a worksheet formula......Page 743
A function with no argument......Page 744
A function with one argument......Page 745
A function with two arguments......Page 746
A function with a range argument......Page 747
Inserting Custom Functions......Page 748
Learning More......Page 750
Why Create UserForms?......Page 751
The InputBox function......Page 752
The MsgBox function......Page 753
Constants That Are Used in the MsgBox Function......Page 754
Adding controls......Page 756
Toolbox Controls......Page 757
Changing the properties of a control......Page 758
A UserForm Example......Page 759
Creating the UserForm......Page 760
Creating an event handler procedure......Page 761
Another UserForm Example......Page 762
Creating the UserForm......Page 763
Testing the UserForm......Page 764
Creating event handler procedures......Page 765
Testing the UserForm......Page 766
More on Creating UserForms......Page 767
Learning More......Page 768
Why Use Controls on a Worksheet?......Page 769
Adding a control......Page 771
Adjusting properties......Page 772
Properties Shared by Multiple Controls......Page 773
Creating macros for controls......Page 774
CheckBox control......Page 775
CommandButton control......Page 776
OptionButton controls......Page 777
ScrollBar control......Page 778
TextBox controls......Page 779
ToggleButton control......Page 780
Understanding Events......Page 781
Entering event handler VBA code......Page 782
Using Workbook-Level Events......Page 783
Using the Open event......Page 785
Using the BeforeSave event......Page 786
Working with Worksheet Events......Page 787
Monitoring a specific range for changes......Page 788
Using the SelectionChange event......Page 789
Using Non-Object Events......Page 790
Using the OnKey event......Page 791
Working with Ranges......Page 793
Copying a range......Page 794
Selecting to the end of a row or column......Page 795
Moving a range......Page 796
Looping through a range efficiently......Page 797
Prompting for a cell value......Page 798
Determining the type of selection......Page 799
Changing Excel\'s Settings......Page 800
Changing non-Boolean settings......Page 801
Modifying the chart type......Page 802
Applying chart formatting......Page 803
Preventing alert messages......Page 804
Declaring variable types......Page 805
Data Types......Page 806
What Is an Add-In?......Page 809
Working with Add-Ins......Page 810
Why Create Add-Ins?......Page 811
Creating Add-Ins......Page 812
Setting up the workbook......Page 813
ThisWorkbook......Page 814
UserForm1......Page 815
Testing the workbook......Page 816
Adding descriptive information......Page 817
Creating the add-in......Page 818
Opening the add-in......Page 819
Part VII: Appendixes......Page 821
Appendix A: Worksheet Function Reference......Page 823
Database Category Functions......Page 824
Date and Time Category Functions......Page 825
Engineering Category Functions......Page 826
Financial Category Functions......Page 827
Logical Category Functions......Page 830
Math and Trig Category Functions......Page 831
Statistical Category Functions......Page 834
Text Category Functions......Page 837
System Requirements......Page 839
eBook version of......Page 840
Sample files from the......Page 841
Bonus software......Page 847
Comprehensive list of software......Page 848
Troubleshooting......Page 850
Tick- Tack- Toe......Page 851
Moving Tile Puzzle......Page 852
Keno......Page 853
Creating word-search puzzles......Page 854
Dice Roller......Page 855
Video Poker......Page 856
Dice Game......Page 857
Bomb Hunt......Page 858
Hangman......Page 859
Animated Shapes......Page 860
Symmetrical Pattern Drawing......Page 861
Plotting trigonometric functions......Page 862
Hypocycloid charts......Page 863
Contour chart pattern generator......Page 865
Radar chart designs......Page 866
Analog clock chart......Page 867
A doughnut chart wheel of fortune......Page 868
A mountain range chart......Page 869
XY-Sketch......Page 870
For Guitar Players......Page 871
ASCII Art......Page 872
The Excel Help System......Page 873
Microsoft Office Tools on the Web......Page 874
Microsoft newsgroups......Page 875
The Microsoft.com Excel-Related Newsgroups......Page 876
Searching newsgroups......Page 877
David McRitchie\'s Excel Pages......Page 878
Spreadsheet FAQ......Page 879
Appendix E: Excel Shortcut Keys......Page 881
Moving Through a Worksheet......Page 882
Moving Within a Range Selection......Page 883
Formatting Keys......Page 884
Other Shortcut Keys......Page 885
Function Keys......Page 886
Index......Page 889
Wiley Publishing, Inc. End- User License Agreement......Page 935