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