Office 2013 All-In-One Absolute Beginner's Guide

Patrice-Anne Rutledge is a business technology author and consultant who specializes in teaching others to maximize the power of new technologies. Patrice has used—and has trained others to use—Microsoft Office for many years. She is the author of numerous books about Office for Pearson Education, including Easy Office 2013 and PowerPoint 2013 Absolute Beginner’s Guide. She can be reached through her website at www.patricerutledge.com.

Introduction ...............................................................................................................1

How This Book Is Organized .................................................................................... 2

Conventions Used in This Book ............................................................................... 2

I Introducing Microsoft Office 2013

1 Getting Started with Microsoft Office 2013 ......................................................3

Exploring the Start Screen ........................................................................................ 4

Setting Up Your Office Account .............................................................................. 5

Using the Ribbon Tabs ............................................................................................. 6

Using Backstage View ............................................................................................... 8

Using Toolbars ........................................................................................................... 9

  Using the Quick Access Toolbar ......................................................................... 9

  Using the Mini Toolbar ......................................................................................10

Using Task Panes .....................................................................................................10

Getting Help ............................................................................................................11

2 Working with Office Applications .......................................................................13

Working with Files ...................................................................................................14

  Creating a New File ...........................................................................................14

  Opening a File ....................................................................................................14

  Renaming a File ..................................................................................................15

  Saving a File .......................................................................................................16

  Closing a File ......................................................................................................17

  Deleting a File ...................................................................................................18

  Printing a File ......................................................................................................18

Sharing Files .............................................................................................................19

  Preparing to Share Files ....................................................................................19

  Sharing Files with Others ...................................................................................21

  Sharing via a Link ...............................................................................................22

  Sharing on Social Networks ..............................................................................23

  Sharing via Email ................................................................................................24

Exporting Files .........................................................................................................25

  Saving as a PDF or XPS Document ..................................................................25

  Changing to Another File Type ........................................................................27

Customizing Office .................................................................................................28

  Customizing the Quick Access Toolbar ...........................................................28

  Customizing Office Options ..............................................................................29

  Setting File Properties .......................................................................................32

3 Working with Text .................................................................................................33

Formatting Text .......................................................................................................34

  Enhancing Text ...................................................................................................34

  Using the Formatting Tools on the Home Tab ...............................................35

  Formatting Text with Options in the Font Dialog Box...................................36

  Formatting Text with Options in the Paragraph Dialog Box .........................38

  Formatting Text with the Mini Toolbar ............................................................39

Using Bullets ............................................................................................................39

Using Numbered Lists .............................................................................................40

Using WordArt .........................................................................................................41

  Inserting WordArt ...............................................................................................42

  Formatting WordArt ...........................................................................................42

Using Text Boxes .....................................................................................................43

  Inserting a Text Box ...........................................................................................44

Moving and Resizing a Text Box ......................................................................44

  Formatting a Text Box .......................................................................................45

Inserting Symbols and Equations ..........................................................................46

Proofing Your Text ..................................................................................................47

  Setting Spelling Check Options .......................................................................47

  Checking Your Spelling .....................................................................................48

Looking Up a Synonym in the Thesaurus .............................................................49

4 Working with Pictures ...........................................................................................51

Using Pictures in Office ...........................................................................................52

Inserting Pictures .....................................................................................................53

Inserting Online Pictures .........................................................................................54

  Inserting Pictures from the Office.com Clip Art Collection ...........................54

  Inserting Pictures from the Bing Image Search...............................................55

  Inserting Pictures from Your SkyDrive Account ..............................................56

Inserting Screenshots ..............................................................................................58

Modifying Pictures ...................................................................................................58

  Adjusting Pictures ...............................................................................................59

  Applying Artistic Effects ....................................................................................61

  Compressing Pictures ........................................................................................61

  Changing to a Different Picture ........................................................................62

  Resetting a Picture .............................................................................................62

  Working with Picture Styles ...............................................................................63

  Arranging Pictures ..............................................................................................66

  Cropping Pictures ...............................................................................................66

  Modifying a Picture’s Height and Width .........................................................66

  Using the Format Picture Pane .........................................................................67

5 Working with Shapes and SmartArt ...................................................................69

Inserting Shapes ......................................................................................................70

  Inserting Lines and Arrows ................................................................................71

  Inserting Rectangles and Ovals ........................................................................72

