Microsoft Excel 2013

Book I: Excel Basics - Page 29
Contents at a Glance - Page 30
Chapter 1: The Excel 2013 User Experience - Page 31
Excel 2013’s New Look and Feel - Page 32
Excel 2013’s New Look and Feel - Page 33
Excel’s Ribbon User Interface - Page 34
Excel’s Ribbon User Interface - Page 35
Excel’s Ribbon User Interface - Page 36
Excel’s Ribbon User Interface - Page 37
Excel’s Ribbon User Interface - Page 38
Excel’s Ribbon User Interface - Page 39
Excel’s Ribbon User Interface - Page 40
Excel’s Ribbon User Interface - Page 41
Excel’s Ribbon User Interface - Page 42
Excel’s Ribbon User Interface - Page 43
Excel’s Ribbon User Interface - Page 44
Excel’s Ribbon User Interface - Page 45
Excel’s Ribbon User Interface - Page 46
Excel’s Ribbon User Interface - Page 47
Excel’s Ribbon User Interface - Page 48
Excel’s Ribbon User Interface - Page 49
Excel’s Ribbon User Interface - Page 50
Excel’s Ribbon User Interface - Page 51
Getting Help - Page 52
Getting Help - Page 53
Launching and Quitting Excel - Page 54
Launching and Quitting Excel - Page 55
Launching and Quitting Excel - Page 56
Launching and Quitting Excel - Page 57
Launching and Quitting Excel - Page 58
Chapter 2: Customizing Excel 2013 - Page 59
Chapter 2: Customizing Excel 2013 - Page 60
Chapter 2: Customizing Excel 2013 - Page 61
Chapter 2: Customizing Excel 2013 - Page 62
Exercising Your Options - Page 63
Exercising Your Options - Page 64
Exercising Your Options - Page 65
Exercising Your Options - Page 66
Exercising Your Options - Page 67
Exercising Your Options - Page 68
Exercising Your Options - Page 69
Exercising Your Options - Page 70
Exercising Your Options - Page 71
Exercising Your Options - Page 72
Exercising Your Options - Page 73
Exercising Your Options - Page 74
Exercising Your Options - Page 75
Exercising Your Options - Page 76
Exercising Your Options - Page 77
Exercising Your Options - Page 78
Exercising Your Options - Page 79
Exercising Your Options - Page 80
Exercising Your Options - Page 81
Exercising Your Options - Page 82
Exercising Your Options - Page 83
Using Office Apps - Page 84
Using Office Apps - Page 85
Add-In Mania - Page 86
Add-In Mania - Page 87
Add-In Mania - Page 88
Add-In Mania - Page 89
Add-In Mania - Page 90
Book II: Worksheet Design - Page 91
Contents at a Glance - Page 92
Chapter 1: Building Worksheets - Page 93
Chapter 1: Building Worksheets - Page 94
Chapter 1: Building Worksheets - Page 95
Chapter 1: Building Worksheets - Page 96
Chapter 1: Building Worksheets - Page 97
Chapter 1: Building Worksheets - Page 98
Chapter 1: Building Worksheets - Page 99
Chapter 1: Building Worksheets - Page 100
Chapter 1: Building Worksheets - Page 101
Chapter 1: Building Worksheets - Page 102
It Takes All Kinds (Of Cell Entries) - Page 103
It Takes All Kinds (Of Cell Entries) - Page 104
It Takes All Kinds (Of Cell Entries) - Page 105
It Takes All Kinds (Of Cell Entries) - Page 106
It Takes All Kinds (Of Cell Entries) - Page 107
It Takes All Kinds (Of Cell Entries) - Page 108
It Takes All Kinds (Of Cell Entries) - Page 109
Data Entry 101 - Page 110
Data Entry 101 - Page 111
Data Entry 101 - Page 112
Data Entry 101 - Page 113
Data Entry 101 - Page 114
Data Entry 101 - Page 115
Data Entry 101 - Page 116
Data Entry 101 - Page 117
Data Entry 101 - Page 118
Data Entry 101 - Page 119
Data Entry 101 - Page 120
Data Entry 101 - Page 121
Data Entry 101 - Page 122
Data Entry 101 - Page 123
Data Entry 101 - Page 124
Data Entry 101 - Page 125
Data Entry 101 - Page 126
Data Entry 101 - Page 127
Data Entry 101 - Page 128
Data Entry 101 - Page 129
Data Entry 101 - Page 130
Data Entry 101 - Page 131
Data Entry 101 - Page 132
Data Entry 101 - Page 133
Saving the Data - Page 134
Saving the Data - Page 135
Saving the Data - Page 136
Saving the Data - Page 137
Saving the Data - Page 138
Saving the Data - Page 139
Document Recovery to the Rescue - Page 140
Document Recovery to the Rescue - Page 141
Document Recovery to the Rescue - Page 142
Chapter 2: Formatting Worksheets - Page 143
Making Cell Selections - Page 144
Making Cell Selections - Page 145
Making Cell Selections - Page 146
Making Cell Selections - Page 147
Making Cell Selections - Page 148
Making Cell Selections - Page 149
Making Cell Selections - Page 150
Making Cell Selections - Page 151
Adjusting Columns and Rows - Page 152
Adjusting Columns and Rows - Page 153
Adjusting Columns and Rows - Page 154
Adjusting Columns and Rows - Page 155
Adjusting Columns and Rows - Page 156
Formatting Tables from the Ribbon - Page 157
Formatting Tables from the Ribbon - Page 158
Formatting Tables from the Ribbon - Page 159
Formatting Tables from the Ribbon - Page 160
Formatting Tables with the Quick Analysis Tool - Page 161
Formatting Cells from the Ribbon - Page 162
Formatting Cells from the Ribbon - Page 163
Formatting Cells from the Ribbon - Page 164
Formatting Cells from the Ribbon - Page 165
Formatting Cell Ranges with the Mini-Toolbar - Page 166
Using the Format Cells Dialog Box - Page 167
Using the Format Cells Dialog Box - Page 168
Using the Format Cells Dialog Box - Page 169
Using the Format Cells Dialog Box - Page 170
Using the Format Cells Dialog Box - Page 171
Using the Format Cells Dialog Box - Page 172
Using the Format Cells Dialog Box - Page 173
Using the Format Cells Dialog Box - Page 174
Using the Format Cells Dialog Box - Page 175
Using the Format Cells Dialog Box - Page 176
Using the Format Cells Dialog Box - Page 177
Using the Format Cells Dialog Box - Page 178
Using the Format Cells Dialog Box - Page 179
Using the Format Cells Dialog Box - Page 180
Using the Format Cells Dialog Box - Page 181
Using the Format Cells Dialog Box - Page 182
Using the Format Cells Dialog Box - Page 183
Using the Format Cells Dialog Box - Page 184
Using the Format Cells Dialog Box - Page 185
Hiring Out the Format Painter - Page 186
Using Cell Styles - Page 187
Using Cell Styles - Page 188
Using Cell Styles - Page 189
Using Cell Styles - Page 190
Using Cell Styles - Page 191
Conditional Formatting - Page 192
Conditional Formatting - Page 193
Conditional Formatting - Page 194
Conditional Formatting - Page 195
Conditional Formatting - Page 196
Conditional Formatting - Page 197
Conditional Formatting - Page 198
Conditional Formatting - Page 199
Conditional Formatting - Page 200
Chapter 3: Editing and Proofing Worksheets - Page 201
Opening a Workbook - Page 202
Opening a Workbook - Page 203
Opening a Workbook - Page 204
Opening a Workbook - Page 205
Opening a Workbook - Page 206
Opening a Workbook - Page 207
Cell Editing 101 - Page 208
Cell Editing 101 - Page 209
Cell Editing 101 - Page 210
Cell Editing 101 - Page 211
Cell Editing 101 - Page 212
Cell Editing 101 - Page 213
Cell Editing 101 - Page 214
Cell Editing 101 - Page 215
A Spreadsheet with a View - Page 216
A Spreadsheet with a View - Page 217
A Spreadsheet with a View - Page 218
A Spreadsheet with a View - Page 219
A Spreadsheet with a View - Page 220
A Spreadsheet with a View - Page 221
A Spreadsheet with a View - Page 222
A Spreadsheet with a View - Page 223
Copying and Moving Stuff Around - Page 224
Copying and Moving Stuff Around - Page 225
Copying and Moving Stuff Around - Page 226
Copying and Moving Stuff Around - Page 227
Copying and Moving Stuff Around - Page 228
Copying and Moving Stuff Around - Page 229
Copying and Moving Stuff Around - Page 230
Copying and Moving Stuff Around - Page 231
Copying and Moving Stuff Around - Page 232
Copying and Moving Stuff Around - Page 233
Find and Replace This Disgrace! - Page 234
Find and Replace This Disgrace! - Page 235
Find and Replace This Disgrace! - Page 236
Find and Replace This Disgrace! - Page 237
Find and Replace This Disgrace! - Page 238
Find and Replace This Disgrace! - Page 239
Spell Checking Heaven - Page 240
Spell Checking Heaven - Page 241
Spell Checking Heaven - Page 242
Looking Up and Translating Stuff - Page 243
Marking Invalid Data - Page 244
Marking Invalid Data - Page 245
Eliminating Errors with Text to Speech - Page 246
Eliminating Errors with Text to Speech - Page 247
Eliminating Errors with Text to Speech - Page 248
Chapter 4: Managing Worksheets - Page 249
Chapter 4: Managing Worksheets - Page 250
Chapter 4: Managing Worksheets - Page 251
Chapter 4: Managing Worksheets - Page 252
Chapter 4: Managing Worksheets - Page 253
Chapter 4: Managing Worksheets - Page 254
Chapter 4: Managing Worksheets - Page 255
Chapter 4: Managing Worksheets - Page 256
Chapter 4: Managing Worksheets - Page 257
Chapter 4: Managing Worksheets - Page 258
Chapter 4: Managing Worksheets - Page 259
Chapter 4: Managing Worksheets - Page 260
Chapter 4: Managing Worksheets - Page 261
Chapter 4: Managing Worksheets - Page 262
Chapter 4: Managing Worksheets - Page 263
Chapter 4: Managing Worksheets - Page 264
Reorganizing the Workbook - Page 265
Reorganizing the Workbook - Page 266
Reorganizing the Workbook - Page 267
Reorganizing the Workbook - Page 268
Reorganizing the Workbook - Page 269
Reorganizing the Workbook - Page 270
Reorganizing the Workbook - Page 271
Reorganizing the Workbook - Page 272
Reorganizing the Workbook - Page 273
Reorganizing the Workbook - Page 274
Reorganizing the Workbook - Page 275
Working with Multiple Workbooks - Page 276
Working with Multiple Workbooks - Page 277
Working with Multiple Workbooks - Page 278
Working with Multiple Workbooks - Page 279
Consolidating Worksheets - Page 280
Consolidating Worksheets - Page 281
Consolidating Worksheets - Page 282
Consolidating Worksheets - Page 283
Consolidating Worksheets - Page 284
Consolidating Worksheets - Page 285
Consolidating Worksheets - Page 286
Chapter 5: Printing Worksheets - Page 287
Printing from the Excel 2013 Backstage View - Page 288
Printing from the Excel 2013 Backstage View - Page 289
Printing from the Excel 2013 Backstage View - Page 290
Printing from the Excel 2013 Backstage View - Page 291
Printing from the Excel 2013 Backstage View - Page 292
Printing from the Excel 2013 Backstage View - Page 293
Quick Printing the Worksheet - Page 294
Working with the Page Setup Options - Page 295
Working with the Page Setup Options - Page 296
Working with the Page Setup Options - Page 297
Working with the Page Setup Options - Page 298
Working with the Page Setup Options - Page 299
Working with the Page Setup Options - Page 300
Working with the Page Setup Options - Page 301
Working with the Page Setup Options - Page 302
Headers and Footers - Page 303
Headers and Footers - Page 304
Headers and Footers - Page 305
Headers and Footers - Page 306
Headers and Footers - Page 307
Headers and Footers - Page 308
Headers and Footers - Page 309
Solving Page Break Problems - Page 310
Solving Page Break Problems - Page 311
Printing the Formulas in a Report - Page 312
Printing the Formulas in a Report - Page 313
Printing the Formulas in a Report - Page 314
Book III: Formulas and Functions - Page 315
Contents at a Glance - Page 316
Chapter 1: Building Basic Formulas - Page 317
Formulas 101 - Page 318
Formulas 101 - Page 319
Formulas 101 - Page 320
Formulas 101 - Page 321
Formulas 101 - Page 322
Formulas 101 - Page 323
Formulas 101 - Page 324
Formulas 101 - Page 325
Formulas 101 - Page 326
Formulas 101 - Page 327
Formulas 101 - Page 328
Formulas 101 - Page 329
Copying Formulas - Page 330
Copying Formulas - Page 331
Copying Formulas - Page 332
Copying Formulas - Page 333
Copying Formulas - Page 334
Copying Formulas - Page 335
Copying Formulas - Page 336
Adding Array Formulas - Page 337
Adding Array Formulas - Page 338
Adding Array Formulas - Page 339
Adding Array Formulas - Page 340
Range Names in Formulas - Page 341
Range Names in Formulas - Page 342
Range Names in Formulas - Page 343
Range Names in Formulas - Page 344
Range Names in Formulas - Page 345
Range Names in Formulas - Page 346
Range Names in Formulas - Page 347
Range Names in Formulas - Page 348
Range Names in Formulas - Page 349
Range Names in Formulas - Page 350
Adding Linking Formulas - Page 351
Controlling Formula Recalculation - Page 352
Controlling Formula Recalculation - Page 353
Circular References - Page 354
Circular References - Page 355
Circular References - Page 356
Chapter 2: Logical Functions and Error Trapping - Page 357
Chapter 2: Logical Functions and Error Trapping - Page 358
Using Logical Functions - Page 359
Error-Trapping Formulas - Page 360
Error-Trapping Formulas - Page 361
Error-Trapping Formulas - Page 362
Error-Trapping Formulas - Page 363
Whiting-Out Errors with Conditional Formatting - Page 364
Formula Auditing - Page 365
Formula Auditing - Page 366
Formula Auditing - Page 367
Formula Auditing - Page 368
Formula Auditing - Page 369
Formula Auditing - Page 370
Formula Auditing - Page 371
Formula Auditing - Page 372
Formula Auditing - Page 373
Formula Auditing - Page 374
Formula Auditing - Page 375
Formula Auditing - Page 376
Formula Auditing - Page 377
Removing Errors from the Printout - Page 378
Chapter 3: Date and Time Formulas - Page 379
Chapter 3: Date and Time Formulas - Page 380
Chapter 3: Date and Time Formulas - Page 381
Using Date Functions - Page 382
Using Date Functions - Page 383
Using Date Functions - Page 384
Using Date Functions - Page 385
Using Date Functions - Page 386
Using Date Functions - Page 387
Using Date Functions - Page 388
Using Date Functions - Page 389
Using Time Functions - Page 390
Using Time Functions - Page 391
Using Time Functions - Page 392
Chapter 4: Financial Formulas - Page 393
The PV, NPV, and FV Functions - Page 394
The PV, NPV, and FV Functions - Page 395
The PV, NPV, and FV Functions - Page 396
The PMT Function - Page 397
The PMT Function - Page 398
The PMT Function - Page 399
The PMT Function - Page 400
Depreciation Functions - Page 401
Depreciation Functions - Page 402
Analysis ToolPak Financial Functions - Page 403
Analysis ToolPak Financial Functions - Page 404
Analysis ToolPak Financial Functions - Page 405
Analysis ToolPak Financial Functions - Page 406
Chapter 5: Math and Statistical Formulas - Page 407
Math & Trig Functions - Page 408
Math & Trig Functions - Page 409
Math & Trig Functions - Page 410
Math & Trig Functions - Page 411
Math & Trig Functions - Page 412
Math & Trig Functions - Page 413
Math & Trig Functions - Page 414
Math & Trig Functions - Page 415
Math & Trig Functions - Page 416
Statistical Functions - Page 417
Statistical Functions - Page 418
Statistical Functions - Page 419
Statistical Functions - Page 420
Statistical Functions - Page 421
Statistical Functions - Page 422
Statistical Functions - Page 423
Statistical Functions - Page 424
Statistical Functions - Page 425
Statistical Functions - Page 426
Chapter 6: Lookup, Information, and Text Formulas - Page 427
Chapter 6: Lookup, Information, and Text Formulas - Page 428
Chapter 6: Lookup, Information, and Text Formulas - Page 429
Chapter 6: Lookup, Information, and Text Formulas - Page 430
Chapter 6: Lookup, Information, and Text Formulas - Page 431
Chapter 6: Lookup, Information, and Text Formulas - Page 432
Chapter 6: Lookup, Information, and Text Formulas - Page 433
Chapter 6: Lookup, Information, and Text Formulas - Page 434
Chapter 6: Lookup, Information, and Text Formulas - Page 435
Chapter 6: Lookup, Information, and Text Formulas - Page 436
Chapter 6: Lookup, Information, and Text Formulas - Page 437
Information, Please . . . - Page 438
Information, Please . . . - Page 439
Information, Please . . . - Page 440
Information, Please . . . - Page 441
Much Ado about Text - Page 442
Much Ado about Text - Page 443
Much Ado about Text - Page 444
Much Ado about Text - Page 445
Much Ado about Text - Page 446
Much Ado about Text - Page 447
Much Ado about Text - Page 448
Book IV: Worksheet Collaboration and Review - Page 449
Contents at a Glance - Page 450
Chapter 1: Protecting Workbooks and Worksheet Data - Page 451
Chapter 1: Protecting Workbooks and Worksheet Data - Page 452
Chapter 1: Protecting Workbooks and Worksheet Data - Page 453
Chapter 1: Protecting Workbooks and Worksheet Data - Page 454
Chapter 1: Protecting Workbooks and Worksheet Data - Page 455
Chapter 1: Protecting Workbooks and Worksheet Data - Page 456
Chapter 1: Protecting Workbooks and Worksheet Data - Page 457
Protecting the Spreadsheet - Page 458
Protecting the Spreadsheet - Page 459
Protecting the Spreadsheet - Page 460
Protecting the Spreadsheet - Page 461
Protecting the Spreadsheet - Page 462
Protecting the Spreadsheet - Page 463
Protecting the Spreadsheet - Page 464
Protecting the Spreadsheet - Page 465
Protecting the Spreadsheet - Page 466
Protecting the Spreadsheet - Page 467
Protecting the Spreadsheet - Page 468
Protecting the Spreadsheet - Page 469
Protecting the Spreadsheet - Page 470
Protecting the Spreadsheet - Page 471
Protecting the Spreadsheet - Page 472
Chapter 2: Using Hyperlinks - Page 473
Chapter 2: Using Hyperlinks - Page 474
Chapter 2: Using Hyperlinks - Page 475
Chapter 2: Using Hyperlinks - Page 476
Chapter 2: Using Hyperlinks - Page 477
Chapter 2: Using Hyperlinks - Page 478
Using the HYPERLINK Function - Page 479
Using the HYPERLINK Function - Page 480
Chapter 3: Sending Workbooks Out for Review - Page 481
Chapter 3: Sending Workbooks Out for Review - Page 482
Chapter 3: Sending Workbooks Out for Review - Page 483
Chapter 3: Sending Workbooks Out for Review - Page 484
Chapter 3: Sending Workbooks Out for Review - Page 485
Chapter 3: Sending Workbooks Out for Review - Page 486
Chapter 3: Sending Workbooks Out for Review - Page 487
Workbook Sharing 101 - Page 488
Workbook Sharing 101 - Page 489
Workbook Sharing 101 - Page 490
Workbook Sharing 101 - Page 491
Workbook Sharing 101 - Page 492
Workbook Sharing 101 - Page 493
Workbook Sharing 101 - Page 494
Workbook Sharing 101 - Page 495
Workbook Sharing 101 - Page 496
Workbook Sharing 101 - Page 497
Workbook Sharing 101 - Page 498
Workbook Sharing 101 - Page 499
Workbook Sharing 101 - Page 500
Workbooks on Review - Page 501
Workbooks on Review - Page 502
Workbooks on Review - Page 503
Workbooks on Review - Page 504
Workbooks on Review - Page 505
Workbooks on Review - Page 506
Chapter 4: Sharing Workbooks and Worksheet Data - Page 507
Sharing Your Workbooks Online - Page 508
Sharing Your Workbooks Online - Page 509
Sharing Your Workbooks Online - Page 510
Sharing Your Workbooks Online - Page 511
Sharing Your Workbooks Online - Page 512
Sharing Your Workbooks Online - Page 513
Sharing Your Workbooks Online - Page 514
Sharing Your Workbooks Online - Page 515
Sharing Your Workbooks Online - Page 516
Excel 2013 Data Sharing Basics - Page 517
Excel 2013 Data Sharing Basics - Page 518
Excel 2013 Data Sharing Basics - Page 519
Excel 2013 Data Sharing Basics - Page 520
Excel 2013 Data Sharing Basics - Page 521
Excel 2013 Data Sharing Basics - Page 522
Excel 2013 Data Sharing Basics - Page 523
Excel 2013 Data Sharing Basics - Page 524
Exporting Workbooks to Other Usable File Formats - Page 525
Exporting Workbooks to Other Usable File Formats - Page 526
Exporting Workbooks to Other Usable File Formats - Page 527
Exporting Workbooks to Other Usable File Formats - Page 528
Exporting Workbooks to Other Usable File Formats - Page 529
Exporting Workbooks to Other Usable File Formats - Page 530
Book V: Charts and Graphics - Page 531
Contents at a Glance - Page 532
Chapter 1: Charting Worksheet Data - Page 533
Worksheet Charting 101 - Page 534
Worksheet Charting 101 - Page 535
Worksheet Charting 101 - Page 536
Worksheet Charting 101 - Page 537
Worksheet Charting 101 - Page 538
Worksheet Charting 101 - Page 539
Worksheet Charting 101 - Page 540
Worksheet Charting 101 - Page 541
Worksheet Charting 101 - Page 542
Worksheet Charting 101 - Page 543
Worksheet Charting 101 - Page 544
Worksheet Charting 101 - Page 545
Worksheet Charting 101 - Page 546
Worksheet Charting 101 - Page 547
Worksheet Charting 101 - Page 548
Worksheet Charting 101 - Page 549
Worksheet Charting 101 - Page 550
Worksheet Charting 101 - Page 551
Worksheet Charting 101 - Page 552
Worksheet Charting 101 - Page 553
Worksheet Charting 101 - Page 554
Worksheet Charting 101 - Page 555
Worksheet Charting 101 - Page 556
Worksheet Charting 101 - Page 557
Worksheet Charting 101 - Page 558
Worksheet Charting 101 - Page 559
Adding Sparkline Graphics to a Worksheet - Page 560
Adding Sparkline Graphics to a Worksheet - Page 561
Printing Charts - Page 562
Chapter 2: Adding Graphic Objects - Page 563
Graphic Objects 101 - Page 564
Graphic Objects 101 - Page 565
Graphic Objects 101 - Page 566
Graphic Objects 101 - Page 567
Graphic Objects 101 - Page 568
Graphic Objects 101 - Page 569
Graphic Objects 101 - Page 570
Graphic Objects 101 - Page 571
Inserting Different Types of Graphics - Page 572
Inserting Different Types of Graphics - Page 573
Inserting Different Types of Graphics - Page 574
Inserting Different Types of Graphics - Page 575
Inserting Different Types of Graphics - Page 576
Inserting Different Types of Graphics - Page 577
Inserting Different Types of Graphics - Page 578
Drawing Graphics - Page 579
Drawing Graphics - Page 580
Drawing Graphics - Page 581
Drawing Graphics - Page 582
Drawing Graphics - Page 583
Drawing Graphics - Page 584
Drawing Graphics - Page 585
Drawing Graphics - Page 586
Drawing Graphics - Page 587
Drawing Graphics - Page 588
Adding Screenshots of the Windows Desktop - Page 589
Adding Screenshots of the Windows Desktop - Page 590
Using Themes - Page 591
Using Themes - Page 592
Book VI: Data Management - Page 593
Contents at a Glance - Page 594
Chapter 1: Building and Maintaining Data Lists - Page 595
Chapter 1: Building and Maintaining Data Lists - Page 596
Chapter 1: Building and Maintaining Data Lists - Page 597
Chapter 1: Building and Maintaining Data Lists - Page 598
Chapter 1: Building and Maintaining Data Lists - Page 599
Chapter 1: Building and Maintaining Data Lists - Page 600
Chapter 1: Building and Maintaining Data Lists - Page 601
Chapter 1: Building and Maintaining Data Lists - Page 602
Chapter 1: Building and Maintaining Data Lists - Page 603
Chapter 1: Building and Maintaining Data Lists - Page 604
Chapter 1: Building and Maintaining Data Lists - Page 605
Sorting Data - Page 606
Sorting Data - Page 607
Sorting Data - Page 608
Sorting Data - Page 609
Sorting Data - Page 610
Sorting Data - Page 611
Sorting Data - Page 612
Sorting Data - Page 613
Sorting Data - Page 614
Subtotaling Data - Page 615
Subtotaling Data - Page 616
Subtotaling Data - Page 617
Subtotaling Data - Page 618
Chapter 2: Filtering and Querying a Data List - Page 619
Data List Filtering 101 - Page 620
Data List Filtering 101 - Page 621
Data List Filtering 101 - Page 622
Data List Filtering 101 - Page 623
Data List Filtering 101 - Page 624
Data List Filtering 101 - Page 625
Data List Filtering 101 - Page 626
Data List Filtering 101 - Page 627
Data List Filtering 101 - Page 628
Data List Filtering 101 - Page 629
Data List Filtering 101 - Page 630
Data List Filtering 101 - Page 631
Data List Filtering 101 - Page 632
Data List Filtering 101 - Page 633
Data List Filtering 101 - Page 634
Data List Filtering 101 - Page 635
Data List Filtering 101 - Page 636
Data List Filtering 101 - Page 637
Using the Database Functions - Page 638
Using the Database Functions - Page 639
External Data Query - Page 640
External Data Query - Page 641
External Data Query - Page 642
External Data Query - Page 643
External Data Query - Page 644
External Data Query - Page 645
External Data Query - Page 646
External Data Query - Page 647
External Data Query - Page 648
External Data Query - Page 649
External Data Query - Page 650
External Data Query - Page 651
External Data Query - Page 652
External Data Query - Page 653
External Data Query - Page 654
External Data Query - Page 655
External Data Query - Page 656
External Data Query - Page 657
External Data Query - Page 658
External Data Query - Page 659
External Data Query - Page 660
Book VII: Data Analysis - Page 661
Contents at a Glance - Page 662
Chapter 1: Performing What-If Scenarios - Page 663
Using Data Tables - Page 664
Using Data Tables - Page 665
Using Data Tables - Page 666
Using Data Tables - Page 667
Using Data Tables - Page 668
Using Data Tables - Page 669
Exploring Different Scenarios - Page 670
Exploring Different Scenarios - Page 671
Exploring Different Scenarios - Page 672
Exploring Different Scenarios - Page 673
Exploring Different Scenarios - Page 674
Hide and Goal Seeking - Page 675
Hide and Goal Seeking - Page 676
Using the Solver - Page 677
Using the Solver - Page 678
Using the Solver - Page 679
Using the Solver - Page 680
Using the Solver - Page 681
Using the Solver - Page 682
Using the Solver - Page 683
Using the Solver - Page 684
Chapter 2: Generating Pivot Tables - Page 685
Creating Pivot Tables - Page 686
Creating Pivot Tables - Page 687
Creating Pivot Tables - Page 688
Creating Pivot Tables - Page 689
Creating Pivot Tables - Page 690
Creating Pivot Tables - Page 691
Creating Pivot Tables - Page 692
Creating Pivot Tables - Page 693
Formatting a Pivot Table - Page 694
Formatting a Pivot Table - Page 695
Formatting a Pivot Table - Page 696
Formatting a Pivot Table - Page 697
Formatting a Pivot Table - Page 698
Sorting and Filtering the Pivot Table Data - Page 699
Sorting and Filtering the Pivot Table Data - Page 700
Sorting and Filtering the Pivot Table Data - Page 701
Sorting and Filtering the Pivot Table Data - Page 702
Sorting and Filtering the Pivot Table Data - Page 703
Sorting and Filtering the Pivot Table Data - Page 704
Modifying the Pivot Table - Page 705
Modifying the Pivot Table - Page 706
Modifying the Pivot Table - Page 707
Modifying the Pivot Table - Page 708
Modifying the Pivot Table - Page 709
Modifying the Pivot Table - Page 710
Creating Pivot Charts - Page 711
Creating Pivot Charts - Page 712
Using the PowerPivot and Power View Add-Ins - Page 713
Using the PowerPivot and Power View Add-Ins - Page 714
Using the PowerPivot and Power View Add-Ins - Page 715
Using the PowerPivot and Power View Add-Ins - Page 716
Using the PowerPivot and Power View Add-Ins - Page 717
Using the PowerPivot and Power View Add-Ins - Page 718
Using the PowerPivot and Power View Add-Ins - Page 719
Using the PowerPivot and Power View Add-Ins - Page 720
Using the PowerPivot and Power View Add-Ins - Page 721
Using the PowerPivot and Power View Add-Ins - Page 722
Using the PowerPivot and Power View Add-Ins - Page 723
Using the PowerPivot and Power View Add-Ins - Page 724
Book VIII: Macros and VBA - Page 725
Contents at a Glance - Page 726
Chapter 1: Building and Running Macros - Page 727
Macro Basics - Page 728
Macro Basics - Page 729
Macro Basics - Page 730
Macro Basics - Page 731
Macro Basics - Page 732
Macro Basics - Page 733
Macro Security - Page 734
Macro Security - Page 735
Assigning Macros to the Ribbon and the Quick Access Toolbar - Page 736
Assigning Macros to the Ribbon and the Quick Access Toolbar - Page 737
Assigning Macros to the Ribbon and the Quick Access Toolbar - Page 738
Chapter 2: VBA Programming - Page 739
Using the Visual Basic Editor - Page 740
Using the Visual Basic Editor - Page 741
Using the Visual Basic Editor - Page 742
Using the Visual Basic Editor - Page 743
Using the Visual Basic Editor - Page 744
Using the Visual Basic Editor - Page 745
Using the Visual Basic Editor - Page 746
Using the Visual Basic Editor - Page 747
Using the Visual Basic Editor - Page 748
Using the Visual Basic Editor - Page 749
Using the Visual Basic Editor - Page 750
Using the Visual Basic Editor - Page 751
Using the Visual Basic Editor - Page 752
Creating Custom Excel Functions - Page 753
Creating Custom Excel Functions - Page 754
Creating Custom Excel Functions - Page 755
Creating Custom Excel Functions - Page 756
Creating Custom Excel Functions - Page 757
Creating Custom Excel Functions - Page 758
Creating Custom Excel Functions - Page 759
Creating Custom Excel Functions - Page 760
Creating Custom Excel Functions - Page 761
Creating Custom Excel Functions - Page 762