Microsoft Excel 2013

Part 1: Examining the Excel environment - Page 27
Part 1: Examining the Excel environment - Page 28
Chapter 1: What’s new in Microsoft Excel 2013 - Page 29
New and improved for 2013 - Page 30
Quick analysis - Page 31
Recommended charts - Page 32
New chart-formatting controls - Page 33
Timeline - Page 34
Timeline - Page 35
Retired in 2013 - Page 36
If you missed the last two upgrades - Page 37
If you missed the last two upgrades - Page 38
If you missed the last two upgrades - Page 39
Moving onward with Office 2013 - Page 40
Chapter 2: Exploring Excel fundamentals - Page 41
Using the workbook window - Page 42
Using the workbook window - Page 43
Using the workbook window - Page 44
Using the workbook window - Page 45
Using the workbook window - Page 46
Using the workbook window - Page 47
Exploring the ribbon - Page 48
Exploring the ribbon - Page 49
Exploring the ribbon - Page 50
Exploring the ribbon - Page 51
Exploring the ribbon - Page 52
Exploring the ribbon - Page 53
Exploring the ribbon - Page 54
Exploring the ribbon - Page 55
Using the Quick Access Toolbar - Page 56
Accessing commands with the keyboard - Page 57
The joy of shortcut menus - Page 58
Using the Quick Analysis tool - Page 59
Meet the formula bar - Page 60
Meet the formula bar - Page 61
Meet the formula bar - Page 62
Facts about the status bar - Page 63
Facts about the status bar - Page 64
Introducing Backstage view - Page 65
Exploring file-management fundamentals - Page 66
Exploring file-management fundamentals - Page 67
Exploring file-management fundamentals - Page 68
Exploring file-management fundamentals - Page 69
Saving files - Page 70
Saving files - Page 71
Saving files - Page 72
Saving files - Page 73
Saving files - Page 74
Saving files - Page 75
Saving files - Page 76
Saving files - Page 77
Saving files - Page 78
Saving files - Page 79
Saving files - Page 80
Saving files - Page 81
Saving files - Page 82
Opening files - Page 83
Opening files - Page 84
Opening files - Page 85
Opening files - Page 86
Importing and exporting files - Page 87
Importing and exporting files - Page 88
Sharing data with Excel for the Macintosh - Page 89
Sharing data beyond Excel - Page 90
Sharing data beyond Excel - Page 91
Sharing data beyond Excel - Page 92
Using the Help system - Page 93
Help in depth - Page 94
Help in depth - Page 95
Help in depth - Page 96
Recovering from crashes - Page 97
Managing versions - Page 98
Managing versions - Page 99
Managing versions - Page 100
Chapter 3: Custom-tailoring the Excel workspace - Page 101
Chapter 3: Custom-tailoring the Excel workspace - Page 102
Chapter 3: Custom-tailoring the Excel workspace - Page 103
Identifying items in the Customize Ribbon and Quick Access Toolbar categories - Page 104
Creating a custom ribbon tab - Page 105
Creating a custom command group - Page 106
Adding existing command groups to custom tabs - Page 107
Adding existing command groups to custom tabs - Page 108
Resetting and recycling your customizations - Page 109
Customizing the Quick Access Toolbar - Page 110
Customizing the Quick Access Toolbar - Page 111
Adding tools to the toolbar - Page 112
Adding tools to the toolbar - Page 113
Adding tools to the toolbar - Page 114
Adding tools to the toolbar - Page 115
Creating your own buttons - Page 116
Saving and resetting your custom Quick Access Toolbar - Page 117
Restoring the toolbar - Page 118
Restoring the toolbar - Page 119
Exploring other toolbar and ribbon options - Page 120
Controlling other elements of the Excel 2010 interface - Page 121
Controlling other elements of the Excel 2010 interface - Page 122
Displaying underlying formulas - Page 123
Hiding zeros - Page 124
Enhancing accessibility - Page 125
Enhancing accessibility - Page 126
Installing apps - Page 127
Installing apps - Page 128
Installing apps - Page 129
Installing apps - Page 130
Chapter 4: Security and privacy - Page 131
Chapter 4: Security and privacy - Page 132
Trusted publishers, locations, and documents - Page 133
App catalogs, add-ins, ActiveX settings, and macro settings - Page 134
App catalogs, add-ins, ActiveX settings, and macro settings - Page 135
App catalogs, add-ins, ActiveX settings, and macro settings - Page 136
Message bar - Page 137
File block settings - Page 138
Privacy options - Page 139
Privacy options - Page 140
File security - Page 141
Using digital signatures - Page 142
Using digital signatures - Page 143
Using digital signatures - Page 144
Using digital signatures - Page 145
Other security features - Page 146
Part 2: Building worksheets - Page 147
Part 2: Building worksheets - Page 148
Chapter 5: Planning your worksheet design - Page 149
Chapter 5: Planning your worksheet design - Page 150
Will you need to print the worksheet? - Page 151
Who is the audience? - Page 152
Would your worksheet survive without you? - Page 153
Would your worksheet survive without you? - Page 154
Do you need more than one worksheet? - Page 155
Do you need more than one worksheet? - Page 156
Chapter 6: How to work a worksheet - Page 157
Navigating regions with the keyboard - Page 158
Navigating regions with the keyboard - Page 159
Navigating with special keys - Page 160
Selecting with the mouse - Page 161
Selecting with the mouse - Page 162
Selecting with the mouse - Page 163
Using the find and select commands - Page 164
Selecting with Go To Special - Page 165
Selecting with Go To Special - Page 166
Selecting with Go To Special - Page 167
Selecting with Go To Special - Page 168
Techniques for entering data - Page 169
Techniques for entering data - Page 170
Techniques for entering data - Page 171
Techniques for entering data - Page 172
Techniques for entering data - Page 173
Techniques for entering data - Page 174
Techniques for entering data - Page 175
Techniques for entering data - Page 176
Making entries in ranges - Page 177
Editing and undoing entries - Page 178
Editing and undoing entries - Page 179
Managing worksheets - Page 180
Managing worksheets - Page 181
Naming and renaming worksheets - Page 182
Naming and renaming worksheets - Page 183
Naming and renaming worksheets - Page 184
Viewing worksheets - Page 185
Freezing panes - Page 186
Freezing panes - Page 187
Zooming worksheets - Page 188
Zooming worksheets - Page 189
Using custom views - Page 190
Protecting worksheets - Page 191
Protecting worksheets - Page 192
Protecting the workbook - Page 193
Protecting the workbook - Page 194
Protecting the workbook - Page 195
Hiding cells and worksheets - Page 196
Using passwords - Page 197
Using passwords - Page 198
Chapter 7: How to work a workbook - Page 199
Arranging workbook windows - Page 200
Arranging workbook windows - Page 201
Comparing worksheets side by side - Page 202
Comparing worksheets side by side - Page 203
Opening multiple windows for the same workbook - Page 204
Useful inconsistencies of new windows - Page 205
Useful inconsistencies of new windows - Page 206
Useful inconsistencies of new windows - Page 207
Hiding and protecting workbooks - Page 208
Protecting workbooks - Page 209
Encrypting workbooks - Page 210
Saving workbooks or windows as hidden - Page 211
Saving workbooks or windows as hidden - Page 212
Saving workbooks or windows as hidden - Page 213
Saving workbooks or windows as hidden - Page 214
Part 3: Formatting and ­editing worksheets - Page 215
Part 3: Formatting and ­editing worksheets - Page 216
Chapter 8: Worksheet editing techniques - Page 217
Copying and pasting - Page 218
Copying and pasting - Page 219
Copying and pasting - Page 220
Copying and pasting - Page 221
Copying and pasting - Page 222
Cutting and pasting - Page 223
Cutting and pasting - Page 224
Cutting and pasting - Page 225
Cutting and pasting - Page 226
Cutting and pasting - Page 227
Cutting and pasting - Page 228
Pasting hyperlinks - Page 229
Moving and copying with the mouse - Page 230
Moving and copying with the mouse - Page 231
Inserting and deleting - Page 232
Inserting and deleting - Page 233
Inserting cells - Page 234
Inserting cells - Page 235
Deleting cells, columns, and rows - Page 236
Deleting cells, columns, and rows - Page 237
Deleting cells, columns, and rows - Page 238
Deleting cells, columns, and rows - Page 239
Clearing cells - Page 240
Clearing cells - Page 241
Dragging with the right mouse button - Page 242
Undoing previous actions - Page 243
Redoing what you’ve undone - Page 244
Editing cell contents - Page 245
Editing options - Page 246
Editing options - Page 247
Editing options - Page 248
Filling cells and creating data series - Page 249
Filling cells and creating data series - Page 250
Filling cells and creating data series - Page 251
Filling cells and creating data series - Page 252
Filling cells and creating data series - Page 253
Filling cells and creating data series - Page 254
Filling cells and creating data series - Page 255
Filling cells and creating data series - Page 256
Filling cells and creating data series - Page 257
Filling cells and creating data series - Page 258
Filling cells and creating data series - Page 259
Filling cells and creating data series - Page 260
Filling cells and creating data series - Page 261
Controlling automatic formatting - Page 262
Finding and replacing stuff - Page 263
Finding and replacing stuff - Page 264
Finding and replacing stuff - Page 265
Finding formatting - Page 266
Finding formatting - Page 267
Specifying variables using wildcard characters - Page 268
Specifying variables using wildcard characters - Page 269
Getting the words right - Page 270
Getting the words right - Page 271
Getting the words right - Page 272
Letting Excel help with typing chores - Page 273
Letting Excel help with typing chores - Page 274
Cheking yer speling - Page 275
Research resources - Page 276
Research resources - Page 277
Research resources - Page 278
Editing multiple worksheets - Page 279
Editing multiple worksheets - Page 280
Editing multiple worksheets - Page 281
Editing multiple worksheets - Page 282
Editing multiple worksheets - Page 283
Filling a group - Page 284
Auditing and documenting worksheets - Page 285
Auditing and documenting worksheets - Page 286
Auditing and documenting worksheets - Page 287
Auditing and documenting worksheets - Page 288
Auditing and documenting worksheets - Page 289
Tracing cell references - Page 290
Tracing cell references - Page 291
Tracing cell references - Page 292
Tracing cell references - Page 293
Tracing cell references - Page 294
Adding comments to cells - Page 295
Adding comments to cells - Page 296
Outlining worksheets - Page 297
Outlining worksheets - Page 298
Outlining a worksheet with nonstandard layout - Page 299
Extending the outline to new worksheet areas - Page 300
Displaying a specific outline level - Page 301
Ungrouping and grouping columns and rows - Page 302
Ungrouping and grouping columns and rows - Page 303
Consolidating by position - Page 304
Consolidating by position - Page 305
Consolidating by category - Page 306
Consolidating by category - Page 307
Consolidating by category - Page 308
Consolidating by category - Page 309
Consolidating by category - Page 310
Chapter 9: Worksheet formatting techniques - Page 311
Formatting fundamentals - Page 312
Formatting fundamentals - Page 313
Formatting tables - Page 314
Formatting tables - Page 315
Formatting tables - Page 316
Formatting tables - Page 317
Formatting tables - Page 318
Formatting tables - Page 319
Formatting tables - Page 320
Formatting tables - Page 321
Painting formats - Page 322
Painting formats - Page 323
Painting formats - Page 324
Formatting with cell styles - Page 325
Formatting with cell styles - Page 326
Formatting with cell styles - Page 327
Formatting with cell styles - Page 328
Formatting with cell styles - Page 329
Formatting with cell styles - Page 330
Formatting with cell styles - Page 331
Formatting conditionally - Page 332
Formatting conditionally - Page 333
Formatting conditionally - Page 334
Formatting conditionally - Page 335
Formatting conditionally - Page 336
Creating conditional formatting rules - Page 337
Managing conditional formatting rules - Page 338
Managing conditional formatting rules - Page 339
Managing conditional formatting rules - Page 340
Creating conditional formatting formulas - Page 341
Creating conditional formatting formulas - Page 342
Formatting in depth - Page 343
Formatting as you type - Page 344
Understanding the General format - Page 345
Formatting numbers - Page 346
Formatting numbers - Page 347
Formatting numbers - Page 348
Formatting numbers - Page 349
Formatting numbers - Page 350
Formatting numbers - Page 351
Formatting numbers - Page 352
Formatting numbers - Page 353
Formatting numbers - Page 354
Formatting numbers - Page 355
Formatting numbers - Page 356
Formatting numbers - Page 357
Formatting numbers - Page 358
Formatting numbers - Page 359
Formatting numbers - Page 360
Formatting numbers - Page 361
Formatting numbers - Page 362
Formatting numbers - Page 363
Formatting numbers - Page 364
Aligning data in cells - Page 365
Aligning data in cells - Page 366
Aligning data in cells - Page 367
Aligning data in cells - Page 368
Aligning data in cells - Page 369
Aligning text vertically - Page 370
Aligning text vertically - Page 371
Aligning text vertically - Page 372
Aligning text vertically - Page 373
Using fonts - Page 374
Using fonts - Page 375
Customizing borders - Page 376
Customizing borders - Page 377
Customizing borders - Page 378
Customizing borders - Page 379
Applying colors and patterns - Page 380
Applying colors and patterns - Page 381
Applying colors and patterns - Page 382
Applying colors and patterns - Page 383
Applying colors and patterns - Page 384
Controlling the size of cells - Page 385
Controlling the size of cells - Page 386
Controlling the size of cells - Page 387
Controlling the size of cells - Page 388
Controlling the size of cells - Page 389
Controlling the size of cells - Page 390
Using template files to store formatting - Page 391
Using template files to store formatting - Page 392
Using template files to store formatting - Page 393
Using template files to store formatting - Page 394
Part 4: Adding graphics and printing - Page 395
Part 4: Adding graphics and printing - Page 396
Chapter 10: Creating and formatting graphics - Page 397
Using the Shapes tools - Page 398
Using the Shapes tools - Page 399
Drawing constrained objects - Page 400
Drawing constrained objects - Page 401
Drawing freehand lines and polygons - Page 402
Drawing freehand lines and polygons - Page 403
Drawing freehand lines and polygons - Page 404
Working with text boxes - Page 405
Working with text boxes - Page 406
Working with shapes - Page 407
Working with shapes - Page 408
Working with shapes - Page 409
Working with shapes - Page 410
Working with shapes - Page 411
Creating WordArt - Page 412
Creating WordArt - Page 413
Creating SmartArt - Page 414
Creating SmartArt - Page 415
Creating SmartArt - Page 416
Creating SmartArt - Page 417
Creating SmartArt - Page 418
Inserting other graphics - Page 419
Inserting pictures - Page 420
Inserting pictures - Page 421
Inserting other objects - Page 422
Inserting other objects - Page 423
Inserting other objects - Page 424
Formatting graphics - Page 425
Formatting graphics - Page 426
Formatting graphics - Page 427
Formatting graphics - Page 428
Formatting graphics - Page 429
Formatting graphics - Page 430
Using drawing tools - Page 431
Using drawing tools - Page 432
Using SmartArt tools - Page 433
Using SmartArt tools - Page 434
Applying compression to pictures - Page 435
Using advanced object formatting effects - Page 436
Using advanced object formatting effects - Page 437
Using advanced object formatting effects - Page 438
Using advanced object formatting effects - Page 439
Using advanced object formatting effects - Page 440
Using advanced object formatting effects - Page 441
Using advanced object formatting effects - Page 442
Using advanced object formatting effects - Page 443
Using advanced object formatting effects - Page 444
Formatting embedded objects - Page 445
Working with graphic objects - Page 446
Working with graphic objects - Page 447
Positioning objects - Page 448
Positioning objects - Page 449
Positioning objects - Page 450
Positioning objects - Page 451
Positioning objects - Page 452
Positioning objects - Page 453
Protecting objects - Page 454
More tricks with graphic objects - Page 455
Creating screenshots or pictures of your worksheets - Page 456
Creating screenshots or pictures of your worksheets - Page 457
Creating screenshots or pictures of your worksheets - Page 458
Creating screenshots or pictures of your worksheets - Page 459
Creating screenshots or pictures of your worksheets - Page 460
Creating screenshots or pictures of your worksheets - Page 461
Creating screenshots or pictures of your worksheets - Page 462
Chapter 11: Printing and presenting - Page 463
Chapter 11: Printing and presenting - Page 464
Chapter 11: Printing and presenting - Page 465
Chapter 11: Printing and presenting - Page 466
Working in Page Layout view - Page 467
Working in Page Layout view - Page 468
Setting margins - Page 469
Setting margins - Page 470
Creating a header and footer - Page 471
Creating a header and footer - Page 472
Creating a header and footer - Page 473
Creating a header and footer - Page 474
Creating a header and footer - Page 475
Creating a header and footer - Page 476
Setting worksheet options - Page 477
Setting worksheet options - Page 478
Setting worksheet options - Page 479
Setting worksheet options - Page 480
Controlling what and where to print - Page 481
Controlling what and where to print - Page 482
Adjusting page breaks - Page 483
Inserting and removing manual page breaks - Page 484
Using Print Preview - Page 485
Using Print Preview - Page 486
Creating portable documents - Page 487
Creating portable documents - Page 488
Creating portable documents - Page 489
Creating portable documents - Page 490
Part 5: Creating formulas and performing data analysis - Page 491
Part 5: Creating formulas and performing data analysis - Page 492
Chapter 12: Building formulas - Page 493
Chapter 12: Building formulas - Page 494
Using cell references in formulas - Page 495
Using cell references in formulas - Page 496
Using cell references in formulas - Page 497
Using cell references in formulas - Page 498
Using cell references in formulas - Page 499
Using cell references in formulas - Page 500
Using cell references in formulas - Page 501
Using cell references in formulas - Page 502
Editing formulas - Page 503
Editing formulas - Page 504
Editing formulas - Page 505
Understanding error values - Page 506
Using the Sum button - Page 507
Inserting a function - Page 508
Using Formula AutoComplete - Page 509
Working with formulas - Page 510
Working with formulas - Page 511
Working with formulas - Page 512
Working with formulas - Page 513
Working with formulas - Page 514
Working with formulas - Page 515
Working with formulas - Page 516
Working with formulas - Page 517
Working with formulas - Page 518
Working with formulas - Page 519
Working with formulas - Page 520
Working with formulas - Page 521
Getting explicit about intersections - Page 522
Formula-bar formatting - Page 523
Using structured references - Page 524
Using structured references - Page 525
Using structured references - Page 526
Using structured references - Page 527
Using structured references - Page 528
Using structured references - Page 529
Using structured references - Page 530
Worksheet calculation - Page 531
Recalculating manually - Page 532
Calculating part of a formula - Page 533
Working with circular references - Page 534
Working with circular references - Page 535
Working with circular references - Page 536
Understanding the precision of numeric values - Page 537
Using arrays - Page 538
Using arrays - Page 539
Array formula rules - Page 540
Single-cell array formulas - Page 541
Using array constants - Page 542
Understanding array expansion - Page 543
Saving linked workbooks - Page 544
Opening a dependent workbook - Page 545
Copying, cutting, and pasting in linked workbooks - Page 546
Creating conditional tests - Page 547
Using conditional functions - Page 548
Using conditional functions - Page 549
Using conditional functions - Page 550
Using lookup functions - Page 551
Using lookup functions - Page 552
Chapter 13: Using functions - Page 553
Chapter 13: Using functions - Page 554
Chapter 13: Using functions - Page 555
Chapter 13: Using functions - Page 556
Exploring the syntax of functions - Page 557
Types of arguments - Page 558
Inserting functions - Page 559
Inserting functions - Page 560
Inserting functions - Page 561
Inserting references and names - Page 562
Chapter 14: Everyday functions - Page 563
Using selected mathematical functions - Page 564
Using selected mathematical functions - Page 565
Using selected mathematical functions - Page 566
Using selected mathematical functions - Page 567
Using the rounding functions - Page 568
Using the rounding functions - Page 569
Using the rounding functions - Page 570
Understanding text functions - Page 571
Understanding text functions - Page 572
Understanding text functions - Page 573
Using the substring text functions - Page 574
Using the substring text functions - Page 575
Using the substring text functions - Page 576
Understanding logical functions - Page 577
Understanding logical functions - Page 578
Understanding logical functions - Page 579
Understanding information functions - Page 580
Understanding information functions - Page 581
Understanding lookup and reference functions - Page 582
Understanding lookup and reference functions - Page 583
Understanding lookup and reference functions - Page 584
Understanding lookup and reference functions - Page 585
Understanding lookup and reference functions - Page 586
Understanding lookup and reference functions - Page 587
Understanding lookup and reference functions - Page 588
Understanding lookup and reference functions - Page 589
Understanding lookup and reference functions - Page 590
Chapter 15: Formatting and calculating date and time - Page 591
Entering dates and times - Page 592
Entering dates and times - Page 593
Entering a series of dates - Page 594
Entering a series of dates - Page 595
Entering a series of dates - Page 596
Formatting dates and times - Page 597
Creating your own date and time formats - Page 598
Creating your own date and time formats - Page 599
Creating your own date and time formats - Page 600
Creating your own date and time formats - Page 601
Calculating with date and time - Page 602
Working with date and time functions - Page 603
Working with date and time functions - Page 604
Working with specialized date functions - Page 605
Working with specialized date functions - Page 606
Working with specialized date functions - Page 607
Working with specialized date functions - Page 608
Chapter 16: Functions for financial analysis - Page 609
The PV function - Page 610
The NPV function - Page 611
The FV function - Page 612
The IPMT function - Page 613
The PPMT function - Page 614
The IRR function - Page 615
The MIRR function - Page 616
The SLN function - Page 617
The VDB function - Page 618
Analyzing securities - Page 619
The DOLLARDE and DOLLARFR functions - Page 620
The INTRATE and RECEIVED functions - Page 621
The DISC function - Page 622
The COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, and COUPPCD functions - Page 623
Using the Euro Currency Tools add-in - Page 624
Using the Euro Currency Tools add-in - Page 625
Using the Euro Currency Tools add-in - Page 626
Chapter 17: Functions for analyzing statistics - Page 627
Chapter 17: Functions for analyzing statistics - Page 628
Chapter 17: Functions for analyzing statistics - Page 629
Using functions that analyze rank and percentile - Page 630
Using functions that analyze rank and percentile - Page 631
Using functions that analyze rank and percentile - Page 632
Using sample and population statistical functions - Page 633
Understanding linear and exponential regression - Page 634
Calculating linear regression - Page 635
Calculating linear regression - Page 636
Calculating linear regression - Page 637
Calculating linear regression - Page 638
Calculating linear regression - Page 639
Calculating linear regression - Page 640
Calculating exponential regression - Page 641
Using the Analysis Toolpak data analysis tools - Page 642
Using the Descriptive Statistics tool - Page 643
Using the Descriptive Statistics tool - Page 644
Creating histograms - Page 645
Creating histograms - Page 646
Creating histograms - Page 647
Using the Rank And Percentile tool - Page 648
Using the Rank And Percentile tool - Page 649
Using the Rank And Percentile tool - Page 650
Generating random numbers - Page 651
Generating random numbers - Page 652
Generating random numbers - Page 653
Generating random numbers - Page 654
Sampling a population of numbers - Page 655
Calculating moving averages - Page 656
Calculating moving averages - Page 657
Calculating moving averages - Page 658
Chapter 18: Performing a what-if analysis - Page 659
Chapter 18: Performing a what-if analysis - Page 660
Chapter 18: Performing a what-if analysis - Page 661
Single-variable tables with more than one formula - Page 662
Single-variable tables with more than one formula - Page 663
Editing tables - Page 664
Using the Scenario Manager - Page 665
Using the Scenario Manager - Page 666
Defining scenarios - Page 667
Defining scenarios - Page 668
Browsing your scenarios - Page 669
Adding, editing, and deleting scenarios - Page 670
Adding, editing, and deleting scenarios - Page 671
Creating scenario reports - Page 672
Creating scenario reports - Page 673
Creating scenario reports - Page 674
Using the Goal Seek command - Page 675
Using the Goal Seek command - Page 676
Precision and multiple solutions - Page 677
Using the Solver - Page 678
Using the Solver - Page 679
Stating the objective - Page 680
Specifying variable cells - Page 681
Specifying variable cells - Page 682
Specifying variable cells - Page 683
Other Solver options - Page 684
Other Solver options - Page 685
Other Solver options - Page 686
Saving and reusing the Solver parameters - Page 687
Saving and reusing the Solver parameters - Page 688
Saving and reusing the Solver parameters - Page 689
Saving and reusing the Solver parameters - Page 690
Part 6: Creating charts - Page 691
Part 6: Creating charts - Page 692
Chapter 19: Designing charts - Page 693
Creating a new chart - Page 694
Creating a new chart - Page 695
Creating a new chart - Page 696
Creating a new chart - Page 697
Changing the chart type - Page 698
Changing the chart type - Page 699
Assigning a series to a secondary axis - Page 700
Assigning a series to a secondary axis - Page 701
Switching rows and columns - Page 702
Switching rows and columns - Page 703
Choosing a chart layout - Page 704
Moving the chart to a separate chart sheet - Page 705
Adding, editing, and removing a chart title - Page 706
Adding, editing, and removing a legend - Page 707
Adding and positioning data labels - Page 708
Adding and editing axis titles - Page 709
Changing the scale of a value axis - Page 710
Changing the scale of a category axis - Page 711
Changing the scale of a category axis - Page 712
Changing the scale of a category axis - Page 713
Changing the scale of a category axis - Page 714
Changing the scale of a category axis - Page 715
Modifying a chart’s data - Page 716
Filtering chart data - Page 717
Plotting noncontiguous source ranges - Page 718
Adding moving averages and other trendlines - Page 719
Adding error bars - Page 720
Adding error bars - Page 721
Adding error bars - Page 722
Chapter 20: Formatting charts - Page 723
Selecting chart elements - Page 724
Repositioning chart elements with the mouse - Page 725
Repositioning chart elements with the mouse - Page 726
Repositioning chart elements with the mouse - Page 727
Formatting areas - Page 728
Filling an area with a texture or picture - Page 729
Making areas transparent - Page 730
Formatting text - Page 731
Changing the rotation of axis labels - Page 732
Changing the interval between axis labels - Page 733
Changing the position of axis labels - Page 734
Changing the numeric format used by axis labels - Page 735
Changing the numeric format used by axis labels - Page 736
Chapter 21: Using sparklines - Page 737
Creating sparklines - Page 738
Creating groups of sparklines - Page 739
Customizing sparklines - Page 740
Customizing axes - Page 741
Customizing axes - Page 742
Adding text to sparklines - Page 743
Adding text to sparklines - Page 744
Part 7: Managing databases and tables - Page 745
Part 7: Managing databases and tables - Page 746
Chapter 22: Managing information in tables - Page 747
Chapter 22: Managing information in tables - Page 748
How to organize a table - Page 749
Overwriting default headers - Page 750
Naming a table - Page 751
Naming a table - Page 752
Naming a table - Page 753
Adding totals to a table - Page 754
Adding totals to a table - Page 755
Sorting tables and other ranges - Page 756
Sorting on more than one column - Page 757
Sorting on more than one column - Page 758
Sorting only part of a list - Page 759
Sorting only part of a list - Page 760
Sorting cells that contain formulas - Page 761
Sorting cells that contain formulas - Page 762
Sorting months, weekdays, or custom lists - Page 763
Performing a case-sensitive sort - Page 764
Filtering a list or table - Page 765
Filtering a list or table - Page 766
Filtering a list or table - Page 767
Filtering a list or table - Page 768
Filtering a list or table - Page 769
Using the Advanced Filter command - Page 770
Using the Advanced Filter command - Page 771
Using the Advanced Filter command - Page 772
Using the Advanced Filter command - Page 773
Using the Advanced Filter command - Page 774
Using the Advanced Filter command - Page 775
Using the Advanced Filter command - Page 776
Using the Advanced Filter command - Page 777
Using the Advanced Filter command - Page 778
Removing duplicate records - Page 779
Using formulas with tables - Page 780
Using formulas with tables - Page 781
Referencing the total row - Page 782
Referencing the total row - Page 783
Explicitly referencing the current row - Page 784
Referencing parts of a table - Page 785
Formatting tables - Page 786
Formatting tables - Page 787
Using themes to change style appearance - Page 788
Customizing table styles - Page 789
Customizing table styles - Page 790
Customizing table styles - Page 791
Customizing table styles - Page 792
Chapter 23: Analyzing data with PivotTable reports - Page 793
Chapter 23: Analyzing data with PivotTable reports - Page 794
Chapter 23: Analyzing data with PivotTable reports - Page 795
Chapter 23: Analyzing data with PivotTable reports - Page 796
Creating a PivotTable - Page 797
Creating a PivotTable - Page 798
Creating a PivotTable - Page 799
Creating a PivotTable - Page 800
Rearranging PivotTable fields - Page 801
Rearranging PivotTable fields - Page 802
Refreshing a PivotTable - Page 803
Changing the numeric format of PivotTable data - Page 804
Formatting a PivotTable - Page 805
Hiding outline controls - Page 806
Displaying totals and subtotals - Page 807
Displaying totals and subtotals - Page 808
Displaying totals and subtotals - Page 809
Sorting PivotTable fields - Page 810
Filtering PivotTable fields - Page 811
Filtering with slicers - Page 812
Formatting slicers - Page 813
Filtering in the PivotTable Fields pane - Page 814
Filtering in the PivotTable Fields pane - Page 815
Filtering in the PivotTable Fields pane - Page 816
Filtering in the PivotTable Fields pane - Page 817
Changing PivotTable calculations - Page 818
Applying multiple summary functions to the same field - Page 819
Applying multiple summary functions to the same field - Page 820
Using calculated fields and items - Page 821
Using calculated fields and items - Page 822
Using calculated fields and items - Page 823
Grouping and ungrouping data - Page 824
Grouping items in date or time ranges - Page 825
Grouping items in date or time ranges - Page 826
Displaying the details behind a data value - Page 827
Displaying the details behind a data value - Page 828
Moving beyond PivotTables - Page 829
Moving beyond PivotTables - Page 830
Chapter 24: An introduction to PowerPivot - Page 831
Using a PivotTable on an Excel table - Page 832
Using a PivotTable on an Excel table - Page 833
Using PowerPivot in Office 2013 - Page 834
Using PowerPivot in Office 2013 - Page 835
Adding information to the Excel table - Page 836
Adding information to the Excel table - Page 837
Creating a data model with many tables - Page 838
Creating a data model with many tables - Page 839
Understanding relationships - Page 840
Understanding relationships - Page 841
Understanding the data model - Page 842
Querying the data model - Page 843
Querying the data model - Page 844
The PowerPivot add-in - Page 845
The PowerPivot add-in - Page 846
The PowerPivot add-in - Page 847
Creating a Power View report - Page 848
Creating a Power View report - Page 849
Creating a Power View report - Page 850
Creating a Power View report - Page 851
Creating a Power View report - Page 852
Loading data from external sources - Page 853
Loading data from external sources - Page 854
Loading data from external sources - Page 855
Loading data from external sources - Page 856
Using the DAX language - Page 857
Using the DAX language - Page 858
Using the DAX language - Page 859
Using the DAX language - Page 860
Creating a calculated field - Page 861
Creating a calculated field - Page 862
Refreshing the PowerPivot data model - Page 863
Refreshing the PowerPivot data model - Page 864
Chapter 25: Working with external data - Page 865
Chapter 25: Working with external data - Page 866
Setting refresh options - Page 867
Requiring or not requiring a password to refresh - Page 868
Opening an entire Access table in Excel - Page 869
Working with data in text files - Page 870
Working with data in text files - Page 871
Working with data in text files - Page 872
Working with data in text files - Page 873
Parsing Clipboard text - Page 874
Parsing Clipboard text - Page 875
Creating an ad hoc mapping of XML elements to table columns - Page 876
Importing XML data using an existing XML structure - Page 877
Using Microsoft Query to import data - Page 878
Using Microsoft Query to import data - Page 879
Choosing tables and fields (columns) - Page 880
Choosing tables and fields (columns) - Page 881
Sorting records - Page 882
Working directly with Microsoft Query - Page 883
Working directly with Microsoft Query - Page 884
Working directly with Microsoft Query - Page 885
Working directly with Microsoft Query - Page 886
Working directly with Microsoft Query - Page 887
Working directly with Microsoft Query - Page 888
Working directly with Microsoft Query - Page 889
Working directly with Microsoft Query - Page 890
Working directly with Microsoft Query - Page 891
Working directly with Microsoft Query - Page 892
Working directly with Microsoft Query - Page 893
Working directly with Microsoft Query - Page 894
Working directly with Microsoft Query - Page 895
Working directly with Microsoft Query - Page 896
Working directly with Microsoft Query - Page 897
Using a web query to return Internet data - Page 898
Using a web query to return Internet data - Page 899
Creating your own web query - Page 900
Creating your own web query - Page 901
Creating your own web query - Page 902
Part 8: Using Excel collaboratively - Page 903
Part 8: Using Excel collaboratively - Page 904
Chapter 26: Collaborating on a network or by email - Page 905
Sharing workbooks on a network - Page 906
Sharing workbooks on a network - Page 907
Sharing workbooks on a network - Page 908
Sharing workbooks on a network - Page 909
Using advanced sharing options - Page 910
Using advanced sharing options - Page 911
Tracking changes - Page 912
Protecting the change history - Page 913
Reviewing changes - Page 914
Canceling the shared workbook session - Page 915
Combining changes made to multiple workbooks - Page 916
Combining changes made to multiple workbooks - Page 917
Distributing workbooks and worksheets by email - Page 918
Sending a worksheet, chart, or range by email - Page 919
Sending a workbook for review - Page 920
Chapter 27: Working in the cloud - Page 921
Working with the SkyDrive application - Page 922
Working with the SkyDrive application - Page 923
Saving workbooks to and retrieving them from SkyDrive - Page 924
Saving workbooks to and retrieving them from SkyDrive - Page 925
Saving workbooks to and retrieving them from SkyDrive - Page 926
Saving workbooks to and retrieving them from SkyDrive - Page 927
Saving workbooks to and retrieving them from SkyDrive - Page 928
Saving workbooks to and retrieving them from SkyDrive - Page 929
Saving workbooks to and retrieving them from SkyDrive - Page 930
Saving workbooks to and retrieving them from SkyDrive - Page 931
Saving workbooks to and retrieving them from SkyDrive - Page 932
Using Microsoft Office Web Apps - Page 933
Using Microsoft Office Web Apps - Page 934
How the Web App handles unsupported features - Page 935
How the Web App handles unsupported features - Page 936
Part 9: Automating Excel - Page 937
Part 9: Automating Excel - Page 938
Chapter 28: Recording macros - Page 939
Configuring macro security - Page 940
Configuring macro security - Page 941
Configuring macro security - Page 942
Using the macro recorder - Page 943
Recording with relative references - Page 944
What to do when the macro recorder does not give you what you expect - Page 945
Introducing the Visual Basic Editor - Page 946
Learning the basics of Visual Basic - Page 947
Learning the basics of Visual Basic - Page 948
The Object Browser - Page 949
Collections of objects - Page 950
Collections of objects - Page 951
Manipulating an object’s properties without selecting the object - Page 952
Adding code to or editing recorded macros - Page 953
Adding code to or editing recorded macros - Page 954
Adding code to or editing recorded macros - Page 955
Using subroutines in macros - Page 956
Using subroutines in macros - Page 957
Using the Personal Macro Workbook - Page 958
Using the Personal Macro Workbook - Page 959
Using the Personal Macro Workbook - Page 960
Chapter 29: Creating custom functions - Page 961
Chapter 29: Creating custom functions - Page 962
Using custom functions - Page 963
Using custom functions - Page 964
Understanding custom function rules - Page 965
Documenting macros and custom functions - Page 966
Creating custom functions with optional arguments - Page 967
Creating custom functions with optional arguments - Page 968
Making your custom functions available anywhere - Page 969
Making your custom functions available anywhere - Page 970
Making your custom functions available anywhere - Page 971
Making your custom functions available anywhere - Page 972
Chapter 30: Debugging macros and custom functions - Page 973
Catching syntax errors - Page 974
Catching misspelled variable names - Page 975
Stepping through code - Page 976
Setting breakpoints with the Toggle Breakpoint command - Page 977
Setting conditional breakpoints using Debug.Assert - Page 978
Using the Watch Window to monitor variable values and object properties - Page 979
Using the Immediate window - Page 980
Dealing with run-time errors - Page 981
Dealing with run-time errors - Page 982
Dealing with run-time errors - Page 983
Dealing with run-time errors - Page 984
Part 10: Integrating and extending Excel - Page 985
Part 10: Integrating and extending Excel - Page 986
Chapter 31: Linking, hyperlinking, and embedding - Page 987
Embedding vs. static pasting - Page 988
Embedding vs. static pasting - Page 989
Embedding and linking from the Clipboard - Page 990
Embedding and linking with the Object command - Page 991
Managing links - Page 992
Linking with hyperlinks - Page 993
Creating a hyperlink in a cell - Page 994
Creating a hyperlink in a cell - Page 995
Linking to a website or local file - Page 996
Linking to a website or local file - Page 997
Linking to a website or local file - Page 998
Linking to a website or local file - Page 999
Assigning a hyperlink to a shape, image, or chart - Page 1000
Assigning a hyperlink to a shape, image, or chart - Page 1001
Assigning a hyperlink to a shape, image, or chart - Page 1002
Chapter 32: Using Excel data in Word documents - Page 1003
Chapter 32: Using Excel data in Word documents - Page 1004
Using Paste Special to control the format of your table - Page 1005
Using Paste Special to control the format of your table - Page 1006
Using Paste Special to control the format of your table - Page 1007
Using Paste Special to control the format of your table - Page 1008
Using Paste Special to control the format of your table - Page 1009
Using Paste Special to control the format of your table - Page 1010
Using the Object command - Page 1011
Using the Object command - Page 1012
Using Excel charts in Word documents - Page 1013
Using Excel charts in Word documents - Page 1014
Using Excel charts in Word documents - Page 1015
Using Excel to supply mail-merge data to Word - Page 1016
Using Excel to supply mail-merge data to Word - Page 1017
Using Excel to supply mail-merge data to Word - Page 1018
Using Excel to supply mail-merge data to Word - Page 1019