Formatting Shapes Using the Drawing Tools – Format Tab ..............................72

  Working with Shape Quick Styles .....................................................................73

  Specifying Shape Fill Color ...............................................................................74

  Specifying Shape Outlines ................................................................................78

  Applying Shape Effects .....................................................................................79

  Editing Shapes ....................................................................................................80

  Merging Shapes .................................................................................................80

Using the Format Shape Pane ...............................................................................81

Working with SmartArt Graphics ...........................................................................82

  Inserting a SmartArt Graphic ............................................................................83

  Using SmartArt Design Tools ............................................................................85

  Formatting SmartArt Graphics ..........................................................................88

6 Using Microsoft Office on the Web and Mobile Devices ..............................91

Using SkyDrive .........................................................................................................92

     Getting Started with SkyDrive...........................................................................92

  Uploading Files to SkyDrive ..............................................................................94

Using SkyDrive Mobile Apps ..................................................................................94

Using Office Web Apps ..........................................................................................95

  Creating a New File Using Office Web Apps .................................................95

  Exploring Office Web Apps ..............................................................................96

  Editing Files in Office Web Apps .....................................................................97

II Microsoft Word 2013

7 Word 2013 Basics ..................................................................................................99

Exploring Word ......................................................................................................100

  Exploring Word 2013 New Features ..............................................................100

  Exploring Word File Types ..............................................................................101

Starting a New Document ....................................................................................102

Viewing Multiple Documents ...............................................................................104

8 Formatting Pages ................................................................................................ 107

Setting Margins ......................................................................................................108

Creating Columns ..................................................................................................110

Changing Vertical Alignment ...............................................................................112

Adding Headers and Footers to a Document ....................................................114

  Adding Headers and Footers .........................................................................115

  Adding Page Numbers ....................................................................................118

Inserting Pages, Breaks, and Sections ................................................................119

  Inserting Pages .................................................................................................119

  Inserting Breaks ................................................................................................120

9 Using Templates ................................................................................................ 123

Understanding Templates ....................................................................................124

Applying a Template.............................................................................................124

Finding More Templates ......................................................................................126

Saving Templates ..................................................................................................127

10 Applying Advanced Formatting ....................................................................... 129

Applying a Theme .................................................................................................130

Applying Styles ......................................................................................................132

  Choosing Style Sets .........................................................................................135

  Assigning Styles ................................................................................................135

  Creating New Styles .........................................................................................136

Adding Special Effects ..........................................................................................137

  Inserting Drop Caps .........................................................................................137

  Applying Text Effects .......................................................................................139

  Adding a Watermark ........................................................................................139

Adding Borders and Shading...............................................................................142

  Adding Text Borders ........................................................................................142

  Adding Page Borders ......................................................................................143

  Adding Shading ................................................................................................144

Adding Text with Quick Parts ..............................................................................145

  Inserting a Quick Part ......................................................................................146

  Creating Your Own Quick Parts ......................................................................147

11 Adding Tables and Charts ................................................................................. 149

Inserting Tables .....................................................................................................150

  Inserting a Basic Table .....................................................................................150

  Inserting a Table Using the Insert Table Dialog Box ...................................152

  Inserting and Creating a Quick Table ............................................................153

  Drawing a Custom Table .................................................................................154

  Inserting an Excel Spreadsheet as a Table ....................................................156

Selecting Table Parts ............................................................................................157

Modifying Tables ...................................................................................................159

  Changing Column Widths and Row Heights ................................................159

  Adding and Deleting Columns and Rows .....................................................161

  Adding and Deleting Cells ..............................................................................163

  Merging and Splitting Table Cells ..................................................................164

  Changing Cell Alignment and Margins .........................................................165

  Repositioning and Resizing Tables .................................................................166

  Enhancing a Table with Table Styles and Borders .......................................168

Inserting Charts ......................................................................................................170

  Understanding the Chart Types ......................................................................171

  Understanding Chart Parts ..............................................................................172

  Inserting a Chart ...............................................................................................173

  Entering Chart Data .........................................................................................175

  Editing Charts ...................................................................................................178

12 Printing Documents ............................................................................................ 183

    Previewing and Printing a Document ..................................................................184

  Previewing Pages .............................................................................................185

  Managing Print Settings ..................................................................................186

Controlling Page Setup ........................................................................................188

Printing Envelopes and Labels .............................................................................189

  Printing Envelopes ...........................................................................................189

  Printing Labels ..................................................................................................192

Using Word’s Mail Merge Tool ............................................................................196

13 Working with Longer Documents .................................................................... 207

Structuring Documents with Outline View ..........................................................208

Inserting Footnotes and Endnotes ......................................................................212

Adding Captions ...................................................................................................214

