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

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.