Learning Microsoft Office 2013 features a student-friendly, step-by-step format with clear, full-screen shots to engage readers and help them work independently. This book is appropriate for Introductory Computing courses on Microsoft Office Applications or courses on Computer Concepts that include coverage of Office 2013.This book is also suitable for individuals interested in learning to use Microsoft Office 2013 effectively in their home life and career.

Table of Contents:
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