Inserting Cross-References ...................................................................................216

Creating an Index ..................................................................................................218

Creating a Table of Contents ...............................................................................221

Inserting Bookmarks ..............................................................................................223

Navigating Long Documents with the Navigation Pane ...................................225

14 Collaborating, Reviewing, and Sharing Documents ..................................... 229

Tracking and Reviewing Documents ...................................................................230

  Turning on Tracking .........................................................................................231

  Changing the Markup Display ........................................................................232

  Working with Comments .................................................................................235

  Reviewing Changes ..........................................................................................238

  Comparing Documents .........................................................................................239

Editing Portable Document Format (PDF) Files .................................................241

Sharing Documents with Others ..........................................................................241

III Microsoft Excel 2013

15 Excel 2013 Basics ................................................................................................ 243

Exploring the Excel Window ................................................................................244

Moving Around and Making Selections on a Sheet ..........................................247

     Keyboard Shortcuts for Quicker Navigation .................................................247

  Selecting a Range of Cells ..............................................................................248

Using Templates to Quickly Create New Workbooks .......................................249

  Using Microsoft’s Online Templates ..............................................................249

  Saving a Template............................................................................................250

  Opening a Locally Saved Template to Enter Data .......................................250

Working with Sheets and Tabs ............................................................................251

  Inserting a New Sheet .....................................................................................251

  Activating Another Sheet ................................................................................252

  Selecting Multiple Sheets ................................................................................252

  Deleting a Sheet ...............................................................................................252

  Moving or Copying Sheets Within the Same Workbook .............................253

  Moving or Copying Sheets Between Workbooks .........................................253

  Renaming a Sheet ............................................................................................254

  Coloring a Sheet Tab .......................................................................................254

Working with Rows and Columns ........................................................................254

  Selecting an Entire Row or Column ...............................................................255

  Inserting an Entire Row and Column .............................................................255

  Deleting an Entire Row and Column..............................................................256

  Moving Entire Rows and Columns .................................................................256

Working with Cells ................................................................................................257

  Selecting a Cell Using the Name Box ............................................................257

  Selecting Noncontiguous Cells and Ranges .................................................258

  Inserting Cells and Ranges ..............................................................................258

  Deleting Cells and Ranges ..............................................................................259

  Moving Cells and Ranges ................................................................................259

16 Entering Sheet Data ........................................................................................... 261

Understanding Excel Data Types ........................................................................262

Entering Data .........................................................................................................262

  Entering Different Types of Data into a Cell .................................................262

  Using Copy, Cut, Paste, Paste Special to Enter Data ..................................264

  Using Text to Columns to Separate Data in a Single Column ....................266

  Using Series to Quickly Fill a Range ..............................................................269

Editing and Managing Data .................................................................................270

  Editing Data ......................................................................................................270

  Working with Tables ........................................................................................272

  Fixing Numbers Stored as Text ......................................................................275

  Finding Data on Your Sheet ............................................................................277

  Using Data Validation to Limit Data Entry in a Cell .....................................279

17 Formatting Sheets and Cells ............................................................................. 283

Adjusting Row Heights and Column Widths ......................................................284

Aligning Text in a Cell ..........................................................................................285

  Merging Two or More Cells ............................................................................285

  Centering Text Across a Selection .................................................................286

  Wrapping Text in a Cell to the Next Line .....................................................287

  Indenting Cell Contents ..................................................................................287

  Changing Text Orientation .............................................................................288

Formatting Numbers .............................................................................................289

  Applying Number Formats with the Format Cells Dialog Box ..................290

Creating Hyperlinks ...............................................................................................295

Applying Conditional Formatting ........................................................................296

Using Cell Styles to Quickly Apply Formatting ..................................................297

Using Themes to Ensure Uniformity in Design ..................................................298

 Applying a New Theme ...................................................................................298

  Creating a New Theme ...................................................................................298

  Sharing a Theme ..............................................................................................300

18 Using Formulas .................................................................................................... 301

Entering a Formula into a Cell .............................................................................302

  Three Ways of Entering a Formula’s Cell References ..................................303

  Relative Versus Absolute Formulas ................................................................303

  Using a Cell on Another Sheet in a Formula .................................................304

  Using F4 to Change the Cell Referencing .....................................................305

  Using Mathematical Operators .......................................................................306

  Using Names to Simplify References .............................................................307

  Inserting Formulas into Tables ........................................................................310

  Converting Formulas to Values .......................................................................312

