Microsoft Excel 2013

1. Getting Started with Excel - Page 28
Introduction - Page 29
Introduction - Page 30
Introduction - Page 31
Viewing the Excel Window - Page 32
Tabs - Page 33
Choosing Commands - Page 34
Choose a Menu Command from a Shortcut Menu - Page 35
Working with the Ribbon and Toolbars - Page 36
Choose a Command Using a Toolbar or Ribbon - Page 37
Customize the Ribbon or Quick Access Toolbar - Page 38
Customize the Ribbon or Quick Access Toolbar - Page 39
Customize the Ribbon or Quick Access Toolbar - Page 40
Choosing Dialog Box Options - Page 41
Choosing Dialog Box Options - Page 42
Using the Status Bar - Page 43
Using the Status Bar - Page 44
Creating a Blank Workbook - Page 45
Creating a Blank Workbook - Page 46
Creating a Blank Workbook - Page 47
Creating a Workbook Using a Template - Page 48
Creating a Workbook Using a Template - Page 49
Creating a Workbook Using a Template - Page 50
Opening an Existing Workbook - Page 51
Opening an Existing Workbook - Page 52
Open a Recently Opened Workbook or Folder - Page 53
Open a Recently Opened Workbook or Folder - Page 54
Open a Recently Opened Workbook or Folder - Page 55
Converting an Existing Workbook - Page 56
Converting an Existing Workbook - Page 57
Using Task and Window Panes - Page 58
Using Task and Window Panes - Page 59
Moving Around the Workbook - Page 60
Moving Around the Workbook - Page 61
Use the Keyboard to Navigate - Page 62
Go To a Specific Location - Page 63
Arranging Windows - Page 64
Resize and Move a Window - Page 65
Arrange or Switch Between Windows - Page 66
Compare Windows Side By Side - Page 67
Compare Windows Side By Side - Page 68
Getting Help While You Work - Page 69
Getting Help While You Work - Page 70
Search for Help - Page 71
Search for Help - Page 72
Use Local or Online Help - Page 73
Use Local or Online Help - Page 74
Use Local or Online Help - Page 75
Saving a Workbook - Page 76
Saving a Workbook - Page 77
Save an Excel 97-2003 Workbook - Page 78
Set Save Options - Page 79
Set Save Options - Page 80
Saving a Workbook with Different Formats - Page 81
Saving a Workbook with Different Formats - Page 82
Saving a Workbook with Different Formats - Page 83
Saving a Workbook to Online Services - Page 84
Saving a Workbook to Online Services - Page 85
Working with Accounts - Page 86
Add Online Services - Page 87
Checking Compatibility - Page 88
Check Workbook Compatibility - Page 89
Check Workbook Compatibility - Page 90
Checking Accessibility - Page 91
Checking Accessibility - Page 92
Documenting Workbook Properties - Page 93
Documenting Workbook Properties - Page 94
Switching Views - Page 95
Recovering a Workbook - Page 96
Recover a Workbook - Page 97
Use AutoRecover - Page 98
Closing a Workbook and Exiting Excel - Page 99
Close a Workbook - Page 100
Close a Workbook - Page 101
2. Basic Workbook Skills - Page 102
Introduction - Page 103
Selecting Cells - Page 104
Select a Non-contiguous Range - Page 105
Selecting Rows, Columns, and Special Ranges - Page 106
Select Multi-sheet Ranges - Page 107
Select Multi-sheet Ranges - Page 108
Make Special Range Selections - Page 109
Entering Labels on a Worksheet - Page 110
Enter a Text Label - Page 111
Enter a Label Using AutoComplete - Page 112
Enter a Label Using AutoComplete - Page 113
Entering Values on a Worksheet - Page 114
Enter a Date or Time - Page 115
Format Values Quickly - Page 116
Format Values Quickly - Page 117
Format Values Quickly - Page 118
Entering Values Quickly with AutoFill - Page 119
Create a Complex Series Using AutoFill - Page 120
Fill with Contents of Adjacent Cells - Page 121
Create a Custom Fill - Page 122
Inserting Content with Flash Fill - Page 123
Inserting Content with Flash Fill - Page 124
Insert Data Using Flash Fill Automatic Recognition - Page 125
Insert Data Using Flash Fill Automatic Recognition - Page 126
Editing Cell Contents - Page 127
Editing Cell Contents - Page 128
Editing Cell Contents - Page 129
Clearing Cell Contents - Page 130
Clearing Cell Contents - Page 131
Understanding How Excel Pastes Data - Page 132
Storing Cell Contents - Page 133
Storing Cell Contents - Page 134
Copying Cell Contents - Page 135
Copying Cell Contents - Page 136
Copy Data Using Drag-and-Drop - Page 137
Paste Data with Special Results - Page 138
Moving Cell Contents - Page 139
Move Data Using the Clipboard - Page 140
Move Data Using Drag-and-Drop - Page 141
Paste Cells from Rows to Columns or Columns to Rows - Page 142
Paste Cells from Rows to Columns or Columns to Rows - Page 143
Inserting and Deleting Cell Contents - Page 144
Inserting and Deleting Cell Contents - Page 145
Delete a Cell - Page 146
Delete a Cell - Page 147
Finding and Replacing Cell Contents - Page 148
Finding and Replacing Cell Contents - Page 149
Replace Cell Contents - Page 150
Replace Cell Contents - Page 151
Correcting Cell Contents with AutoCorrect - Page 152
Correcting Cell Contents with AutoCorrect - Page 153
Add or Edit an AutoCorrect Entry - Page 154
Add or Edit an AutoCorrect Entry - Page 155
Add or Edit an AutoCorrect Entry - Page 156
Inserting Information the Smart Way - Page 157
Insert Information Using an Action - Page 158
Insert Information Using an Action - Page 159
Checking Spelling - Page 160
Checking Spelling - Page 161
Changing Proofing Options - Page 162
Changing Proofing Options - Page 163
Changing Proofing Options - Page 164
Using Custom Dictionaries - Page 165
Find and Modify the Exclusion Dictionary - Page 166
Find and Modify the Exclusion Dictionary - Page 167
Inserting Symbols - Page 168
Inserting Symbols - Page 169
Inserting Symbols - Page 170
Finding the Right Words - Page 171
Inserting Research Material - Page 172
Inserting Research Material - Page 173
Inserting Research Material - Page 174
Translating Text to Another Language - Page 175
Translating Text to Another Language - Page 176
Using Multiple Languages - Page 177
Add a Language to Office Programs - Page 178
Working with Touch Screens - Page 179
Use Touch/Mouse Mode - Page 180
Use Touch/Mouse Mode - Page 181
Undoing and Redoing an Action - Page 182
Redo an Action - Page 183
Redo an Action - Page 184
3. Working with Formulas and Functions - Page 185
Introduction - Page 186
Introduction - Page 187
Perform Calculations - Page 188
Creating a Simple Formula - Page 189
Creating a Simple Formula - Page 190
Resize the Formula Bar - Page 191
Display Formulas in Cells - Page 192
Display Formulas in Cells - Page 193
Creating a Formula Using Formula AutoComplete - Page 194
Use the Keyboard to Navigate - Page 195
Turn on Formula AutoComplete - Page 196
Turn on Formula AutoComplete - Page 197
Editing a Formula - Page 198
Copy a Formula Using AutoFill - Page 199
Copy and Paste a Formula - Page 200
Copy and Paste a Formula - Page 201
Copy and Paste a Formula - Page 202
Understanding Cell Referencing - Page 203
Relative Cell References - Page 204
Using Absolute Cell References - Page 205
Using Absolute Cell References - Page 206
Using Mixed Cell References - Page 207
Using Mixed Cell References - Page 208
Using 3-D Cell References - Page 209
Using 3-D Cell References - Page 210
Naming Cells and Ranges - Page 211
Let Excel Name a Cell or Range - Page 212
Name a Cell or Range Using the New Name Dialog Box - Page 213
Name a Cell or Range Using the New Name Dialog Box - Page 214
Entering Named Cells and Ranges - Page 215
Enter a Named Cell or Range Using Formula AutoComplete - Page 216
Apply a Name to a Cell or Range Address - Page 217
Apply a Name to a Cell or Range Address - Page 218
Managing Names - Page 219
Managing Names - Page 220
Change a Name - Page 221
Change a Name - Page 222
Change a Name - Page 223
Simplifying a Formula with Ranges - Page 224
Use a Range Name in a Formula - Page 225
Displaying Calculations with the Status Bar - Page 226
Displaying Calculations with the Status Bar - Page 227
Calculating Totals with AutoSum - Page 228
Calculating Totals with AutoSum - Page 229
Calculate with Extended AutoSum - Page 230
Calculate Subtotals and Totals - Page 231
Calculate Subtotals and Totals - Page 232
Calculating Totals with Quick Analysis - Page 233
Calculate Totals with Quick Analysis Next to Selection - Page 234
Calculate Totals with Quick Analysis Next to Selection - Page 235
Performing One Time Calculations - Page 236
Performing One Time Calculations - Page 237
Perform One Time Calculations Using a Formula - Page 238
Perform One Time Calculations Using a Formula - Page 239
Converting Formulas and Values - Page 240
Delete Values and Keep Formulas - Page 241
Delete Values and Keep Formulas - Page 242
Correcting Calculation Errors - Page 243
Correcting Calculation Errors - Page 244
Correcting Formulas - Page 245
Remove Cells from the Watch Window - Page 246
Set Error Checking Options - Page 247
Correct Errors - Page 248
Correct Errors - Page 249
Auditing a Worksheet - Page 250
Auditing a Worksheet - Page 251
Locating Circular References - Page 252
Locating Circular References - Page 253
Performing Calculations Using Functions - Page 254
Performing Calculations Using Functions - Page 255
Creating Functions - Page 256
Creating Functions - Page 257
Creating Functions - Page 258
Creating Functions Using the Library - Page 259
Creating Functions Using the Library - Page 260
Calculating Multiple Results - Page 261
Calculating Multiple Results - Page 262
Using Nested Functions - Page 263
Using Nested Functions - Page 264
Evaluate a Nested Formula One Step at a Time - Page 265
Evaluate a Nested Formula One Step at a Time - Page 266
Evaluate a Nested Formula One Step at a Time - Page 267
Evaluate a Nested Formula One Step at a Time - Page 268
Using Constants and Functions in Names - Page 269
Using Constants and Functions in Names - Page 270
Using Constants and Functions in Names - Page 271
4. Modifying Worksheets and Workbooks - Page 272
Selecting and Naming a Worksheet - Page 273
Name or Rename a Worksheet - Page 274
Name or Rename a Worksheet - Page 275
Inserting and Deleting a Worksheet - Page 276
Delete a Worksheet - Page 277
Moving and Copying a Worksheet - Page 278
Move a Worksheet Within a Workbook - Page 279
Copy a Worksheet - Page 280
Copy a Worksheet - Page 281
Copy a Worksheet - Page 282
Hiding and Unhiding Worksheets and Workbooks - Page 283
Unhide a Worksheet - Page 284
Hide a Workbook - Page 285
Unhide a Workbook - Page 286
Selecting a Column or Row - Page 287
Select Multiple Columns or Rows - Page 288
Hiding and Unhiding a Column or Row - Page 289
Hide a Column or Row - Page 290
Inserting a Column or Row - Page 291
Inserting a Column or Row - Page 292
Insert Multiple Columns or Rows - Page 293
Deleting a Column or Row - Page 294
Delete Multiple Columns or Rows - Page 295
Adjusting Column Width and Row Height - Page 296
Adjusting Column Width and Row Height - Page 297
Adjust Column Width or Row Height Using the Mouse - Page 298
Change Column Width or Row Height Using AutoFit - Page 299
Freezing and Unfreezing a Column or Row - Page 300
Freeze and Unfreeze a Column or Row - Page 301
Splitting a Worksheet into Panes - Page 302
Split a Worksheet into Panes - Page 303
Split a Worksheet into Panes - Page 304
Showing and Hiding Workbook Elements - Page 305
Showing and Hiding Workbook Elements - Page 306
Zooming the View In and Out - Page 307
Zooming the View In and Out - Page 308
Creating Custom Views - Page 309
Show or Delete a Custom View - Page 310
Setting Up for Personal Templates - Page 311
Setting Up for Personal Templates - Page 312
Creating a Personal Template - Page 313
Creating a Personal Template - Page 314
Opening a Template - Page 315
Opening a Template - Page 316
Changing a Template - Page 317
Changing a Template - Page 318
Changing a Template - Page 319
5. Formatting a Worksheet - Page 320
Formatting Numbers - Page 321
Formatting Numbers - Page 322
Format a Number Using the Format Cells Dialog Box - Page 323
Format a Number Using the Format Cells Dialog Box - Page 324
Formatting Text - Page 325
Formatting Text - Page 326
Format Text Using the Format Cells Dialog Box - Page 327
Format Text Using the Format Cells Dialog Box - Page 328
Applying Conditional Formatting - Page 329
Applying Conditional Formatting - Page 330
Format Cell Contents Based on Ranking and Average - Page 331
Format Cell Contents Based on Ranking and Average - Page 332
Applying Specialized Conditional Formatting - Page 333
Format Using Color Scales - Page 334
Format Using Icon Sets - Page 335
Format Using Icon Sets - Page 336
Creating Conditional Formatting - Page 337
Creating Conditional Formatting - Page 338
Clearing Conditional Formatting - Page 339
Managing Conditional Formatting - Page 340
Edit Conditional Formatting Rule Precedence - Page 341
Edit Conditional Formatting Rule Precedence - Page 342
Finding Conditional Formatting - Page 343
Find Cells with the Same Conditional Format - Page 344
Creating Sparkline Formatting - Page 345
Create Sparkline Formatting - Page 346
Create Sparkline Formatting - Page 347
Change Sparkline Formatting - Page 348
Changing Data Alignment - Page 349
Change Alignment Using the Format Dialog Box - Page 350
Change Alignment Using the Format Dialog Box - Page 351
Change Alignment Using the Format Dialog Box - Page 352
Controlling Text Flow - Page 353
Controlling Text Flow - Page 354
Controlling Text Flow - Page 355
Changing Data Color - Page 356
Changing Data Color - Page 357
Adding Color and Patterns to Cells - Page 358
Apply Color and Pattern to Cells - Page 359
Apply Color and Pattern to Cells - Page 360
Adding Custom Colors - Page 361
Adding Custom Colors - Page 362
Adding Custom Colors - Page 363
Adding Borders to Cells - Page 364
Draw a Border - Page 365
Apply a Border Using the Format Cells Dialog Box - Page 366
Apply a Border Using the Format Cells Dialog Box - Page 367
Apply a Border Using the Format Cells Dialog Box - Page 368
Formatting Tabs and Background - Page 369
Add or Remove a Background - Page 370
Add or Remove a Background - Page 371
Copying Cell Formats - Page 372
Copying Cell Formats - Page 373
Understanding Color Themes - Page 374
Understanding Color Themes - Page 375
Understanding Color Themes - Page 376
Understanding Color Themes - Page 377
Viewing and Applying a Theme - Page 378
Viewing and Applying a Theme - Page 379
Creating Theme Colors - Page 380
Creating Theme Colors - Page 381
Select Custom Colors - Page 382
Select Custom Colors - Page 383
Select Custom Colors - Page 384
Choosing Theme Fonts - Page 385
Choosing Theme Fonts - Page 386
Create Theme Fonts - Page 387
Create Theme Fonts - Page 388
Choosing Theme Effects - Page 389
Choosing Theme Effects - Page 390
Creating a Custom Theme - Page 391
Creating a Custom Theme - Page 392
Choosing a Custom Theme - Page 393
Select and Apply a Custom Theme From a File - Page 394
Select and Apply a Custom Theme From a File - Page 395
Select and Apply a Custom Theme From a File - Page 396
Applying and Creating Cell Styles - Page 397
Applying and Creating Cell Styles - Page 398
Create a Custom Cell Style - Page 399
Create a Custom Cell Style - Page 400
Modifying a Cell Style - Page 401
Modifying a Cell Style - Page 402
Modifying a Cell Style - Page 403
Merge Cell Styles - Page 404
Delete a Cell Style - Page 405
Delete a Cell Style - Page 406
Finding and Replacing Cell Formatting - Page 407
Finding and Replacing Cell Formatting - Page 408
Finding and Replacing Cell Formatting - Page 409
6. Viewing and Printing Worksheets and Workbooks - Page 410
Setting Up the Page - Page 411
Change the Page Size - Page 412
Customize the Page Size - Page 413
Customize the Page Size - Page 414
Adjusting Page Margins - Page 415
Change the Margin Using the Mouse in Page Layout View - Page 416
Customize Margin Settings - Page 417
Customize Margin Settings - Page 418
Adding Headers and Footers - Page 419
Insert Elements in a Header or Footer in Page Layout View - Page 420
Insert Elements in a Header or Footer in Page Layout View - Page 421
Insert Elements in a Header or Footer in Page Layout View - Page 422
Inserting Page Breaks - Page 423
Preview and Move a Page Break - Page 424
Remove a Page Break - Page 425
Remove a Page Break - Page 426
Customizing Worksheet Printing - Page 427
Print Row and Column Titles on Each Page - Page 428
Print Gridlines, Column Letters, and Row Numbers - Page 429
Fit a Worksheet on a Specific Number of Pages - Page 430
Setting the Print Area - Page 431
Set the Print Area - Page 432
Clear the Print Area - Page 433
Previewing a Worksheet - Page 434
Printing a Worksheet and Workbook - Page 435
Print All or Part of a Worksheet - Page 436
Creating a PDF Document - Page 437
Save a Workbook as a PDF Document - Page 438
Save a Workbook as a PDF Document - Page 439
Creating a XPS Document - Page 440
Creating a XPS Document - Page 441
Creating a XPS Document - Page 442
Creating a XPS Document - Page 443
7. Inserting and Modifying Graphics - Page 444
Locating and Inserting Online Pictures - Page 445
Locating and Inserting Online Pictures - Page 446
Locate and Insert Online Pictures from Bing Image Search - Page 447
Locate and Insert Online Pictures from Bing Image Search - Page 448
Locate and Insert Online Pictures from Bing Image Search - Page 449
Locate and Insert Online Pictures from Bing Image Search - Page 450
Inserting Pictures from an Online Service - Page 451
Insert Pictures from an Image Online Service - Page 452
Insert Pictures from an Image Online Service - Page 453
Insert Pictures from an Image Online Service - Page 454
Inserting a Picture from a SkyDrive or SharePoint - Page 455
Inserting a Picture from a SkyDrive or SharePoint - Page 456
Inserting a Picture from a SkyDrive or SharePoint - Page 457
Inserting a Picture from a File - Page 458
Inserting a Picture from a File - Page 459
Inserting a Picture from a File - Page 460
Inserting a Picture Screen Shot - Page 461
Inserting a Picture Screen Shot - Page 462
Adding an Artistic Style to a Picture - Page 463
Adding an Artistic Style to a Picture - Page 464
Adding a Quick Style to a Picture - Page 465
Adding a Quick Style to a Picture - Page 466
Applying a Shape to a Picture - Page 467
Applying a Shape to a Picture - Page 468
Applying a Shape to a Picture - Page 469
Applying a Border to a Picture - Page 470
Applying a Border to a Picture - Page 471
Applying Picture Effects - Page 472
Modifying Picture Size - Page 473
Resize a Picture Precisely - Page 474
Precisely Scale a Picture - Page 475
Precisely Scale a Picture - Page 476
Precisely Scale a Picture - Page 477
Compressing a Picture - Page 478
Compressing a Picture - Page 479
Correcting a Picture - Page 480
Recoloring a Picture - Page 481
Recolor a Picture - Page 482
Set a Transparent Background - Page 483
Set a Transparent Background - Page 484
Set a Transparent Background - Page 485
Cropping and Rotating a Picture - Page 486
Crop a Picture with an Aspect Ratio - Page 487
Crop a Picture with a Fill or Fit - Page 488
Rotate a Picture - Page 489
Removing a Picture Background - Page 490
Remove a Picture Background - Page 491
Remove a Picture Background - Page 492
Creating WordArt Text - Page 493
Creating WordArt Text - Page 494
Formatting WordArt Text - Page 495
Formatting WordArt Text - Page 496
Apply a Fill to WordArt Text - Page 497
Apply an Outline to WordArt Text - Page 498
Applying WordArt Text Effects - Page 499
Applying WordArt Text Effects - Page 500
Applying WordArt Text Effects - Page 501
Modifying WordArt Text Position - Page 502
Rotate WordArt Text - Page 503
Creating SmartArt Graphics - Page 504
Creating SmartArt Graphics - Page 505
Creating SmartArt Graphics - Page 506
Creating SmartArt Graphics - Page 507
Using the Text Pane with SmartArt Graphics - Page 508
Work with Text in the Text Pane - Page 509
Work with Text in the Text Pane - Page 510
Work with Text in the Text Pane - Page 511
Modifying a SmartArt Graphic - Page 512
Change Shapes in a SmartArt Graphic - Page 513
Change Shapes in a SmartArt Graphic - Page 514
Resizing a SmartArt Graphic - Page 515
Resizing a SmartArt Graphic - Page 516
Formatting a SmartArt Graphic - Page 517
Change a Smart Graphic Orientation - Page 518
Change a SmartArt Graphic Layout - Page 519
Change a SmartArt Graphic Colors - Page 520
Formatting a Shape in a SmartArt Graphic - Page 521
Apply a Shape Fill to a SmartArt Graphic - Page 522
Apply a Shape Outline to a SmartArt Graphic - Page 523
Apply a Shape Effect to a SmartArt Graphic - Page 524
Apply a Shape Effect to a SmartArt Graphic - Page 525
Adding Pictures to a SmartArt Graphic - Page 526
Adding Pictures to a SmartArt Graphic - Page 527
Creating an Organization Chart - Page 528
Create an Organization Chart Using a SmartArt Graphic - Page 529
Modifying an Organization Chart - Page 530
Change the Layout or Apply a Quick Style to an Organization Chart - Page 531
Change the Layout or Apply a Quick Style to an Organization Chart - Page 532
8. Drawing and Modifying Shapes - Page 533
Drawing and Resizing Shapes - Page 534
Drawing and Resizing Shapes - Page 535
Drawing and Resizing Shapes - Page 536
Resize a Shape - Page 537
Adjust a Shape - Page 538
Adjust a Shape - Page 539
Inserting Multiple Shapes - Page 540
Change a Shape to Another Shape - Page 541
Adding Text to a Shape - Page 542
Create a Text Box - Page 543
Drawing Lines and Arrows - Page 544
Add a Quick Style to a Line - Page 545
Change a Line or Arrow - Page 546
Modify a Line or Arrow - Page 547
Creating and Editing Freeforms - Page 548
Draw a Freeform Polygon - Page 549
Draw a Freeform Polygon - Page 550
Copying and Moving Objects - Page 551
Copy or Move an Object - Page 552
Adding a Quick Style to a Shape - Page 553
Adding a Quick Style to a Shape - Page 554
Adding a Quick Style to Shape Text - Page 555
Add a Quick Style to Shape Text - Page 556
Add a Quick Style to Shape Text - Page 557
Applying Color Fills - Page 558
Applying Color Fills - Page 559
Apply a Shape Color Fill with a Transparency - Page 560
Apply a Color Outline to a Shape - Page 561
Apply a Color Outline to a Shape - Page 562
Applying Picture Fills - Page 563
Applying Picture Fills - Page 564
Applying Texture Fills - Page 565
Applying Texture Fills - Page 566
Applying Gradient Fills - Page 567
Apply a Gradient Fill Preset - Page 568
Apply a Gradient Fill Preset - Page 569
Apply a Custom Gradient Fill - Page 570
Apply a Custom Gradient Fill - Page 571
Applying Shape Effects - Page 572
Add a Preset Effect to a Shape - Page 573
Add Individual Effects to a Shape - Page 574
Add Individual Effects to a Shape - Page 575
Add Individual Effects to a Shape - Page 576
Add Individual Effects to a Shape - Page 577
Add Individual Effects to a Shape - Page 578
Add Individual Effects to a Shape - Page 579
Adding 3-D Effects to a Shape - Page 580
Add a Custom 3-D Effect to a Shape - Page 581
Add a Custom 3-D Effect to a Shape - Page 582
Add a Custom 3-D Effect to a Shape - Page 583
Add a Custom 3-D Effect to a Shape - Page 584
Adding 3-D Rotation Effects to a Shape - Page 585
Creating Shadows - Page 586
Add a Preset Shadow to a Shape - Page 587
Aligning and Distributing Objects - Page 588
Align Objects with Other Objects - Page 589
Align Objects with Other Objects - Page 590
Align Objects with Other Objects - Page 591
Connecting Shapes - Page 592
Connect Two Objects - Page 593
Connect Two Objects - Page 594
Selecting Objects Using the Selection Pane - Page 595
Changing Stacking Order - Page 596
Changing Stacking Order - Page 597
Rotating and Flipping Objects - Page 598
Rotate or Flip an Object Using Preset Increments - Page 599
Grouping and Ungrouping Shapes - Page 600
Group Objects Together - Page 601
Ungroup a Drawing - Page 602
Regroup a Drawing - Page 603
Regroup a Drawing - Page 604
9. Creating and Modifying Charts - Page 605
Introduction - Page 606
Understanding Chart Terminology - Page 607
Understanding Chart Terminology - Page 608
Creating a Chart - Page 609
Creating a Chart - Page 610
Insert and Use a Recommended Chart - Page 611
Insert and Use a Recommended Chart - Page 612
Insert and Use a Recommended Chart - Page 613
Editing a Chart - Page 614
Editing a Chart - Page 615
Moving and Resizing a Chart - Page 616
Move an Embedded Chart - Page 617
Move a Chart to Another Worksheet - Page 618
Move a Chart to Another Worksheet - Page 619
Selecting Chart Elements - Page 620
Selecting Chart Elements - Page 621
Changing Chart Elements - Page 622
Changing Chart Elements - Page 623
Changing a Chart Type - Page 624
Changing a Chart Type - Page 625
Change a Chart Type of a Single Data Series - Page 626
Change a Chart Type of a Single Data Series - Page 627
Change a Chart Type of a Single Data Series - Page 628
Changing a Chart Layout and Style - Page 629
Changing a Chart Layout and Style - Page 630
Apply a Chart Style - Page 631
Formatting Chart Elements - Page 632
Format a Chart Object - Page 633
Format a Chart Object - Page 634
Apply a Shape Style to a Chart Object - Page 635
Apply a Shape Style to a Chart Object - Page 636
Changing Chart Gridlines and Axes - Page 637
Change Chart Axes - Page 638
Change Chart Axes - Page 639
Change Chart Axes - Page 640
Changing Chart Titles - Page 641
Change Chart Axis Titles - Page 642
Change Chart Axis Titles - Page 643
Change Chart Axis Titles - Page 644
Changing Chart Labels - Page 645
Change the Chart Legend - Page 646
Change Chart Data Labels - Page 647
Show or Hide a Chart Data Table - Page 648
Show or Hide a Chart Data Table - Page 649
Pulling Out a Pie Slice - Page 650
Undo a Pie Explosion - Page 651
Formatting Chart Data Series - Page 652
Format a Chart Data Series - Page 653
Formatting Chart Text - Page 654
Formatting Chart Text - Page 655
Formatting Chart Text - Page 656
Formatting Chart Text - Page 657
Formatting Line and Bar Charts - Page 658
Changing the Chart Background - Page 659
Change the Chart Background - Page 660
Change the Chart Background - Page 661
Change the Chart Background - Page 662
Enhancing a Chart - Page 663
Enhancing a Chart - Page 664
Enhancing a Chart - Page 665
Editing Chart Data - Page 666
Edit the Data Source - Page 667
Edit the Data Source - Page 668
Edit the Data Source - Page 669
Adding and Deleting a Data Series - Page 670
Delete a Data Series - Page 671
Change a Data Series - Page 672
Change Data Series Order - Page 673
Change Data Series Order - Page 674
Saving a Chart Template - Page 675
Saving a Chart Template - Page 676
Apply a Chart Template - Page 677
Apply a Chart Template - Page 678
Managing Chart Templates - Page 679
Managing Chart Templates - Page 680
Managing Chart Templates - Page 681
Managing Chart Templates - Page 682
10. Analyzing Worksheet Data - Page 683
Introduction - Page 684
Creating a Table - Page 685
Creating a Table - Page 686
Creating a Table - Page 687
Formatting a Table - Page 688
Formatting a Table - Page 689
Formatting a Table - Page 690
Creating or Modifying a Table Style - Page 691
Creating or Modifying a Table Style - Page 692
Creating or Modifying a Table Style - Page 693
Formatting Table Elements - Page 694
Creating Calculations in a Table - Page 695
Creating Calculations in a Table - Page 696
Working with Tables - Page 697
Select Rows and Columns - Page 698
Resize a Table - Page 699
Convert a Table to a Range - Page 700
Removing Table Rows and Columns - Page 701
Delete Rows or Columns from a Table - Page 702
Delete Rows or Columns from a Table - Page 703
Entering Data in a Table Using a Drop-Down List - Page 704
Entering Data in a Table Using a Drop-Down List - Page 705
Sorting Data in a Table - Page 706
Sorting Data in a Table - Page 707
Sort a Table Using Multiple Fields and Attributes - Page 708
Sort a Table Using Multiple Fields and Attributes - Page 709
Sort a Table Using Multiple Fields and Attributes - Page 710
Sort a Table Using Multiple Fields and Attributes - Page 711
Displaying Parts of a Table with AutoFilter - Page 712
Displaying Parts of a Table with AutoFilter - Page 713
Creating Custom Searches - Page 714
Create a Custom Search Using AutoFilter - Page 715
Create a Custom Search Using AutoFilter - Page 716
Using Slicers to Filter a Table - Page 717
Using Slicers to Filter a Table - Page 718
Exporting a Table to a SharePoint List - Page 719
Exporting a Table to a SharePoint List - Page 720
Exporting a Table to a SharePoint List - Page 721
Analyzing Data Using a PivotTable - Page 722
Create a Recommended PivotTable - Page 723
Create a Recommended PivotTable - Page 724
Create a PivotTable - Page 725
Create a PivotTable - Page 726
Create a PivotTable - Page 727
Analyzing Data Using a PivotChart - Page 728
Analyzing Data Using a PivotChart - Page 729
Updating a PivotTable or PivotChart - Page 730
Updating a PivotTable or PivotChart - Page 731
Updating a PivotTable or PivotChart - Page 732
Modifying a PivotTable - Page 733
Modifying a PivotTable - Page 734
Modifying a PivotTable - Page 735
Formatting a PivotTable - Page 736
Working with PivotTable Data - Page 737
Working with PivotTable Data - Page 738
Working with PivotTable Data - Page 739
Search, Sort, or Filter in a PivotTable - Page 740
Repeat Labels in a PivotTable - Page 741
Repeat Labels in a PivotTable - Page 742
Using Slicers to Filter a PivotTable - Page 743
Using Slicers to Filter a PivotTable - Page 744
Share and Use a Slicer - Page 745
Share and Use a Slicer - Page 746
Display a Timeline to Filter a PivotTable - Page 747
Display a Timeline to Filter a PivotTable - Page 748
Display a Timeline to Filter a PivotTable - Page 749
Drilling into PivotTable Data - Page 750
Drilling into PivotTable Data - Page 751
Charting a PivotTable - Page 752
Charting a PivotTable - Page 753
Modify a PivotChart Report - Page 754
Modify a PivotChart Report - Page 755
Modify a PivotChart Report - Page 756
Modify a PivotChart Report - Page 757
Presenting Data with Power View - Page 758
Presenting Data with Power View - Page 759
Presenting Data with Power View - Page 760
Presenting Data with Power View - Page 761
Format View in Power View - Page 762
Working with PowerPivot - Page 763
Working with PowerPivot - Page 764
Working with PowerPivot - Page 765
Creating Groups and Outlines - Page 766
Work an Outline or Group - Page 767
Converting Text to Columns - Page 768
Convert Text to Columns - Page 769
Convert Text to Columns - Page 770
Convert Text to Columns - Page 771
Adding Data Validation to a Worksheet - Page 772
Adding Data Validation to a Worksheet - Page 773
Adding Data Validation to a Worksheet - Page 774
Creating a Drop-Down List - Page 775
Creating a Drop-Down List - Page 776
Creating a Drop-Down List - Page 777
Creating a Drop-Down List - Page 778
11. Building More Powerful Worksheets - Page 779
Introduction - Page 780
Introduction - Page 781
Introduction - Page 782
Using the Euro Conversion - Page 783
Using the Euro Conversion - Page 784
Looking at Alternatives with Data Tables - Page 785
Looking at Alternatives with Data Tables - Page 786
Asking “What If” with Goal Seek - Page 787
Asking “What If” with Goal Seek - Page 788
Creating Scenarios - Page 789
Create and Show a Scenario - Page 790
Create and Show a Scenario - Page 791
Show a Scenario - Page 792
Create a Scenario Summary or PivotTable Report - Page 793
Create a Scenario Summary or PivotTable Report - Page 794
Using Solver - Page 795
Using Solver - Page 796
Using Solver - Page 797
Using Solver - Page 798
Using Solver - Page 799
Using Solver - Page 800
Using Inquire Tools - Page 801
Using Inquire Tools - Page 802
View a Workbook, Worksheet, or Cell Relationship Diagram - Page 803
View a Workbook, Worksheet, or Cell Relationship Diagram - Page 804
View a Workbook, Worksheet, or Cell Relationship Diagram - Page 805
Using Lookup and Reference Functions - Page 806
Use the HLOOKUP Function - Page 807
Use the HLOOKUP Function - Page 808
Using Text Functions - Page 809
Use Text Functions - Page 810
Use Text Functions - Page 811
Summarizing Data Using Subtotals - Page 812
Summarizing Data Using Subtotals - Page 813
Summarizing Data Using Functions - Page 814
Summarizing Data Using Functions - Page 815
Summarizing Data Using Functions - Page 816
Using Date & Time Functions - Page 817
Calculate the Day of the Week - Page 818
Working with Time - Page 819
Using Logical Functions - Page 820
Using Logical Functions - Page 821
Using Financial Functions - Page 822
Use Financial Functions - Page 823
Using Math Functions - Page 824
Using Statistical Functions - Page 825
Use Statistical Functions - Page 826
Using Information Functions - Page 827
Using Information Functions - Page 828
Using Compatibility Functions - Page 829
Using Compatibility Functions - Page 830
Using Compatibility Functions - Page 831
Using Web Functions - Page 832
Using Web Functions - Page 833
12. Protecting and Securing a Workbook - Page 834
Inspecting Workbooks - Page 835
Inspecting Workbooks - Page 836
Inspecting Workbooks - Page 837
Inspecting Workbooks - Page 838
Protecting a Worksheet - Page 839
Protecting a Worksheet - Page 840
Apply a Password to Edit Parts of a Worksheet - Page 841
Apply a Password to Edit Parts of a Worksheet - Page 842
Apply a Password to Edit Parts of a Worksheet - Page 843
Locking or Unlocking Worksheet Cells - Page 844
Hide or Show Formulas - Page 845
Hide or Show Formulas - Page 846
Adding Security Encryption to a Workbook - Page 847
Adding Password Protection to a Workbook - Page 848
Adding Password Protection to a Workbook - Page 849
Open a Workbook with Password Protection - Page 850
Change or Remove the Password Protection - Page 851
Adding a Digital Signature - Page 852
Create an Digital ID - Page 853
Create an Digital ID - Page 854
View or Remove Signatures - Page 855
Adding a Signature Line - Page 856
Add a Signature Line - Page 857
Sign the Signature Line - Page 858
Sign the Signature Line - Page 859
Sign the Signature Line - Page 860
Avoiding Harmful Attacks - Page 861
Avoiding Harmful Attacks Using Office - Page 862
Using the Trust Center - Page 863
Using the Trust Center - Page 864
Using the Trust Center - Page 865
Selecting Trusted Publishers and Locations - Page 866
Selecting Trusted Publishers and Locations - Page 867
Setting Document Related Security Options - Page 868
Set Options for Protected View - Page 869
Set Options for Protected View - Page 870
Set Options for File Block Settings - Page 871
Setting App Catalog Security Options - Page 872
Set App Catalog Security Options - Page 873
Set App Catalog Security Options - Page 874
Setting Add-in Security Options - Page 875
Setting Add-in Security Options - Page 876
Setting ActiveX Security Options - Page 877
Setting ActiveX Security Options - Page 878
Setting Macro Security Options - Page 879
Changing Message Bar Security Options - Page 880
Modify Message Bar Security Options - Page 881
Setting Privacy Options - Page 882
Set Privacy Options - Page 883
Set Privacy Options - Page 884
Setting External Content Security Options - Page 885
Setting External Content Security Options - Page 886
Set Security Settings for Document Links - Page 887
Set Security Settings for Document Links - Page 888
Set Security Settings for Document Links - Page 889
Working with Office Safe Modes - Page 890
View Disabled Items - Page 891
View Disabled Items - Page 892
Marking a Workbook as Read-Only - Page 893
Mark a Workbook as Final - Page 894
Mark a Workbook as Final - Page 895
13. Reviewing and Sharing Workbook Data - Page 896
Introduction - Page 897
Introduction - Page 898
Introduction - Page 899
Change Sharing Options - Page 900
Change Sharing Options - Page 901
Change Sharing Options - Page 902
Creating and Reading a Cell Comment - Page 903
Read a Comment - Page 904
Editing and Deleting a Cell Comment - Page 905
Delete a Comment - Page 906
Delete a Comment - Page 907
Tracking Workbook Changes - Page 908
Tracking Workbook Changes - Page 909
Accept or Reject Tracked Changes - Page 910
Accept or Reject Tracked Changes - Page 911
Sending a Workbook Using E-Mail - Page 912
Sending a Workbook Using E-Mail - Page 913
Sending a Workbook by Internet Fax - Page 914
Send a Workbook by Internet Fax - Page 915
Send a Workbook by Internet Fax - Page 916
Sending a Workbook by Instant Message - Page 917
Sending a Workbook by Instant Message - Page 918
Presenting a Workbook Online - Page 919
Present a Workbook in a Lync Meeting or Conversation - Page 920
Present a Workbook in a Lync Meeting or Conversation - Page 921
Sharing Information Between Programs - Page 922
Linking - Page 923
Create a Link Between Worksheets or Workbooks - Page 924
Create a Link Between Worksheets or Workbooks - Page 925
Linking and Embedding Files - Page 926
Linking and Embedding Files - Page 927
Embed a New Object - Page 928
Embed a New Object - Page 929
Embed or Link to an Existing Object - Page 930
Embed or Link to an Existing Object - Page 931
Exporting and Importing Data - Page 932
Exporting and Importing Data - Page 933
Export a File to Another Program Format - Page 934
Export a File to Another Program Format - Page 935
Import a Text File - Page 936
Consolidating Data - Page 937
Consolidate Data from Other Worksheets or Workbooks - Page 938
Consolidate Data from Other Worksheets or Workbooks - Page 939
Consolidate Data from Other Worksheets or Workbooks - Page 940
Consolidate Data from Other Worksheets or Workbooks - Page 941
Consolidate Data from Other Worksheets or Workbooks - Page 942
Getting External Data - Page 943
Security - Page 944
Getting Text Data - Page 945
Getting Text Data - Page 946
Getting Text Data - Page 947
Connecting to External Data - Page 948
Connecting to External Data - Page 949
Change Connection Properties - Page 950
Change Connection Properties - Page 951
Change Connection Properties - Page 952
Getting Query Data from a Database - Page 953
Getting Query Data from a Database - Page 954
Create a Database Query - Page 955
Create a Database Query - Page 956
Create a Database Query - Page 957
Getting Data from Microsoft Access - Page 958
Getting Data from Microsoft Access - Page 959
Create an Excel Workbook PivotTable from an Access Database - Page 960
Create an Excel Workbook PivotTable from an Access Database - Page 961
Working with XML - Page 962
Working with XML - Page 963
Change XML Data Map Properties - Page 964
Change XML Data Map Properties - Page 965
Creating an XML Data Map - Page 966
Creating an XML Data Map - Page 967
Import XML Data - Page 968
Import XML Data - Page 969
Import XML Data - Page 970
Saving or Exporting Data in XML - Page 971
Saving or Exporting Data in XML - Page 972
Saving or Exporting Data in XML - Page 973
Saving or Exporting Data in XML - Page 974
14. Publishing Workbook Data as Web Pages - Page 975
Opening a Workbook as a Web Page - Page 976
Opening a Workbook as a Web Page - Page 977
Previewing a Web Page - Page 978
Previewing a Web Page - Page 979
Previewing a Web Page - Page 980
Creating a Hyperlink - Page 981
Creating a Hyperlink - Page 982
Jump to a Hyperlink - Page 983
Jump to a Hyperlink - Page 984
Remove a Hyperlink - Page 985
Formatting a Hyperlink - Page 986
Formatting a Hyperlink - Page 987
Formatting a Hyperlink - Page 988
Changing Web Page Options - Page 989
Changing Web Page Options - Page 990
Saving a Worksheet as a Web Page - Page 991
Save a Workbook or Worksheet as a Web Page - Page 992
Save a Workbook or Worksheet as a Single File Web Page - Page 993
Save a Workbook or Worksheet as a Single File Web Page - Page 994
Save a Workbook or Worksheet as a Single File Web Page - Page 995
Publishing a Web Page - Page 996
Publishing a Web Page - Page 997
Copying a Web Table to a Worksheet - Page 998
Copying a Web Table to a Worksheet - Page 999
Creating Refreshable Web Queries - Page 1000
Creating Refreshable Web Queries - Page 1001
Creating Refreshable Web Queries - Page 1002
Getting Data from Web Queries - Page 1003
Getting Data from Web Queries - Page 1004
Getting Documents from the Web - Page 1005
Access a FTP Site - Page 1006
Access a FTP Site - Page 1007
15. Tools for Working More Efficiently - Page 1008
Setting General Excel Options - Page 1009
Setting New Workbook and Start Up Options - Page 1010
Change New Workbook and Start Up Options - Page 1011
Setting Editing Options - Page 1012
Setting Editing Options - Page 1013
Setting Editing Options - Page 1014
Change Cut, Copy, and Paste Options - Page 1015
Setting Image Options - Page 1016
Change Image Options - Page 1017
Setting Chart Options - Page 1018
Setting Chart Options - Page 1019
Setting Workbook and Worksheet Display Options - Page 1020
Change Workbook Display Options - Page 1021
Change Worksheet Display Options - Page 1022
Change Worksheet Display Options - Page 1023
Setting Display View Options - Page 1024
Change Display View Options - Page 1025
Setting Advanced Options - Page 1026
Change Advanced Options - Page 1027
Setting Formula Options - Page 1028
Change Formula Options - Page 1029
Change Formula Options - Page 1030
Changing Advanced Document Properties - Page 1031
Changing Advanced Document Properties - Page 1032
Customizing the Way You Create Objects - Page 1033
Customize the Way You Create Shape Objects - Page 1034
Accessing Commands Not in the Ribbon - Page 1035
Accessing Commands Not in the Ribbon - Page 1036
Accessing Commands Not in the Ribbon - Page 1037
Working with Office Tools - Page 1038
Working with Office Tools - Page 1039
Work with the Upload Center - Page 1040
Work with the Upload Center - Page 1041
Maintaining and Repairing Office - Page 1042
Perform Maintenance on Office Programs - Page 1043
Perform Maintenance on Office Programs - Page 1044
16. Expanding Excel Functionality - Page 1045
Adding and Inserting Apps for Office - Page 1046
Adding and Inserting Apps for Office - Page 1047
Insert an App for Office - Page 1048
Insert an App for Office - Page 1049
Viewing and Managing Add-ins - Page 1050
View Installed Add-ins - Page 1051
Manage Installed Add-ins - Page 1052
Manage Installed Add-ins - Page 1053
Manage Installed Add-ins - Page 1054
Loading and Unloading Add-ins - Page 1055
Load or Unload an Add-in - Page 1056
Load or Unload a COM Add-in - Page 1057
Load or Unload a COM Add-in - Page 1058
Enhancing a Workbook with VBA - Page 1059
Working with Procedures - Page 1060
Working with Modules - Page 1061
Viewing the Visual Basic Editor - Page 1062
Viewing the Visual Basic Editor - Page 1063
Understanding How Macros Automate Your Work - Page 1064
Understanding How Macros Automate Your Work - Page 1065
Recording a Macro - Page 1066
Recording a Macro - Page 1067
Recording a Macro - Page 1068
Creating a Macro - Page 1069
Creating a Macro - Page 1070
Creating a Macro - Page 1071
Running a Macro - Page 1072
Delete a Macro - Page 1073
Controlling a Macro - Page 1074
Debug a Macro Using Step Mode - Page 1075
Debug a Macro Using Step Mode - Page 1076
Edit a Macro - Page 1077
Copy a Macro Module to Another Workbook - Page 1078
Adding a Digital Signature to a Macro Project - Page 1079
Sign a Macro Project - Page 1080
Assigning a Macro to a Toolbar or Ribbon - Page 1081
Assigning a Macro to a Toolbar or Ribbon - Page 1082
Assigning a Macro to a Toolbar or Ribbon - Page 1083
Assigning a Macro to a Toolbar or Ribbon - Page 1084
Saving a Workbook with Macros - Page 1085
Opening a Workbook with Macros - Page 1086
Open a Workbook with Macros - Page 1087
Open a Workbook with Macros - Page 1088
Open a Workbook with Macros - Page 1089
Inserting ActiveX Controls - Page 1090
Deal with an ActiveX Control Security Alert - Page 1091
Deal with an ActiveX Control Security Alert - Page 1092
Deal with an ActiveX Control Security Alert - Page 1093
Deal with an ActiveX Control Security Alert - Page 1094
Using ActiveX Controls - Page 1095
Setting ActiveX Control Properties - Page 1096
Setting ActiveX Control Properties - Page 1097
Adding VBA Code to an ActiveX Control - Page 1098
Adding VBA Code to an ActiveX Control - Page 1099
17. Working Online with Office Documents - Page 1100
Working Online with SharePoint and SkyDrive - Page 1101
SkyDrive or SkyDrive Pro? - Page 1102
Using Office Web Apps - Page 1103
Using Office Web Apps - Page 1104
Signing in to SharePoint or SkyDrive - Page 1105
Signing in to SharePoint or SkyDrive - Page 1106
Sign in to SkyDrive - Page 1107
Add Online Storage Services - Page 1108
Saving and Opening on SharePoint or SkyDrive - Page 1109
Save an Office Document to SharePoint or SkyDrive - Page 1110
Open an Office Document from SharePoint or SkyDrive - Page 1111
Open an Office Document from SharePoint or SkyDrive - Page 1112
Set Browser View Options - Page 1113
Accessing Documents on SharePoint - Page 1114
Access SharePoint in a Web Browser - Page 1115
Access SharePoint from a Desktop - Page 1116
Access SharePoint from a Desktop - Page 1117
Syncing Documents on SharePoint - Page 1118
Set Up or Change SkyDrive Pro for a SharePoint Site - Page 1119
Work with SkyDrive Pro on SharePoint - Page 1120
Work with SkyDrive Pro on SharePoint - Page 1121
Work with SkyDrive Pro on SharePoint - Page 1122
Sharing Documents on SkyDrive - Page 1123
Get a Sharing Link to a SkyDrive Document - Page 1124
Post a SkyDrive Document Link to a Social Network - Page 1125
Post a SkyDrive Document Link to a Social Network - Page 1126
Accessing Documents on SkyDrive - Page 1127
Accessing Documents on SkyDrive - Page 1128
Access a SkyDrive from a Desktop or Device - Page 1129
Access a SkyDrive from a Desktop or Device - Page 1130
Managing Documents on SkyDrive - Page 1131
Managing Documents on SkyDrive - Page 1132
Work with SkyDrive Files or Folders from a Desktop - Page 1133
Work with SkyDrive Files or Folders from a Desktop - Page 1134
Downloading or Uploading Documents on SkyDrive - Page 1135
Download or Upload a File or Folder on SkyDrive - Page 1136
Creating Office Documents on SkyDrive - Page 1137
Create Office Documents on SkyDrive - Page 1138
Sending Links to Documents on SkyDrive - Page 1139
Sending Links to Documents on SkyDrive - Page 1140
Embed a Link to a File or Folder in a Blog or Web Page - Page 1141
Embed a Link to a File or Folder in a Blog or Web Page - Page 1142
Embed a Link to a File or Folder in a Blog or Web Page - Page 1143
Comparing the Office Desktop App to the Web App - Page 1144
Desktop App - Page 1145
Web App (Edit in Browser) - Page 1146
Working with Office Web Apps - Page 1147
Working with Office Web Apps - Page 1148
Edit an Office Document Using Office Web Apps - Page 1149
Edit an Office Document Using Office Web Apps - Page 1150
Saving or Printing Documents in Office Web Apps - Page 1151
Saving or Printing Documents in Office Web Apps - Page 1152
Print or PDF an Office Document in an Office Web App - Page 1153
Print or PDF an Office Document in an Office Web App - Page 1154
Print or PDF an Office Document in an Office Web App - Page 1155
Co-authoring Documents with Office Web Apps - Page 1156
Co-author an Office Document on SharePoint - Page 1157
Co-author an Office Document on SharePoint - Page 1158
Co-author an Office Document on SharePoint - Page 1159
Co-author an Office Document on SharePoint - Page 1160
New! Features - Page 1161
New! Features - Page 1162
New! Features - Page 1163
Office Tools - Page 1164
Office Tools - Page 1165
Office Tools - Page 1166
What Happened To . . . - Page 1167
Microsoft Office Specialist - Page 1168
Preparing for a MOS Exam - Page 1169
Preparing for a MOS Exam - Page 1170
Taking a MOS Exam - Page 1171
Taking a MOS Exam - Page 1172
Taking a MOS Exam - Page 1173
Taking a MOS Exam - Page 1174
The Exam Experience - Page 1175
Tips for Taking an Exam - Page 1176
Exam Results - Page 1177