Title Details

Customize the Quick Access Toolbar 4

Customize the Ribbon 6

Control the Ribbon Display 8

Automate Office Tasks with Macros 10

Change the Default Font and Size 12

Chapter 2 Timesaving Tips for Office Files

Change the Default File Save Location 16

Save Office Files as PDF Documents 18

Remove Sensitive Document Information 20

Encrypt a Document 22

Add a Digital Signature 24

Recover an Unsaved Document 26

Chapter 3 Boosting Your Productivity in Word

Add a Header or Footer Building Block 30

Create a Blog Post 32

Search Through a Document 34

Fix Misspellings with AutoCorrect 36

Emphasize Text with Drop Caps 38

Set a New Default Line Spacing 40

Quickly Insert a Horizontal Line 42

Resume Numbering in an Interrupted Numbered List 43

Set Off a Paragraph with a Border 44

Track Changes in a Document 46

Compare Documents 48

Summarize Information with a Chart 50

Chapter 4 Utilizing Word's Document Building Tools

Insert Footnotes and Endnotes 54

Generate a Table of Contents 56

Add a Cross-Reference 58

Chapter 5 Optimizing Excel

Automatically Open Your Favorite Workbook 62

Automate Data Entry with AutoFill 64

Color-Code and Name Worksheet Tabs 66

Protect Cells from Unauthorized Changes 68

Generate Random Numbers in Your Cells 70

Freeze Headings for Easier Scrolling 71

Insert a Comment in a Formula 72

Join Text from Separate Cells 73

Audit a Worksheet for Errors 74

Create Projections 76

Create a Database Table 78

Add and Edit Records Using Data Forms 80

Chapter 6 Polishing Your Spreadsheet Data

Apply Workbook Themes 84

Change Gridline Color 86

Print Gridlines 87

Add a Background Color, Pattern, or Image 88

Color-Code Your Data with Conditional Formatting 90

Wrap Text for Easy Reading 92

Change Cell Text Orientation 93

Center-Align Printed Data 94

Center Text Across Columns without Merging Cells 95

Chapter 7 Increasing PowerPoint's Potential

Convert a Word Document into a Presentation 98

Organize a Presentation into Sections 100

Reuse a Slide from Another Presentation 102

Rehearse Timings 104

Add an Equation 106

Create a Self-Running Presentation 107

Write on a Slide During a Presentation 108

Create Speaker Notes 110

Print Handouts 111

Compress Media Files 112

Turn a Presentation into a Video 114

Broadcast a Presentation 116

Chapter 8 Enhancing Your Presentations

Create a Custom Slide Layout 120

Insert a Custom Slide Master 122

Streamline Your Presentation with Themes 124

Customize a Theme 126

Save a Custom Theme 128

Add a Picture to Your Presentation 130

Insert a SmartArt Graphic 132

Add Video or Sound to Your Presentation 134

Animate Your Slides 136