Copying a Formula to Another Cell ....................................................................313

  Copying a Formula Using the Fill Handle .....................................................313

  Copying a Formula by Using Ctrl+Enter .......................................................314

  Copying Formulas Rapidly Down a Column .................................................314

19 Using Functions ................................................................................................... 317

Understanding Functions ......................................................................................318

  Exploring a Function ........................................................................................318

  Finding Functions .............................................................................................318

Entering Functions Using the Function Arguments Dialog Box .......................319

Entering Functions Using In-Cell Tips .................................................................321

Using the AutoSum Button...................................................................................322

  SUM Rows and Columns at the Same Time ..................................................323

  Other Auto Functions ......................................................................................324

  Using the Status Bar for Quick Calculation Results ......................................324

  Using Quick Analysis for Column Totals ........................................................325

20 Sorting Data ......................................................................................................... 327

Sorting Excel Data .................................................................................................328

  Preparing Data ..................................................................................................328

  Opening the Sort Dialog Box .........................................................................328

  Sorting by Values .............................................................................................328

  Sorting by Color or Icon ..................................................................................330

Performing a Quick Sort .......................................................................................332

  Using the Quick Sort Buttons..........................................................................332

  Quick Sorting Multiple Columns.....................................................................333

Fixing Sort Problems .............................................................................................333

21 Filtering and Consolidating Data ..................................................................... 335

Filtering Data .........................................................................................................336

  Applying a Filter to a Data Set .......................................................................336

Managing Filters ....................................................................................................337

  Turning Filtering On for One Column ...........................................................337

  Filtering for Listed Items ..................................................................................338

  Filtering the Grouped Dates Listing ...............................................................339

     Using Text, Number, and Date Special Filters ..............................................340

  Filtering by Color or Icon ................................................................................341

  Filtering by Selection .......................................................................................342

  Allowing Filtering on a Protected Sheet ........................................................343

  Clearing a Filter ................................................................................................344

  Reapplying a Filter ...........................................................................................344

  Removing Duplicates from a Data Set ...........................................................345

Consolidating Data ...............................................................................................346

22 Preparing Workbooks for Distribution and Printing ................................... 349

Preparing to Print or Share Your Workbook .....................................................350

  Using Cell Comments to Add Notes to Cells ...............................................350

  Allowing Multiple Users to Edit a Workbook at the Same Time ................353

  Hiding and Unhiding Sheets ...........................................................................353

  Locking Rows or Columns in Place .................................................................353

     Protecting the Data on a Sheet ......................................................................355

Configuring Page Setup .......................................................................................355

  Repeating Rows or Columns on Each Printed Page ....................................356

  Scaling Your Data to Fit a Printed Page ........................................................356

  Creating a Custom Header or Footer ............................................................357

  Adding an Image to the Header and Footer ................................................358

  Adding Page Numbering to the Header and Footer ...................................359

  Using Page Break Preview to Set Page Breaks .............................................359

23 Creating Subtotals and Grouping Data .......................................................... 361

Creating Subtotals .................................................................................................362

  Using the SUBTOTAL Function .......................................................................362

  Summarizing Data Using the Subtotal Tool ..................................................363

  Copying the Subtotals to a New Location ....................................................366

  Formatting the Subtotals .................................................................................367

  Subtotaling by Multiple Columns ...................................................................367

  Sorting Subtotals ..............................................................................................368

  Adding Space Between Subtotaled Groups .................................................369

Grouping and Outlining Rows and Columns .....................................................370

24 Creating Charts and Sparklines ........................................................................ 373

Creating a Chart ....................................................................................................374

  Preparing Data ..................................................................................................374

  Elements of a Chart .........................................................................................374

  Types of Charts .................................................................................................376

  Adding a Chart to a Sheet ..............................................................................378

Modifying Charts ...................................................................................................380

  Adding, Removing, and Formatting Chart Elements ...................................380

  Editing and Formatting a Chart Title .............................................................381

  Changing the Display Units in an Axis ...........................................................382

  Applying Chart Styles and Colors ..................................................................382

  Applying Chart Layouts ...................................................................................383

  Moving or Resizing a Chart .............................................................................384

  Switching Rows and Columns .........................................................................384

  Changing an Existing Chart’s Type ................................................................384

  Updating Chart Data ........................................................................................384

Adding Sparklines to Data ...................................................................................385

  Adding Points to a Sparkline ..........................................................................386

  Spacing Markers in a Sparkline .......................................................................387

  Deleting Sparklines ..........................................................................................388

25 Creating Pivot Tables and Slicers .................................................................... 389

