Introduction vii
Navigating the Textbook and Supplemental Print Resources ix
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 Office 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 – Chart Printing and Publishing. 546
Lesson 28 – Using Charts in Other Files . 550
Lesson 29 – Making Special Purpose Charts. 555
End-of-Chapter Activities . 561
¿
Microsoft PowerPoint 2013
Chapter 1
Getting Started with Microsoft PowerPoint 2013 . 564
Lesson 1 – Get ting Started with PowerPoint. 566
Lesson 2 – Working with Slides. 574
Lesson 3 – Working with Headers, Footers, and Notes. 582
Lesson 4 – Inserting and Format ting Pictures. 589
Lesson 5 – Formatting Text. 595
Lesson 6 – Aligning Text. 601
Lesson 7 – Displaying the Presentation Outline . 608
Lesson 8 – Arranging Slides. 612
Lesson 9 – Adding Slide Transitions. 617
End-of-Chapter Activities . 621
¿
Chapter 2
Working with Lists and Graphics . 624
Lesson 10 – Working with Lists. 626
Lesson 11 – Inserting Online Pictures. 631
Lesson 12 – Inserting Symbols and Text Boxes . 636
Lesson 13 – Drawing and Format ting Shapes . 642
Lesson 14 – Positioning and Grouping Shapes. 652
Lesson 15 – Creating WordArt . 661
Lesson 16 – Creating SmartArt Diagrams. 666
Lesson 17 – Creating a Photo Album. 674
End-of-Chapter Activities . 679
¿
Chapter 3
Enhancing a Presentation. 682
Lesson 18 – Modifying a Theme. 684
Lesson 19 – Modifying a Background. 689
Lesson 20 – Animating Slide Objects. 695
Lesson 21 – Creating Multimedia Presentations. 702
Lesson 22 – Working with Tables . 710
Lesson 23 – Working with Charts. 716
End-of-Chapter Activities . 722
Index . 725
¿
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 4
Advanced Functions, PivotCharts, and PivotTables
Lesson 30 – Working with Hyperlinks
Lesson 31 – Using Advanced Sort
Lesson 32 – Using Advanced Filtering
Lesson 33 – Using Advanced Functions to Predict Trends
Lesson 34 – Using Advanced Functions for Data Analysis
Lesson 35 – Using LOOKUP Functions
Lesson 36 – Working with PivotTables and PivotCharts
Lesson 37 – Working with the Excel Data Model
Lesson 38 – Working with PowerPivot and Power View
End-of-Chapter Activities
¿
¿