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. MARKET: 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.

Table of Contents:
Office Basics Chapter 1 Using the Common Features of Microsoft Office 2013 2 Lesson 1 — Microsoft Office 2013 Basics 4 Lesson 2 — Saving, Printing, and Closing Microsoft Office Files 16 Lesson 3 — Working with Existing Files 24 Lesson 4 — Using Command Options 35 Lesson 5 — Managing Program Windows 44 Lesson 6 — Using Microsoft Of fi ce Help 57 Lesson 7 — Managing Information Technology 64 End-of-Chapter Activities 73   Microsoft Word 2013 Chapter 1 Getting Started with Microsoft Word 2013 78 Lesson 1 — Creating Word Documents with Headers and Footers 81 Lesson 2 — Formatting Documents with Themes and Styles 93 Lesson 3 — Editing and Correcting Documents 102 Lesson 4 — Adjusting Alignment and Spacing 109 Lesson 5 — Creating Letters and Envelopes 117 Lesson 6 — Formatting Text with Fonts and Effects 132 Lesson 7 — Formatting and Sorting Lists 141 Lesson 8 — Inserting Pictures, Text Boxes, and Shapes 148 Lesson 9 — Formatting Graphics Objects 159 Lesson 10 — Working with SmartArt Graphics, Text Effects, and Page Borders 171 End-of-Chapter Activities 179   Chapter 2 Editing Documents and Working with Tables 184 Lesson 11 — Checking Spelling and Grammar 187 Lesson 12 — Moving a Selection 197 Lesson 13 — Copying a Selection 203 Lesson 14 — Inserting a Table 208 Lesson 15 — Aligning Tables 218 Lesson 16 — Drawing a Table 226 Lesson 17 — Performing Calculations in a Table 234 Lesson 18 — Improving a Document with Find and Replace and AutoCorrect 241 Lesson 19 — Working with Templates and Different File Types 252 End-of-Chapter Activities 264   Chapter 3 Creating Reports and Newsletters 270 Lesson 20 — Changing Case and Managing Document Properties 272 Lesson 21 — Formatting a One-Page Report 279 Lesson 22 — Managing Sources and Controlling Text Flow 290 Lesson 23 — Working with Newsletter Columns 302 Lesson 24 — Enhancing Paragraphs with Dropped Capitals, Borders, and Shading 310 Lesson 25 — Using Format Painter, Highlights, Symbols, and Quick Parts 316 Lesson 26 — Creating Letters and Labels with Mail Merge  324 End-of-Chapter Activities 336   Microsoft Excel 2013 Chapter 1 Getting Started with Microsoft Excel 2013 340 Lesson 1 — Touring Excel 343 Lesson 2 — Worksheet and Workbook Basics 352 Lesson 3 — Adding Worksheet Contents 362 Lesson 4 — Worksheet Formatting 371 Lesson 5 — More on Cell Entries and Formatting  380 Lesson 6 — Working with Ranges  390 Lesson 7 — Creating Formulas  397 Lesson 8 — Copying and Pasting  403 Lesson 9 — Techniques for Moving Data  410 Lesson 10 — Sheet, Display, and Print Operations  417 End-of-Chapter Activities   423   Chapter 2 Working with Formulas and Functions  426 Lesson 11 — Getting Started with Functions  428 Lesson 12 — Using Excel Tables  437 Lesson 13 — Working with the NOW Function and Named Ranges  445 Lesson 14 — Working with IF Functions  451 Lesson 15 — Working with Text Functions                 461 Lesson 16 — Using Frozen Labels and Panes  469 Lesson 17 — Using Conditional Formatting and Find and Replace  474 Lesson 18 — Rotating Entries and Resolving Errors  479 Lesson 19 — Managing Worksheets and Performing Multi-Worksheet Operations  483 Lesson 20 — Modifying Print Options  490 End-of-Chapter Activities   500   Chapter 3 Charting Data   504 Lesson 21 — Building Basic Charts   506 Lesson 22 — Showing Percentages with a Pie Chart   515 Lesson 23 — Enhancing a Pie Chart  520 Lesson 24 — Adding Special Elements to a Chart or Sheet and Updating a Chart  526 Lesson 25 — Completing Chart Format ting  530 Lesson 26 — Comparing and Analyzing Data   539 Lesson 27 — Char t Printing and Publishing                546 Lesson 28 — Using Charts in Other Files   550 Lesson 29 — Making Special Purpose Charts  555 End-of-Chapter Activities   561   Chapter 4 Advanced Functions, PivotCharts, and PivotTables  564 Lesson 30 — Working with Hyperlinks   566 Lesson 31 — Using Advanced Sort  574 Lesson 32 — Using Advanced Filtering  582 Lesson 33 — Using Advanced Functions to Predict Trends  596 Lesson 34 — Using Advanced Functions for Data Analysis  603 Lesson 35 — Using LOOKUP Functions  614 Lesson 36 — Working with PivotTables and PivotCharts  620 Lesson 37 — Working with the Excel Data Model   630 Lesson 38 — Working with PowerPivot and Power View  636 End-of-Chapter Activities   641   Microsoft Access 2013 Chapter 1 Getting Started with Microsoft Access 2013  646 Lesson 1 — Planning a Database  648 Lesson 2 — Creating a Database with Access  655 Lesson 3 — Modifying and Adding Data to a Table  666 Lesson 4 — Modifying Fields in a Table  673 Lesson 5 — Importing and Protecting Data  680 Lesson 6 — Using Table Templates and Design View  690 Lesson 7 — Creating Other Objects   702 End-of-Chapter Activities   710   Chapter 2 Working with Queries  714 Lesson 8 — Managing Relationships Between Tables  716 Lesson 9 — Finding, Replacing, and Sorting Data   726 Lesson 10 — Filtering Data   732 Lesson 11 — Creating a Query in Design View   737 Lesson 12 — Creating a Multi-Table Query  745 Lesson 13 — Using Criteria in a Query  751 Lesson 14 — Using Comparison Operators  756 Lesson 15 — Using Calculated Fields  761 Lesson 16 — Summarizing Data in Queries  766 End-of-Chapter Activities   771   Chapter 3 Working with Forms and Reports   774 Lesson 17 — Creating and Using a Form   776 Lesson 18 — Working with a Form in Layout View  783 Lesson 19 — Working with a Form in Design View  793 Lesson 20 — Working with Form Sections   801 Lesson 21 — Creating a Report  808 Lesson 22 — Modifying a Report in Design View  819 Lesson 23 — Creating Labels  825 Lesson 24 — Creating a Lookup List                          828 Lesson 25 — Creating an Input Mask  836 End-of-Chapter Activities   842   Microsoft PowerPoint 2013 Chapter 1 Getting Started with Microsoft PowerPoint 2013   844 Lesson 1 — Get ting Started with PowerPoint  846 Lesson 2 — Working with Slides  854 Lesson 3 — Working with Headers, Footers, and Notes  862 Lesson 4 — Inserting and Format ting Pictures  869 Lesson 5 — Format ting Text  875 Lesson 6 — Aligning Text  881 Lesson 7 — Displaying the Presentation Outline   888 Lesson 8 — Arranging Slides  892 Lesson 9 — Adding Slide Transitions  897 End-of-Chapter Activities   901   Chapter 2 Working with Lists and Graphics   904 Lesson 10 — Working with Lists  906 Lesson 11 — Inserting Online Pictures  911 Lesson 12 — Inserting Symbols and Text Boxes   916 Lesson 13 — Drawing and Format ting Shapes   922 Lesson 14 — Positioning and Grouping Shapes  932 Lesson 15 — Creating WordArt   941 Lesson 16 — Creating SmartArt Diagrams  946 Lesson 17 — Creating a Photo Album  954 End-of-Chapter Activities   959   Chapter 3 Enhancing a Presentation  962 Lesson 18 — Modifying a Theme  964 Lesson 19 — Modifying a Background  969 Lesson 20 — Animating Slide Objects                        975 Lesson 21 — Creating Multimedia Presentations  982 Lesson 22 — Working with Tables  990 Lesson 23 — Working with Charts 996 End-of-Chapter Activities  1002 Index 1005   The following Bonus Chapters can be accessed from the Companion Web site www pearsonhighered com/learningseries The Bonus Chapters are also provided on the CD-ROM that accompanies the Teacher’s Wraparound Edition   Word Chapter 4 Printing Documents and Using the Internet Lesson 27 — Creating Forms Lesson 28 — Protecting Documents Lesson 29 — Inspecting and Checking Documents Lesson 30 — Marking a Document As Final and Using Digital Signatures Lesson 31 — Using Comments Lesson 32 — Managing Source Information and Generating Tables of Contents Lesson 33 — Formatting Web Pages with Word Lesson 34 — Using the World Wide Web Lesson 35 — Sharing Documents and Communicating with Word End-of-Chapter Activities   Excel Chapter 5 Advanced Formatting and Workbook Features Lesson 39 — Working with File Formats Lesson 40 — Working with Graphics and Saving a Worksheet As a Web Page Lesson 41 — Working with Web Data Lesson 42 — Linking and Embedding Data Lesson 43 — Working with Workbooks Lesson 44 — Working with Comments and Modifying Page Setup Lesson 45 — Using Copy and Paste Special Lesson 46 — Moving and Linking Data Between Workbooks Lesson 47 — Working with 3-D Formulas Lesson 48 — Working with Data Validation and Macros End-of-Chapter Activities   PowerPoint Chapter 4 Finalizing a Presentation Lesson 24 — Working with Masters Lesson 25 — Working with Themes and Templates Lesson 26 — Working with Links, Action Buttons, and External Content Lesson 27 — Organizing and Rehearsing a Slide Show Lesson 28 — Setting Up and Running a Slide Show Lesson 29 — Reviewing a Presentation Lesson 30 — Inspecting and Protecting a Presentation Lesson 31 — Sharing a Presentation End-of-Chapter Activities