Creating a Pivot Table ..........................................................................................390

  Preparing Data for Use in a Pivot Table ........................................................390

  Pivot Table Compatibility ................................................................................391

  Pivot Table Field List ........................................................................................391

  Using the Quick Analysis Tool ........................................................................392

  Viewing Recommended Pivot Tables ............................................................393

  Creating a Pivot Table from Scratch ..............................................................394

Modifying a Pivot Table ........................................................................................397

  Removing a Field..............................................................................................397

  Renaming a Field..............................................................................................397

  Changing the Calculation Type of a Field Value ..........................................397

  Changing How a Pivot Table Appears on a Sheet .......................................398

  Sorting Pivot Tables ........................................................................................398

Creating Slicers ......................................................................................................399

IV Microsoft PowerPoint 2013

26 PowerPoint 2013 Basics .................................................................................... 401

Exploring PowerPoint ..........................................................................................402

  Exploring New PowerPoint 2013 Features ....................................................402

  Understanding PowerPoint Presentations .....................................................403

  Understanding PowerPoint Views ...................................................................406

  Exploring PowerPoint File Formats ................................................................408

Creating a Presentation ........................................................................................408

  Creating a Presentation with a Theme ..........................................................409

  Creating a Presentation from an Online Template or Theme .....................411

  Creating a Presentation from Scratch ............................................................413

Adding Slides to Your Presentation ....................................................................413

Adding Sections to Your Presentation ................................................................414

  Collapsing and Expanding Sections ...............................................................416

  Removing Sections ...........................................................................................416

27 Customizing Themes and Backgrounds .......................................................... 417

Applying a New Theme to Your Presentation ...................................................418

Applying Multiple Themes to a Single Presentation .........................................419

Applying a New Theme Variant ...........................................................................420

Formatting Presentation Backgrounds ................................................................420

  Formatting Your Presentation’s Background ................................................420

  Omitting Background Graphics ......................................................................422

  Resetting a Background ..................................................................................422

Customizing Themes .............................................................................................422

  Customizing Theme Color Schemes ..............................................................422

  Customizing Theme Fonts ...............................................................................425

  Customizing Theme Effects .............................................................................427

  Working with Custom Themes ........................................................................428

28 Formatting and Organizing Objects, Slides, and Presentations ................ 429

Manipulating Objects ............................................................................................430

  Cutting an Object .............................................................................................430

  Copying an Object ...........................................................................................430

  Pasting an Object .............................................................................................430

  Moving and Resizing an Object......................................................................432

Arranging Objects .................................................................................................432

  Layering Objects ..............................................................................................432

  Grouping Objects .............................................................................................433

  Aligning Objects ...............................................................................................434

  Rotating and Flipping Objects ........................................................................435

  Using the Selection Pane.................................................................................435

Working with Gridlines and Guides ....................................................................436

  Using Smart Guides .........................................................................................436

  Using the Grid and Guides Dialog Box .........................................................437

Organizing Slides ..................................................................................................437

  Using Slide Sorter View ...................................................................................437

  Copying and Moving Slides from One Presentation to Another ................438

  Deleting Slides ..................................................................................................440

  Changing Slide Size .........................................................................................440

29 Adding Tables to a Presentation .................................................................... 441

Understanding PowerPoint Tables ......................................................................442

Inserting a Table ....................................................................................................442

Drawing Custom Tables .......................................................................................444

Inserting Excel Spreadsheets ...............................................................................444

Formatting Tables .................................................................................................445

  Setting Table Style Options ............................................................................446

  Applying a Table Style .....................................................................................447

  Creating a Border .............................................................................................448

  Setting Table Fill Color ....................................................................................448

  Applying Table Effects .....................................................................................449

  Working with Columns and Rows ...................................................................449

  Merging and Splitting Cells ............................................................................450

     Specifying Other Layout Options ...................................................................451

  Adding Bulleted and Numbered Lists Within Tables ...................................451

Deleting Tables and Table Contents ..................................................................452

30 Outlining Presentations ..................................................................................... 453

Creating an Effective Presentation Outline ........................................................454

Using Outline View ................................................................................................454

Modifying Your Outline ........................................................................................455

  Promoting and Demoting Outline Points ......................................................456

  Moving Outline Points Up and Down ............................................................458

  Collapsing and Expanding Outline Points .....................................................458

  Showing Slide Formatting ...............................................................................458

Inserting an Outline from Another Application ..................................................459

31 Reviewing Presentations ................................................................................... 461

Understanding PowerPoint Reviewing Tools .....................................................462

