Microsoft Excel 2010 Formulas

Part I: Basic Information - Page 35
Part I: Basic Information - Page 36
Chapter 1: Excel in a Nutshell - Page 37
The History of Excel - Page 38
The History of Excel - Page 39
The History of Excel - Page 40
The Object Model Concept - Page 41
The Object Model Concept - Page 42
The Workings of Workbooks - Page 43
The Workings of Workbooks - Page 44
The Excel User Interface - Page 45
The Excel User Interface - Page 46
The Excel User Interface - Page 47
The Excel User Interface - Page 48
The Excel User Interface - Page 49
The Excel User Interface - Page 50
The Excel User Interface - Page 51
The Excel User Interface - Page 52
The Excel User Interface - Page 53
The Excel Help System - Page 54
Cell Formatting - Page 55
Tables - Page 56
Objects on the Drawing Layer - Page 57
Objects on the Drawing Layer - Page 58
Customizing Excel - Page 59
Internet Features - Page 60
Internet Features - Page 61
Internet Features - Page 62
Protection Options - Page 63
Protection Options - Page 64
Chapter 2: Basic Facts about Formulas - Page 65
Chapter 2: Basic Facts about Formulas - Page 66
Chapter 2: Basic Facts about Formulas - Page 67
Chapter 2: Basic Facts about Formulas - Page 68
Chapter 2: Basic Facts about Formulas - Page 69
Chapter 2: Basic Facts about Formulas - Page 70
Using Operators in Formulas - Page 71
Using Operators in Formulas - Page 72
Using Operators in Formulas - Page 73
Using Operators in Formulas - Page 74
Using Operators in Formulas - Page 75
Calculating Formulas - Page 76
Cell and Range References - Page 77
Cell and Range References - Page 78
Cell and Range References - Page 79
Cell and Range References - Page 80
Making an Exact Copy of a Formula - Page 81
Converting Formulas to Values - Page 82
Converting Formulas to Values - Page 83
Hiding Formulas - Page 84
Errors in Formulas - Page 85
Dealing with Circular References - Page 86
Goal Seeking - Page 87
Goal Seeking - Page 88
Goal Seeking - Page 89
Goal Seeking - Page 90
Chapter 3: Working with Names - Page 91
A Name’s Scope - Page 92
A Name’s Scope - Page 93
The Name Manager - Page 94
The Name Manager - Page 95
Shortcuts for Creating Cell and Range Names - Page 96
Shortcuts for Creating Cell and Range Names - Page 97
Shortcuts for Creating Cell and Range Names - Page 98
Shortcuts for Creating Cell and Range Names - Page 99
Shortcuts for Creating Cell and Range Names - Page 100
Shortcuts for Creating Cell and Range Names - Page 101
Creating Multisheet Names - Page 102
Creating Multisheet Names - Page 103
Working with Range and Cell Names - Page 104
Working with Range and Cell Names - Page 105
Working with Range and Cell Names - Page 106
Working with Range and Cell Names - Page 107
Working with Range and Cell Names - Page 108
Working with Range and Cell Names - Page 109
How Excel Maintains Cell and Range Names - Page 110
Potential Problems with Names - Page 111
Potential Problems with Names - Page 112
Potential Problems with Names - Page 113
The Secret to Understanding Names - Page 114
The Secret to Understanding Names - Page 115
The Secret to Understanding Names - Page 116
The Secret to Understanding Names - Page 117
The Secret to Understanding Names - Page 118
The Secret to Understanding Names - Page 119
The Secret to Understanding Names - Page 120
The Secret to Understanding Names - Page 121
Advanced Techniques That Use Names - Page 122
Advanced Techniques That Use Names - Page 123
Advanced Techniques That Use Names - Page 124
Advanced Techniques That Use Names - Page 125
Advanced Techniques That Use Names - Page 126
Part II: Using Functions in Your Formulas - Page 127
Part II: Using Functions in Your Formulas - Page 128
Chapter 4: Introducing Worksheet Functions - Page 129
Chapter 4: Introducing Worksheet Functions - Page 130
Chapter 4: Introducing Worksheet Functions - Page 131
Function Argument Types - Page 132
Function Argument Types - Page 133
Function Argument Types - Page 134
Ways to Enter a Function into a Formula - Page 135
Ways to Enter a Function into a Formula - Page 136
Ways to Enter a Function into a Formula - Page 137
Ways to Enter a Function into a Formula - Page 138
Ways to Enter a Function into a Formula - Page 139
Function Categories - Page 140
Function Categories - Page 141
Function Categories - Page 142
Function Categories - Page 143
Function Categories - Page 144
Chapter 5: Manipulating Text - Page 145
Chapter 5: Manipulating Text - Page 146
Text Functions - Page 147
Text Functions - Page 148
Text Functions - Page 149
Text Functions - Page 150
Text Functions - Page 151
Text Functions - Page 152
Text Functions - Page 153
Text Functions - Page 154
Text Functions - Page 155
Text Functions - Page 156
Text Functions - Page 157
Text Functions - Page 158
Text Functions - Page 159
Text Functions - Page 160
Advanced Text Formulas - Page 161
Advanced Text Formulas - Page 162
Advanced Text Formulas - Page 163
Advanced Text Formulas - Page 164
Advanced Text Formulas - Page 165
Advanced Text Formulas - Page 166
Advanced Text Formulas - Page 167
Advanced Text Formulas - Page 168
Chapter 6: Working with Dates and Times - Page 169
Chapter 6: Working with Dates and Times - Page 170
Chapter 6: Working with Dates and Times - Page 171
Chapter 6: Working with Dates and Times - Page 172
Chapter 6: Working with Dates and Times - Page 173
Chapter 6: Working with Dates and Times - Page 174
Chapter 6: Working with Dates and Times - Page 175
Chapter 6: Working with Dates and Times - Page 176
Chapter 6: Working with Dates and Times - Page 177
Date-Related Functions - Page 178
Date-Related Functions - Page 179
Date-Related Functions - Page 180
Date-Related Functions - Page 181
Date-Related Functions - Page 182
Date-Related Functions - Page 183
Date-Related Functions - Page 184
Date-Related Functions - Page 185
Date-Related Functions - Page 186
Date-Related Functions - Page 187
Date-Related Functions - Page 188
Date-Related Functions - Page 189
Date-Related Functions - Page 190
Date-Related Functions - Page 191
Date-Related Functions - Page 192
Date-Related Functions - Page 193
Date-Related Functions - Page 194
Time-Related Functions - Page 195
Time-Related Functions - Page 196
Time-Related Functions - Page 197
Time-Related Functions - Page 198
Time-Related Functions - Page 199
Time-Related Functions - Page 200
Time-Related Functions - Page 201
Time-Related Functions - Page 202
Time-Related Functions - Page 203
Time-Related Functions - Page 204
Time-Related Functions - Page 205
Time-Related Functions - Page 206
Chapter 7: Counting and Summing Techniques - Page 207
Chapter 7: Counting and Summing Techniques - Page 208
Counting or Summing Records in Databases and Pivot Tables - Page 209
Basic Counting Formulas - Page 210
Basic Counting Formulas - Page 211
Basic Counting Formulas - Page 212
Advanced Counting Formulas - Page 213
Advanced Counting Formulas - Page 214
Advanced Counting Formulas - Page 215
Advanced Counting Formulas - Page 216
Advanced Counting Formulas - Page 217
Advanced Counting Formulas - Page 218
Advanced Counting Formulas - Page 219
Advanced Counting Formulas - Page 220
Advanced Counting Formulas - Page 221
Advanced Counting Formulas - Page 222
Advanced Counting Formulas - Page 223
Advanced Counting Formulas - Page 224
Advanced Counting Formulas - Page 225
Advanced Counting Formulas - Page 226
Advanced Counting Formulas - Page 227
Summing Formulas - Page 228
Summing Formulas - Page 229
Summing Formulas - Page 230
Summing Formulas - Page 231
Conditional Sums Using a Single Criterion - Page 232
Conditional Sums Using a Single Criterion - Page 233
Conditional Sums Using Multiple Criteria - Page 234
Conditional Sums Using Multiple Criteria - Page 235
Conditional Sums Using Multiple Criteria - Page 236
Conditional Sums Using Multiple Criteria - Page 237
Conditional Sums Using Multiple Criteria - Page 238
Chapter 8: Using Lookup Functions - Page 239
Functions Relevant to Lookups - Page 240
Functions Relevant to Lookups - Page 241
Functions Relevant to Lookups - Page 242
Functions Relevant to Lookups - Page 243
Functions Relevant to Lookups - Page 244
Functions Relevant to Lookups - Page 245
Specialized Lookup Formulas - Page 246
Specialized Lookup Formulas - Page 247
Specialized Lookup Formulas - Page 248
Specialized Lookup Formulas - Page 249
Specialized Lookup Formulas - Page 250
Specialized Lookup Formulas - Page 251
Specialized Lookup Formulas - Page 252
Specialized Lookup Formulas - Page 253
Specialized Lookup Formulas - Page 254
Specialized Lookup Formulas - Page 255
Specialized Lookup Formulas - Page 256
Specialized Lookup Formulas - Page 257
Specialized Lookup Formulas - Page 258
Specialized Lookup Formulas - Page 259
Specialized Lookup Formulas - Page 260
Chapter 9: Tables and Worksheet Databases - Page 261
Chapter 9: Tables and Worksheet Databases - Page 262
Chapter 9: Tables and Worksheet Databases - Page 263
Chapter 9: Tables and Worksheet Databases - Page 264
Working with Tables - Page 265
Working with Tables - Page 266
Working with Tables - Page 267
Working with Tables - Page 268
Working with Tables - Page 269
Working with Tables - Page 270
Working with Tables - Page 271
Working with Tables - Page 272
Working with Tables - Page 273
Working with Tables - Page 274
Working with Tables - Page 275
Working with Tables - Page 276
Working with Tables - Page 277
Working with Tables - Page 278
Working with Tables - Page 279
Working with Tables - Page 280
Working with Tables - Page 281
Working with Tables - Page 282
Working with Tables - Page 283
Using Advanced Filtering - Page 284
Using Advanced Filtering - Page 285
Using Advanced Filtering - Page 286
Using Advanced Filtering - Page 287
Specifying Advanced Filter Criteria - Page 288
Specifying Advanced Filter Criteria - Page 289
Specifying Advanced Filter Criteria - Page 290
Specifying Advanced Filter Criteria - Page 291
Specifying Advanced Filter Criteria - Page 292
Specifying Advanced Filter Criteria - Page 293
Using Database Functions - Page 294
Using Database Functions - Page 295
Inserting Subtotals - Page 296
Inserting Subtotals - Page 297
Inserting Subtotals - Page 298
Inserting Subtotals - Page 299
Inserting Subtotals - Page 300
Chapter 10: Miscellaneous Calculations - Page 301
Chapter 10: Miscellaneous Calculations - Page 302
Solving Right Triangles - Page 303
Solving Right Triangles - Page 304
Solving Right Triangles - Page 305
Area, Surface, Circumference, and Volume Calculations - Page 306
Area, Surface, Circumference, and Volume Calculations - Page 307
Area, Surface, Circumference, and Volume Calculations - Page 308
Solving Simultaneous Equations - Page 309
Rounding Numbers - Page 310
Rounding Numbers - Page 311
Rounding Numbers - Page 312
Rounding Numbers - Page 313
Rounding Numbers - Page 314
Rounding Numbers - Page 315
Rounding Numbers - Page 316
Part III: Financial Formulas - Page 317
Part III: Financial Formulas - Page 318
Chapter 11: Borrowing and Investing Formulas - Page 319
Chapter 11: Borrowing and Investing Formulas - Page 320
The Basic Excel Financial Functions - Page 321
The Basic Excel Financial Functions - Page 322
The Basic Excel Financial Functions - Page 323
The Basic Excel Financial Functions - Page 324
The Basic Excel Financial Functions - Page 325
The Basic Excel Financial Functions - Page 326
The Basic Excel Financial Functions - Page 327
The Basic Excel Financial Functions - Page 328
The Basic Excel Financial Functions - Page 329
The Basic Excel Financial Functions - Page 330
The Basic Excel Financial Functions - Page 331
The Basic Excel Financial Functions - Page 332
Calculating the Interest and Principal Components - Page 333
Calculating the Interest and Principal Components - Page 334
Calculating the Interest and Principal Components - Page 335
Converting Interest Rates - Page 336
Converting Interest Rates - Page 337
Limitations of Excel’s Financial Functions - Page 338
Limitations of Excel’s Financial Functions - Page 339
Bond Calculations - Page 340
Bond Calculations - Page 341
Bond Calculations - Page 342
Chapter 12: Discounting and Depreciation Formulas - Page 343
Chapter 12: Discounting and Depreciation Formulas - Page 344
Chapter 12: Discounting and Depreciation Formulas - Page 345
Chapter 12: Discounting and Depreciation Formulas - Page 346
Chapter 12: Discounting and Depreciation Formulas - Page 347
Chapter 12: Discounting and Depreciation Formulas - Page 348
Chapter 12: Discounting and Depreciation Formulas - Page 349
Chapter 12: Discounting and Depreciation Formulas - Page 350
Chapter 12: Discounting and Depreciation Formulas - Page 351
Chapter 12: Discounting and Depreciation Formulas - Page 352
Using the IRR Function - Page 353
Using the IRR Function - Page 354
Using the IRR Function - Page 355
Using the IRR Function - Page 356
Multiple Rates of IRR and the MIRR Function - Page 357
Multiple Rates of IRR and the MIRR Function - Page 358
Multiple Rates of IRR and the MIRR Function - Page 359
Irregular Cash Flows - Page 360
Irregular Cash Flows - Page 361
Using the FVSCHEDULE Function - Page 362
Depreciation Calculations - Page 363
Depreciation Calculations - Page 364
Depreciation Calculations - Page 365
Depreciation Calculations - Page 366
Chapter 13: Financial Schedules - Page 367
Creating Amortization Schedules - Page 368
Creating Amortization Schedules - Page 369
Creating Amortization Schedules - Page 370
Creating Amortization Schedules - Page 371
Creating Amortization Schedules - Page 372
Creating Amortization Schedules - Page 373
Creating Amortization Schedules - Page 374
Creating Amortization Schedules - Page 375
Creating Amortization Schedules - Page 376
Summarizing Loan Options Using a Data Table - Page 377
Summarizing Loan Options Using a Data Table - Page 378
Summarizing Loan Options Using a Data Table - Page 379
Summarizing Loan Options Using a Data Table - Page 380
Financial Statements and Ratios - Page 381
Financial Statements and Ratios - Page 382
Financial Statements and Ratios - Page 383
Financial Statements and Ratios - Page 384
Financial Statements and Ratios - Page 385
Financial Statements and Ratios - Page 386
Financial Statements and Ratios - Page 387
Creating Indices - Page 388
Creating Indices - Page 389
Creating Indices - Page 390
Part IV: Array Formulas - Page 391
Part IV: Array Formulas - Page 392
Chapter 14: Introducing Arrays - Page 393
Chapter 14: Introducing Arrays - Page 394
Chapter 14: Introducing Arrays - Page 395
Chapter 14: Introducing Arrays - Page 396
Chapter 14: Introducing Arrays - Page 397
Understanding the Dimensions of an Array - Page 398
Understanding the Dimensions of an Array - Page 399
Naming Array Constants - Page 400
Naming Array Constants - Page 401
Working with Array Formulas - Page 402
Working with Array Formulas - Page 403
Using Multicell Array Formulas - Page 404
Using Multicell Array Formulas - Page 405
Using Multicell Array Formulas - Page 406
Using Multicell Array Formulas - Page 407
Using Multicell Array Formulas - Page 408
Using Single-Cell Array Formulas - Page 409
Using Single-Cell Array Formulas - Page 410
Using Single-Cell Array Formulas - Page 411
Using Single-Cell Array Formulas - Page 412
Using Single-Cell Array Formulas - Page 413
Using Single-Cell Array Formulas - Page 414
Using Single-Cell Array Formulas - Page 415
Using Single-Cell Array Formulas - Page 416
Chapter 15: Performing Magic with Array Formulas - Page 417
Chapter 15: Performing Magic with Array Formulas - Page 418
Chapter 15: Performing Magic with Array Formulas - Page 419
Chapter 15: Performing Magic with Array Formulas - Page 420
Chapter 15: Performing Magic with Array Formulas - Page 421
Chapter 15: Performing Magic with Array Formulas - Page 422
Chapter 15: Performing Magic with Array Formulas - Page 423
Chapter 15: Performing Magic with Array Formulas - Page 424
Chapter 15: Performing Magic with Array Formulas - Page 425
Chapter 15: Performing Magic with Array Formulas - Page 426
Chapter 15: Performing Magic with Array Formulas - Page 427
Chapter 15: Performing Magic with Array Formulas - Page 428
Chapter 15: Performing Magic with Array Formulas - Page 429
Chapter 15: Performing Magic with Array Formulas - Page 430
Chapter 15: Performing Magic with Array Formulas - Page 431
Working with Multicell Array Formulas - Page 432
Working with Multicell Array Formulas - Page 433
Working with Multicell Array Formulas - Page 434
Working with Multicell Array Formulas - Page 435
Working with Multicell Array Formulas - Page 436
Working with Multicell Array Formulas - Page 437
Working with Multicell Array Formulas - Page 438
Part V: Miscellaneous Formula Techniques - Page 439
Part V: Miscellaneous Formula Techniques - Page 440
Chapter 16: Intentional Circular References - Page 441
Chapter 16: Intentional Circular References - Page 442
Intentional Circular References - Page 443
Intentional Circular References - Page 444
Intentional Circular References - Page 445
How Excel Determines Calculation and Iteration Settings - Page 446
Circular Reference Examples - Page 447
Circular Reference Examples - Page 448
Circular Reference Examples - Page 449
Circular Reference Examples - Page 450
Circular Reference Examples - Page 451
Circular Reference Examples - Page 452
Potential Problems with Intentional Circular References - Page 453
Potential Problems with Intentional Circular References - Page 454
Chapter 17: Charting Techniques - Page 455
Chapter 17: Charting Techniques - Page 456
Chapter 17: Charting Techniques - Page 457
Chapter 17: Charting Techniques - Page 458
Chapter 17: Charting Techniques - Page 459
Creating Links to Cells - Page 460
Creating Links to Cells - Page 461
Chart Examples - Page 462
Chart Examples - Page 463
Chart Examples - Page 464
Chart Examples - Page 465
Chart Examples - Page 466
Chart Examples - Page 467
Chart Examples - Page 468
Chart Examples - Page 469
Chart Examples - Page 470
Chart Examples - Page 471
Chart Examples - Page 472
Chart Examples - Page 473
Chart Examples - Page 474
Chart Examples - Page 475
Chart Examples - Page 476
Chart Examples - Page 477
Chart Examples - Page 478
Chart Examples - Page 479
Chart Examples - Page 480
Chart Examples - Page 481
Chart Examples - Page 482
Chart Examples - Page 483
Chart Examples - Page 484
Chart Examples - Page 485
Chart Examples - Page 486
Working with Trendlines - Page 487
Working with Trendlines - Page 488
Working with Trendlines - Page 489
Working with Trendlines - Page 490
Working with Trendlines - Page 491
Working with Trendlines - Page 492
Working with Trendlines - Page 493
Working with Trendlines - Page 494
Working with Trendlines - Page 495
Working with Trendlines - Page 496
Working with Trendlines - Page 497
Working with Trendlines - Page 498
Chapter 18: Pivot Tables - Page 499
A Pivot Table Example - Page 500
A Pivot Table Example - Page 501
Data Appropriate for a Pivot Table - Page 502
Data Appropriate for a Pivot Table - Page 503
Data Appropriate for a Pivot Table - Page 504
Creating a Pivot Table - Page 505
Creating a Pivot Table - Page 506
Creating a Pivot Table - Page 507
Creating a Pivot Table - Page 508
Creating a Pivot Table - Page 509
Creating a Pivot Table - Page 510
Creating a Pivot Table - Page 511
Creating a Pivot Table - Page 512
More Pivot Table Examples - Page 513
More Pivot Table Examples - Page 514
More Pivot Table Examples - Page 515
More Pivot Table Examples - Page 516
More Pivot Table Examples - Page 517
More Pivot Table Examples - Page 518
Grouping Pivot Table Items - Page 519
Grouping Pivot Table Items - Page 520
Grouping Pivot Table Items - Page 521
Grouping Pivot Table Items - Page 522
Grouping Pivot Table Items - Page 523
Grouping Pivot Table Items - Page 524
Grouping Pivot Table Items - Page 525
Creating a Frequency Distribution - Page 526
Creating a Frequency Distribution - Page 527
Creating a Calculated Field or Calculated Item - Page 528
Creating a Calculated Field or Calculated Item - Page 529
Creating a Calculated Field or Calculated Item - Page 530
Creating a Calculated Field or Calculated Item - Page 531
Creating a Calculated Field or Calculated Item - Page 532
Creating a Calculated Field or Calculated Item - Page 533
Creating a Calculated Field or Calculated Item - Page 534
Filtering Pivot Tables with Slicers - Page 535
Referencing Cells within a Pivot Table - Page 536
Referencing Cells within a Pivot Table - Page 537
Another Pivot Table Example - Page 538
Another Pivot Table Example - Page 539
Another Pivot Table Example - Page 540
Producing a Report with a Pivot Table - Page 541
Producing a Report with a Pivot Table - Page 542
Producing a Report with a Pivot Table - Page 543
Producing a Report with a Pivot Table - Page 544
Chapter 19: Conditional Formatting and Data Validation - Page 545
Chapter 19: Conditional Formatting and Data Validation - Page 546
Chapter 19: Conditional Formatting and Data Validation - Page 547
Chapter 19: Conditional Formatting and Data Validation - Page 548
Chapter 19: Conditional Formatting and Data Validation - Page 549
Chapter 19: Conditional Formatting and Data Validation - Page 550
Chapter 19: Conditional Formatting and Data Validation - Page 551
Chapter 19: Conditional Formatting and Data Validation - Page 552
Chapter 19: Conditional Formatting and Data Validation - Page 553
Chapter 19: Conditional Formatting and Data Validation - Page 554
Chapter 19: Conditional Formatting and Data Validation - Page 555
Chapter 19: Conditional Formatting and Data Validation - Page 556
Chapter 19: Conditional Formatting and Data Validation - Page 557
Chapter 19: Conditional Formatting and Data Validation - Page 558
Chapter 19: Conditional Formatting and Data Validation - Page 559
Chapter 19: Conditional Formatting and Data Validation - Page 560
Chapter 19: Conditional Formatting and Data Validation - Page 561
Chapter 19: Conditional Formatting and Data Validation - Page 562
Chapter 19: Conditional Formatting and Data Validation - Page 563
Chapter 19: Conditional Formatting and Data Validation - Page 564
Chapter 19: Conditional Formatting and Data Validation - Page 565
Chapter 19: Conditional Formatting and Data Validation - Page 566
Chapter 19: Conditional Formatting and Data Validation - Page 567
Chapter 19: Conditional Formatting and Data Validation - Page 568
Chapter 19: Conditional Formatting and Data Validation - Page 569
Chapter 19: Conditional Formatting and Data Validation - Page 570
Data Validation - Page 571
Data Validation - Page 572
Data Validation - Page 573
Data Validation - Page 574
Data Validation - Page 575
Data Validation - Page 576
Data Validation - Page 577
Data Validation - Page 578
Data Validation - Page 579
Data Validation - Page 580
Chapter 20: Creating Megaformulas - Page 581
Creating a Megaformula: A Simple Example - Page 582
Creating a Megaformula: A Simple Example - Page 583
Megaformula Examples - Page 584
Megaformula Examples - Page 585
Megaformula Examples - Page 586
Megaformula Examples - Page 587
Megaformula Examples - Page 588
Megaformula Examples - Page 589
Megaformula Examples - Page 590
Megaformula Examples - Page 591
Megaformula Examples - Page 592
Megaformula Examples - Page 593
Megaformula Examples - Page 594
Megaformula Examples - Page 595
Megaformula Examples - Page 596
Megaformula Examples - Page 597
The Pros and Cons of Megaformulas - Page 598
Chapter 21: Tools and Methods for Debugging Formulas - Page 599
Formula Problems and Solutions - Page 600
Formula Problems and Solutions - Page 601
Formula Problems and Solutions - Page 602
Formula Problems and Solutions - Page 603
Formula Problems and Solutions - Page 604
Formula Problems and Solutions - Page 605
Formula Problems and Solutions - Page 606
Formula Problems and Solutions - Page 607
Formula Problems and Solutions - Page 608
Formula Problems and Solutions - Page 609
Formula Problems and Solutions - Page 610
Formula Problems and Solutions - Page 611
Formula Problems and Solutions - Page 612
Formula Problems and Solutions - Page 613
Excel’s Auditing Tools - Page 614
Excel’s Auditing Tools - Page 615
Excel’s Auditing Tools - Page 616
Excel’s Auditing Tools - Page 617
Excel’s Auditing Tools - Page 618
Excel’s Auditing Tools - Page 619
Excel’s Auditing Tools - Page 620
Excel’s Auditing Tools - Page 621
Excel’s Auditing Tools - Page 622
Part VI: Developing Custom Worksheet Functions - Page 623
Part VI: Developing Custom Worksheet Functions - Page 624
Chapter 22: Introducing VBA - Page 625
Displaying the Developer Tab - Page 626
Displaying the Developer Tab - Page 627
Saving Workbooks That Contain Macros - Page 628
Introducing the Visual Basic Editor - Page 629
Introducing the Visual Basic Editor - Page 630
Introducing the Visual Basic Editor - Page 631
Introducing the Visual Basic Editor - Page 632
Introducing the Visual Basic Editor - Page 633
Introducing the Visual Basic Editor - Page 634
Introducing the Visual Basic Editor - Page 635
Introducing the Visual Basic Editor - Page 636
Introducing the Visual Basic Editor - Page 637
Introducing the Visual Basic Editor - Page 638
Chapter 23: Function Procedure Basics - Page 639
An Introductory VBA Function Example - Page 640
An Introductory VBA Function Example - Page 641
About Function Procedures - Page 642
About Function Procedures - Page 643
About Function Procedures - Page 644
About Function Procedures - Page 645
Using the Insert Function Dialog Box - Page 646
Using the Insert Function Dialog Box - Page 647
Using the Insert Function Dialog Box - Page 648
Using the Insert Function Dialog Box - Page 649
Testing and Debugging Your Functions - Page 650
Testing and Debugging Your Functions - Page 651
Testing and Debugging Your Functions - Page 652
Testing and Debugging Your Functions - Page 653
Testing and Debugging Your Functions - Page 654
Testing and Debugging Your Functions - Page 655
Testing and Debugging Your Functions - Page 656
Testing and Debugging Your Functions - Page 657
Creating Add-Ins - Page 658
Creating Add-Ins - Page 659
Creating Add-Ins - Page 660
Chapter 24: VBA Programming Concepts - Page 661
An Introductory Example Function Procedure - Page 662
An Introductory Example Function Procedure - Page 663
Using Comments in Your Code - Page 664
Using Comments in Your Code - Page 665
Using Comments in Your Code - Page 666
Using Comments in Your Code - Page 667
Using Comments in Your Code - Page 668
Using Comments in Your Code - Page 669
Using Assignment Expressions - Page 670
Using Arrays - Page 671
Using Arrays - Page 672
Using Built-In VBA Functions - Page 673
Controlling Execution - Page 674
Controlling Execution - Page 675
Controlling Execution - Page 676
Controlling Execution - Page 677
Controlling Execution - Page 678
Controlling Execution - Page 679
Controlling Execution - Page 680
Controlling Execution - Page 681
Controlling Execution - Page 682
Controlling Execution - Page 683
Using Ranges - Page 684
Using Ranges - Page 685
Using Ranges - Page 686
Using Ranges - Page 687
Using Ranges - Page 688
Using Ranges - Page 689
Using Ranges - Page 690
Using Ranges - Page 691
Using Ranges - Page 692
Using Ranges - Page 693
Using Ranges - Page 694
Chapter 25: VBA Custom Function Examples - Page 695
Simple Functions - Page 696
Simple Functions - Page 697
Simple Functions - Page 698
Simple Functions - Page 699
Simple Functions - Page 700
Determining a Cell’s Data Type - Page 701
Determining a Cell’s Data Type - Page 702
A Multifunctional Function - Page 703
A Multifunctional Function - Page 704
Generating Random Numbers - Page 705
Generating Random Numbers - Page 706
Generating Random Numbers - Page 707
Calculating Sales Commissions - Page 708
Calculating Sales Commissions - Page 709
Calculating Sales Commissions - Page 710
Text Manipulation Functions - Page 711
Text Manipulation Functions - Page 712
Text Manipulation Functions - Page 713
Text Manipulation Functions - Page 714
Text Manipulation Functions - Page 715
Text Manipulation Functions - Page 716
Counting Functions - Page 717
Counting Functions - Page 718
Counting Functions - Page 719
Date Functions - Page 720
Date Functions - Page 721
Date Functions - Page 722
Returning the Last Nonempty Cell in a Column or Row - Page 723
Returning the Last Nonempty Cell in a Column or Row - Page 724
Multisheet Functions - Page 725
Multisheet Functions - Page 726
Advanced Function Techniques - Page 727
Advanced Function Techniques - Page 728
Advanced Function Techniques - Page 729
Advanced Function Techniques - Page 730
Advanced Function Techniques - Page 731
Advanced Function Techniques - Page 732
Advanced Function Techniques - Page 733
Advanced Function Techniques - Page 734
Advanced Function Techniques - Page 735
Advanced Function Techniques - Page 736
Advanced Function Techniques - Page 737
Advanced Function Techniques - Page 738
Advanced Function Techniques - Page 739
Advanced Function Techniques - Page 740
Part VII: Appendixes - Page 741
Part VII: Appendixes - Page 742
Appendix A: Excel Function Reference - Page 743
Appendix A: Excel Function Reference - Page 744
Appendix A: Excel Function Reference - Page 745
Appendix A: Excel Function Reference - Page 746
Appendix A: Excel Function Reference - Page 747
Appendix A: Excel Function Reference - Page 748
Appendix A: Excel Function Reference - Page 749
Appendix A: Excel Function Reference - Page 750
Appendix A: Excel Function Reference - Page 751
Appendix A: Excel Function Reference - Page 752
Appendix A: Excel Function Reference - Page 753
Appendix A: Excel Function Reference - Page 754
Appendix A: Excel Function Reference - Page 755
Appendix A: Excel Function Reference - Page 756
Appendix A: Excel Function Reference - Page 757
Appendix A: Excel Function Reference - Page 758
Appendix B: Using Custom Number Formats - Page 759
Appendix B: Using Custom Number Formats - Page 760
Appendix B: Using Custom Number Formats - Page 761
Appendix B: Using Custom Number Formats - Page 762
Creating a Custom Number Format - Page 763
Creating a Custom Number Format - Page 764
Creating a Custom Number Format - Page 765
Creating a Custom Number Format - Page 766
Custom Number Format Examples - Page 767
Custom Number Format Examples - Page 768
Custom Number Format Examples - Page 769
Custom Number Format Examples - Page 770
Custom Number Format Examples - Page 771
Custom Number Format Examples - Page 772
Custom Number Format Examples - Page 773
Custom Number Format Examples - Page 774
Custom Number Format Examples - Page 775
Custom Number Format Examples - Page 776
Custom Number Format Examples - Page 777
Custom Number Format Examples - Page 778
Appendix C: Additional Excel Resources - Page 779
Appendix C: Additional Excel Resources - Page 780
Internet Newsgroups - Page 781
Internet Newsgroups - Page 782
Internet Web sites - Page 783
Internet Web sites - Page 784
Appendix D: What’s on the CD-ROM? - Page 785
Files and Software on the CD - Page 786
Files and Software on the CD - Page 787
Files and Software on the CD - Page 788
Files and Software on the CD - Page 789
Files and Software on the CD - Page 790
Files and Software on the CD - Page 791
Files and Software on the CD - Page 792
Troubleshooting - Page 793
Troubleshooting - Page 794