Learning Microsoft Office 2013

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 ̵