Working with Comments ......................................................................................462

  Adding Comments to Slides ...........................................................................463

  Reviewing Comments ......................................................................................464

  Editing and Replying to Comments ...............................................................464

  Deleting Comments .........................................................................................465

  Hiding Comments ............................................................................................466

Comparing Presentations .....................................................................................466

  Working with the Revisions Pane ...................................................................467

  Viewing Revisions .............................................................................................469

  Accepting Changes ..........................................................................................469

  Rejecting Changes ...........................................................................................470

  Ending the Review ...........................................................................................470

32 Working with Charts........................................................................................... 471

Understanding Charts ...........................................................................................472

  Understanding Chart Terminology .................................................................473

  Understanding Chart Types ............................................................................473

Inserting Charts ......................................................................................................474

Inserting a Chart from Excel .................................................................................477

Modifying and Formatting Charts .......................................................................478

  Displaying, Hiding, and Modifying Chart Elements .....................................478

  Modifying Chart Design ..................................................................................480

  Formatting Charts ............................................................................................481

  Applying Chart Filters ......................................................................................482

  Saving Your Chart as a Template ...................................................................483

33 Working with Audio and Video ........................................................................ 485

Understanding Audio and Video Formats ..........................................................486

Inserting Audio Clips .............................................................................................486

  Inserting Online Audio .....................................................................................487

  Inserting Audio Clips from Your Computer ...................................................488

  Recording Audio Clips .....................................................................................489

  Deleting Audio Clips ........................................................................................490

Inserting Video Clips .............................................................................................490

  Inserting Online Video .....................................................................................490

  Inserting a Video Clip from Your Computer .................................................491

  Deleting a Video Clip ......................................................................................493

Formatting Audio and Video Clips ......................................................................493

  Adjusting Audio and Video Clips ...................................................................493

  Specifying a Video Poster Frame ...................................................................494

  Working with Audio and Video Styles ...........................................................494

  Arranging Audio and Video Clips ..................................................................495

  Resizing Audio and Video Clips .....................................................................495

Specifying Audio and Video Playback Options .................................................495

  Playing a Clip ....................................................................................................496

  Adding a Bookmark .........................................................................................496

  Editing Audio and Video Clips .......................................................................497

  Specifying Audio and Video Options ............................................................498

Compressing Media Files for Improved Performance .......................................498

Creating Videos from PowerPoint Presentations ...............................................499

34 Working with Animation and Transitions ....................................................... 503

Understanding Animation and Transitions .........................................................504

Setting Slide Transitions .......................................................................................504

Applying Animation to Objects ...........................................................................506

Customizing Animations on the Animation Pane ..............................................508

  Setting Additional Effects ................................................................................509

     Setting Timings .................................................................................................510

  Animating Charts ..............................................................................................510

  Animating Text .................................................................................................511

  Animating SmartArt Graphics .........................................................................512

  Animating Audio and Video Files ...................................................................512

  Viewing the Advanced Timeline .....................................................................513

Managing Animations ...........................................................................................513

  Reordering Animations ....................................................................................513

  Modifying Animations ......................................................................................513

  Removing Animations ......................................................................................513

  Reusing Animations with the Animation Painter ...........................................514

35 Working with Slide Masters .............................................................................. 515

Modifying the Slide Master ..................................................................................516

Adding a Slide Master ..........................................................................................517

Creating a Custom Layout ....................................................................................518

Managing Slide Masters .......................................................................................520

  Renaming a Slide Master or Layout ...............................................................520

  Duplicating a Slide Master or Layout .............................................................520

  Deleting a Slide Master or Layout ..................................................................521

  Preserving a Slide Master ................................................................................521

  Applying a Theme to a Slide Master .............................................................521

  Modifying the Handout and Notes Masters ..................................................522

36 Creating and Printing Presentation Materials ............................................... 525

Understanding PowerPoint Printing Options .....................................................526

Printing PowerPoint Presentations .......................................................................527

  Preparing to Print .............................................................................................527

  Customizing Headers and Footers .................................................................530

     Previewing a PowerPoint Presentation ..........................................................531

  Printing Your Presentation ...............................................................................532

  Creating Handouts in Microsoft Word ................................................................532

37 Presenting a Slide Show .................................................................................... 535

Exploring the Slide Show Tab ..............................................................................536

Setting Up a Show .................................................................................................536

Rehearsing Timings ...............................................................................................538

  Using Timings ...................................................................................................539

  Deleting Timings ..............................................................................................539

Recording Voice Narrations .................................................................................539

  Rerecording Narrations ....................................................................................540

  Playing Narrations ............................................................................................541

  Deleting Narrations ..........................................................................................541

