Learning Microsoft Office 2013

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