Learning Microsoft Office 2013 Level 1 -- CTE/School

by ; ; ;
Edition: 1st
Format: Spiral Bound
Pub. Date: 2013-04-10
Publisher(s): Pearson
  • Free Shipping Icon

    Free Shipping on all Orders Over $35!*

    *excludes Marketplace items.

  • Buyback Icon We Buy This Book Back!
    In-Store Credit: $0.53
    Check/Direct Deposit: $0.50
List Price: $86.65

Buy New

Usually Ships in 2-3 Business Days
$86.22

Buy Used

In Stock
$62.39

Rent Textbook

Select for Price
There was a problem. Please try again later.

eTextbook

We're Sorry
Not Available

This item is being sold by an Individual Seller and will not ship from the Online Bookstore's warehouse. The Seller must confirm the order within two business days. If the Seller refuses to sell or fails to confirm within this time frame, then the order is cancelled.

Please be sure to read the Description offered by the Seller.

Summary

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. This book is 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 in their home life and career.

Table of Contents

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

¿

¿

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.