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

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.