Creating Custom Shows .......................................................................................541

Viewing Your Show................................................................................................543

  Navigating a Show Full Screen .......................................................................543

  Setting Pointer Options ...................................................................................545

  Using the Onscreen Pen to Mark Your Presentation ....................................546

Presenting Online ..................................................................................................547

Exploring Presenter View ......................................................................................548

Packaging a Presentation onto a CD ..................................................................550

V Microsoft Outlook 2013

38 Outlook 2013 Basics ........................................................................................... 553

Getting Started with Outlook ...............................................................................554

  Exploring Outlook ............................................................................................554

  Exploring Outlook 2013 New Features .........................................................556

Starting and Exiting Outlook ................................................................................557

Familiarizing Yourself with the Program Window ..............................................558

39 Setting Up Accounts and Personalizing Outlook .......................................... 561

Understanding Email Services and Internet Access ..........................................562

Adding Email Accounts to Outlook.....................................................................564

  Automatically Configuring an Account ..........................................................564

  Manually Configuring an Account ..................................................................566

  Editing Your Email Accounts ...........................................................................568

Working with Outlook Panes ................................................................................569

  Working with the Folder Pane ........................................................................570

  Working with the Reading Pane .....................................................................572

  Working with the To-Do Bar and Peeks ........................................................572

40 Performing Basic Email Tasks ........................................................................... 575

Composing and Sending Messages ....................................................................576

Reading and Replying to Messages ....................................................................578

  Checking for New Messages ..........................................................................581

  Replying to a Message ....................................................................................582

  Forwarding a Message ....................................................................................584

  Deleting a Message .........................................................................................585

Saving Messages ...................................................................................................585

  Saving a Draft Message ...................................................................................586

  Saving a Message File .....................................................................................587

Working with File Attachments ............................................................................588

  Attaching a File.................................................................................................588

  Opening an Attachment ..................................................................................589

Using Simple Message Tools ...............................................................................590

  Marking Messages as Read or Unread ..........................................................591

  Flagging Messages ..........................................................................................592

  Categorizing Messages ...................................................................................593

41 Managing Email .................................................................................................. 595

Organizing Messages with Folders .....................................................................596

  Making a New Email Folder ............................................................................596

  Moving a Message to Your New Folder ........................................................598

  Working with Folder Contents ........................................................................598

Routing Messages with Quick Steps ...................................................................598

Managing Incoming Messages with Rules ........................................................602

Controlling Junk Email ..........................................................................................603

Archiving Messages ..............................................................................................605

  Manually Archive Messages ............................................................................606

  Setting Up Automatic Archiving .....................................................................607

42 Working with Advanced Email Features ........................................................ 609

Setting Priority and Sensitivity Options ..............................................................610

Using Quick Parts ..................................................................................................611

Adding Signatures .................................................................................................612

Controlling Replies, Forwarding, and Receipts ..................................................614

Working with RSS Feeds .......................................................................................616

43 Using the Calendar ............................................................................................. 619

Displaying Your Calendar ....................................................................................620

Recording Events and Appointments .................................................................622

  Recording Events .............................................................................................622

  Recording Appointments ...............................................................................627

  Setting Reminders ............................................................................................630

Setting Up Meetings .............................................................................................631

 Sending an Invite ..............................................................................................631

  Tracking Invites .................................................................................................632

Sharing Your Calendar .........................................................................................634

44 Working with Contacts ...................................................................................... 637

Creating Contacts ..................................................................................................638

  Creating a New Contact in a Contact Form ..................................................638

  Creating a New Contact from an Email Message ........................................640

  Creating a New Contact from the Same Company .....................................642

Working with Contact Groups .............................................................................642

  Creating a Contact Group ..............................................................................642

  Creating a Contact Group from a List ...........................................................643

  Using a Contact Group ....................................................................................643

Managing Your Contacts ......................................................................................644

45 Working with Tasks and To-Do Lists ............................................................... 647

Creating Tasks ......................................................................................................648

  Entering Task Details .......................................................................................649

  Creating Recurring Tasks .................................................................................649

Completing Tasks ..................................................................................................650

Using Task Requests .............................................................................................651

  Creating a Task Request ..................................................................................652

  Accepting or Declining a Task Request .........................................................653

Viewing Tasks .......................................................................................................653

Creating To-Do Items ...........................................................................................655

46 Using Social Connector ..................................................................................... 657

