Microsoft Word 2013
Chapter 5 Using Advanced Formatting, Lists, and Charts 2
Lesson 36 — Inserting Text Files and Blank Pages 4
Lesson 37 — Creating and Editing Styles 10
Lesson 38 — Managing Style Formatting 18
Lesson 39 — Working with Multilevel Lists 29
Lesson 40 — Inserting Charts 35
Chapter 6 Using Reusable Content and Markup Tools 46
Lesson 41 — Customizing Language and Word Options 48
Lesson 42 — Using Advanced Find and Replace 58
Lesson 43 — Using Building Blocks 67
Lesson 44 — Inserting Fields from Quick Parts 73
Lesson 45 — Creating Custom Templates, Themes, and Style Sets 79
Lesson 46 — Tracking Changes 91
Lesson 47 — Comparing Documents 98
Lesson 48 — Restricting Access to Documents 107
End-of-Chapter Activities 112
Chapter 7 Using Advanced Tables and Graphics 116
Lesson 49 — Customizing Table Styles 118
Lesson 50 — Using Advanced Table Features 126
Lesson 51 — Using Advanced Graphics 137
Lesson 52 — Linking Text Boxes 146
Lesson 53 — Creating WordArt and Watermarks 155
End-of-Chapter Activities 161
Chapter 8 Working with Long Documents 166
Lesson 54 — Working with Outlines 168
Lesson 55 — Advanced Layout Options 176
Lesson 56 — Working with Master Documents 184
Lesson 57 — Creating Custom Headers and Footers, Bookmarks, and Cross-References 191
Lesson 58 — Creating an Index 200
Lesson 59 — Managing Source Information and Generating Special Tables 208
End-of-Chapter Activities 200
Chapter 9 Embedding and Linking Objects, Using Mail Merge, and Creating Macros 226
Lesson 60 — Copying, Moving, and Embedding Data and Objects 228
Lesson 61 — Linking Files and Objects 237
Lesson 62 — Integrating Word and PowerPoint 243
Lesson 63 — Creating a Directory with Mail Merge 248
Lesson 64 — Using Merge to Create E-mail 257
Lesson 65 — Working with Macros 263
End-of-Chapter Activities 275
Microsoft Excel 2013
Chapter 6 Managing Large Workbooks 280
Lesson 49 — Customizing the Excel Interface and Converting Text 282
Lesson 50 — Formatting Cells 290
Lesson 51 — Hiding and Formatting Workbook Elements 298
Lesson 52 — Customizing Styles and Themes 306
Lesson 53 — Customizing Data Entry 316
Lesson 54 — Formatting and Replacing Data Using Functions 323
Lesson 55 — Working with Subtotals 331
End-of-Chapter Activities 341
Chapter 7 Creating Charts, Shapes, and Templates 346
Lesson 56 — Formatting Chart Elements 348
Lesson 57 — Formatting the Value Axis 355
Lesson 58 — Creating Stacked Area Charts 364
Lesson 59 — Working with Sparklines and Trendlines 372
Lesson 60 — Drawing and Positioning Shapes 379
Lesson 61 — Formatting Shapes 385
Lesson 62 — Enhancing Shapes with Text and Effects 390
Lesson 63 — Working with Templates 397
End-of-Chapter Activities 407
Chapter 8 Creating Macros and Using Data Analysis Tools 412
Lesson 64 — Recording a Macro 414
Lesson 65 — Using Functions 424
Lesson 66 — Working with Absolute References and Using Financial Functions 433
Lesson 67 — Creating and Interpreting Financial Statements 440
Lesson 68 — Creating Scenarios and Naming Ranges 447
Lesson 69 — Finding and Fixing Errors in Formulas 454
End-of-Chapter Activities 462
Chapter 9 Importing and Analyzing Database Data 466
Lesson 70 — Importing Data into Excel 468
Lesson 71 — Working with Excel Tables
Lesson 72 — Using Advanced Filters, Slicers, and Database Functions 482
Lesson 73 — Using Flash Fill and Data Consolidation 493
Lesson 74 — Linking Workbooks 501
Lesson 75 — Using PivotTables 508
Lesson 76 — Using PivotCharts 516
Lesson 77 — Using PowerPivot and Power View 524
End-of-Chapter Activities 533
Chapter 10 Collaborating with Others and Preparing a Final Workbook for Distribution 536
Lesson 78 — Tracking Changes 538
Lesson 79 — Ensuring Data Integrity 548
Lesson 80 — Protecting Data 557
Lesson 81 — Securing a Workbook 564
Lesson 82 — Finalizing a Workbook 569
Lesson 83 - Sharing a Workbook 575
End-of-Chapter Activities 581
Microsoft Access 2013
Chapter 4 Customizing Tables and Databases 584
Lesson 26 — Normalizing and Analyzing Tables 586
Lesson 27 — Using Advanced Field and Table Properties 596
Lesson 28 — Formatting and Correcting Tables 604
Lesson 29 — Creating Macros 608
End-of-Chapter Activities 615
Chapter 5 Developing Advanced Queries 618
Lesson 31 — Creating Crosstab Queries 620
Lesson 32 — Creating Queries That Find Unmatched or Duplicate Records 627
Lesson 33 — Creating Queries That Prompt for Input 631
Lesson 34 — Creating Action Queries 637
Lesson 35 — Working with Advanced Query Options 641
End-of-Chapter Activities 647
Chapter 6 Customizing Forms and Reports 650
Lesson 36 — Working with Report Layouts 652
Lesson 37 — Working with Controls 660
Lesson 38 — Formatting Controls 671
Lesson 39 — Creating Special Forms 678
Lesson 40 — Working with Subforms and Subreports 683
Lesson 41 — Working with Charts 691
Lesson 42 — Creating Switchboards 699
Lesson 43 — Creating Navigation Forms 706
End-of-Chapter Activities 711
Chapter 7 Securing, Integrating, and Maintaining Data 714
Lesson 44 — Converting and Securing Data 716
Lesson 45 — Sharing Data with Word and Other Text Applications 721
Lesson 46 — Sharing Data with Excel and Access 727
Lesson 47 — Linking to Data Sources 734
Lesson 48 — Customizing Access 738
End-of-Chapter Activities 744
Microsoft PowerPoint 2013
Chapter 5 Working with Masters, Handouts, and Text 746
Lesson 32 — Working with Advanced Slide Master Features 748
Lesson 33 — Customizing Themes and Effects 755
Lesson 34 — Working with Notes and Handouts 760
Lesson 35 — Integrating PowerPoint with Word 769
Lesson 36 — Fine-Tuning Text Formats 776
Lesson 37 — Using Research Tools 784
End-of-Chapter Activities 790
Chapter 6 Working with Graphic Objects and Media 794
Lesson 38 — Applying Advanced Picture Formatting 796
Lesson 39 — Working with Advanced Multimedia Features 804
Lesson 40 — Applying Advanced Animations 810
Lesson 41 — Drawing and Adjusting Tables 818
Lesson 42 — Formatting Tables 828
Lesson 43 — Formatting Charts 835
End-of-Chapter Activities 844
Chapter 7 Finalizing and Sharing a Presentation 848
Lesson 44 — Making a Presentation Accessible to Everyone 850
Lesson 45 — Saving a Presentation in Other Formats 855
Lesson 46 — Working with Links and Actions 862
Lesson 47 — with Online Presentations 869
End-of-Chapter Activities 880
Index 885