Learning Microsoft Office 2013 Deluxe Edition

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