Configuring the Social Connector ......................................................................658

  Setting Up Social Networking Accounts ........................................................659

  Turning Off Contact Photos ............................................................................660

  Showing or Hiding the Social Connector Pane.............................................660

Managing Social Connector Security ..................................................................661

  Managing Facebook Security .........................................................................661

  Who Sees Your Photo and Your People Pane Content? ............................662

47 Synchronizing and Sharing Outlook Data ...................................................... 663

Sharing Calendar and Contacts ...........................................................................664

  Syncing with Smartphones and Tablets .........................................................664

  Sharing with a Second Computer ..................................................................665

  Using Outlook.com to Share Calendar and Contacts ..................................666

  Moving Data to the Microsoft Account Data File .........................................668

Using Contacts in Other Programs ......................................................................668

48 Using Color Categories ...................................................................................... 669

Assigning Color Categories to Outlook Items ...................................................670

  Using the Quick Click Category......................................................................671

  Creating Additional Color Categories ...........................................................672

Managing Color Categories .................................................................................674

  Upgrading to Color Categories .....................................................................674

  Sharing Color Categories ...............................................................................675

  Removing Categories ......................................................................................675

49 Working with Notes .......................................................................................... 677

Exploring Outlook Notes ......................................................................................678

Creating a Note .....................................................................................................678

Emailing Notes ......................................................................................................679

    Organizing Your Notes .........................................................................................680

50 Using Folders ....................................................................................................... 681

Creating New Folders ...........................................................................................682

Managing Folders .................................................................................................683

51 Using Search ........................................................................................................ 685

Using Instant Search ............................................................................................686

  Using Instant Search Queries ..........................................................................686

  Using Partial Word Searches ...........................................................................687

Finding Related Messages ...................................................................................688

Searching on the People Pane .............................................................................688

Creating Search Folders .......................................................................................689

52 Working with Views ............................................................................................ 691

Managing Views ...................................................................................................692

  Changing Views ................................................................................................692

  Applying Views to Folders ..............................................................................693

     Resetting Views ................................................................................................694

  Copying Views ..................................................................................................694

Creating Custom Views ........................................................................................694

Using Conditional Formatting ..............................................................................696

VI Microsoft OneNote 2013

53 OneNote 2013 Basics ......................................................................................... 699

Creating a New Notebook ...................................................................................700

  Adding Notes to Your Notebook ...................................................................702

  Formatting Notes .............................................................................................702

  Applying Text Styles ........................................................................................703

  Saving Notebooks ............................................................................................703

Working with Sections ..........................................................................................703

  Creating a New Section ...................................................................................703

  Modifying Sections ...........................................................................................704

Working with Pages ..............................................................................................705

  Inserting a New Page .......................................................................................705

  Inserting a Page Based on a Template ..........................................................705

  Modifying Pages ...............................................................................................706

Working with Tags .................................................................................................708

  Applying a Tag .................................................................................................708

  Removing a Tag ..............................................................................................708

  Creating Custom Tags ....................................................................................709

  Finding Tags .....................................................................................................710

54 Inserting Notebook Content............................................................................. 711

Inserting Files .........................................................................................................712

  Attaching a File.................................................................................................712

  Inserting an Excel Spreadsheet ......................................................................713

Inserting Images ...................................................................................................714

Inserting Links ........................................................................................................715

Recording Audio and Video .................................................................................716

  Recording an Audio Clip .................................................................................716

  Recording a Video Clip....................................................................................717

Inserting Other Notebook Content .....................................................................718

  Inserting Extra Space .......................................................................................718

  Inserting a Table ...............................................................................................719

  Inserting a Timestamp .....................................................................................720

  Inserting Symbols and Equations ...................................................................721

Using OneNote Drawing Tools ............................................................................721

  Inserting a Drawing ..........................................................................................721

  Erasing a Drawing ............................................................................................723

55 Viewing and Managing Notebooks ................................................................. 725

Displaying Full Page View ....................................................................................726

Docking OneNote to Your Desktop ....................................................................726

Using Linked Note Taking ....................................................................................727

Setting Up OneNote Pages .................................................................................728

Working with Microsoft Outlook ..........................................................................729

  Emailing a Page ................................................................................................729

  Sending a Task to Outlook..............................................................................730

Using the Send to OneNote Tool .......................................................................731

  Sending a Screen Clipping to OneNote .......................................................731

  Sending Content to OneNote ........................................................................733

  Creating a Quick Note .....................................................................................733

Protecting Notebook Sections with a Password ................................................734

Viewing Notebook History ..................................................................................736

TOC, 978789751010, 7/24/2013