Title Details

Customize the Quick Access Toolbar.

Customize the Ribbon.

Control the Ribbon Display.

Share a Customized Ribbon.

Preview Paste Options.

Automate Office Tasks with Macros.

Change the Default Font and Size.

Organize Notes with OneNote.

Chapter 2: Timesaving Tips for Office Files.

Change the Default File Save Location.

Check Document Compatibility.

Save Office Files as PDF Documents.

Assign Document Properties.

Remove Sensitive Document Information.

Encrypt a Document.

Add a Digital Signature.

Control Author Permissions.

Mark a Document as Final.

Recover an Unsaved Document.

Chapter 3: Boosting Your Productivity in Word.

Add a Header or Footer Building Block.

Share Building Blocks with Others.

Translate Text.

Create a Blog Post.

Search Through a Document.

Look Up a Synonym or Definition.

Jump Around Documents with Bookmarks.

Navigate Long Documents with the Navigation Pane.

Automate Typing with AutoText.

Fix Misspellings with AutoCorrect.

Emphasize Text with Drop Caps.

Set a New Default Line Spacing.

Quickly Insert a Horizontal Line.

Resume Numbering in an Interrupted Numbered List.

Set Off a Paragraph with a Border.

Track Changes in a Document.

Compare Documents.

Add Filler Text.

Keep Words Together with a Nonbreaking Space.

Summarize Information with a Chart.

Chapter 4: Utilizing Word’s Document Building Tools.

Create a Bibliography.

Insert Footnotes and Endnotes.

Generate a Table of Contents.

Insert a Cover Page.

Generate an Index.

Add a Cross-Reference.

Add Line Numbers to Your Document.

Chapter 5: Optimizing Excel.

Automatically Open Your Favorite Workbook.

Automate Data Entry with AutoFill.

Color-Code and Name Worksheet Tabs.

Keep Cells in View with a Watch Window.

Protect Cells from Unauthorized Changes.

Generate Random Numbers in Your Cells.

Freeze Headings for Easier Scrolling.

Insert a Comment in a Formula.

Join Text from Separate Cells.

Add a Calculator to the Quick Access Toolbar.

Audit a Worksheet for Errors.

Create Projections.

Establish What-If Scenarios.

Set Goals with Goal Seek.

Define and Solve Problems with Solver.

Create a Database Table.

Add and Edit Records Using Data Forms.

Sort and Filter Records.

Restrict Cell Entries with Data-Validation Rules.

Chapter 6: Polishing Your Spreadsheet Data

Apply Workbook Themes.

Change Gridline Color.

Print Gridlines.

Add Emphasis with Borders.

Add a Background Color, Pattern, or Image.

Color-Code Your Data with Conditional Formatting.

Customize Your Chart with Chart Objects.

Reveal Trends with Trendlines.

Add Sparklines.

Wrap Text for Easy Reading.

Change Cell Text Orientation.

Center-Align Printed Data.

Center Text Across Columns without Merging Cells.

Chapter 7: Increasing PowerPoint’s Potential.

Convert a Word Document into a Presentation.

Organize a Presentation into Sections.

Send a Presentation to Reviewers.

Reuse a Slide from Another Presentation.

Rehearse Timings.

Record Narration.

Insert Action Buttons.

Insert a Hyperlink.

Add an Equation.

Create a Self-Running Presentation.

Write on a Slide During a Presentation.

Create Speaker Notes.

Print Handouts.

Compress Media Files.

Turn a Presentation into a Video.

Copy a Presentation to a CD.

Save a Presentation on SkyDrive.

Broadcast a Presentation.

Chapter 8: Enhancing Your Presentations.

Create a Custom Slide Layout.

Insert a Custom Slide Master.

Streamline Your Presentation with Themes.

Customize a Theme.

Save a Custom Theme.

Add a Picture to Your Presentation.

Insert a SmartArt Graphic.

Add Video or Sound to Your Presentation.

Edit a Video.

Animate Your Slides.

Create a Photo Album Presentation.

Chapter 9: Harnessing Access.

Save Time with Templates.

Import Data from Excel.

Collect Data from Outlook.

Type Less with Default Values.

Make a Field Required.

Set a Field Caption.

Copy a Previous Record.

Apply Input Masks.

Set Data Validation Rules.

Attach Files to Records.

Insert an OLE Object.

Save a Filter as a Query.

Display Summary Statistics.

View Object Dependencies.

Document the Database.

Export a Report to Word.

Create Mailing Labels.

Automate Access Tasks with Macros.

Chapter 10: Customizing Your Database and Forms.

Assign a Theme to a Form.

Change a Form’s Tab Order.

Jazz Up Your Forms with Pictures.

Add a Background to a Report.

Color-Code Your Data with Conditional Formatting.

Summarize a Datasheet with a PivotTable.

Summarize a Datasheet with a PivotChart.

Chapter 11: Streamlining Outlook Tasks.

Add Multiple E-mail Accounts.

Create Your Own Quick Steps.

Create a Distribution List.

Customize an E-mail Signature.

Encrypt a Message.

Recall a Message.

Set Up an Out-of-Office Reply.

Manage Messages Using Rules.

Clean Up Folders and Conversations.

Filter Junk E-mail.

Archive E-mails to Create Space.

View Archived E-mails.

Subscribe to RSS Feeds.

Chapter 12: Managing Multiple Priorities with Outlook

Create an Electronic Business Card.

Locate an Address with Map It.

Categorize an Outlook Item.

Send a Calendar Snapshot.

View Two Calendars in Overlay Mode.

Record Journal Entries Automatically.

Delegate a Task.

Chapter 13: Adding Power to Publisher.

Find Templates Online.

Insert a Text File.

Nudge a Text Box.

Move a Page.

Automatically Fit Text.

Control Hyphenation.

Send Your Publication as an E-mail.

Save a Publication for a Commercial Printer.

Chapter 14: Creating Pizzazz with Office Graphics.

Capture a Picture of Your Screen.

Organize Clip Art.

Find More Clip Art Online.

Remove an Image Background.

Assign Artistic Effects to a Picture.

Control Graphic Placement with Ordering.

Group Graphic Objects.

Customize Clip Art with the Ungroup Command.

Add a Caption to a Graphic.

Turn a WordArt Object into a Picture File.

Add a Custom Watermark.

Wrap Text Around a Graphic.

Organize Pictures with Picture Manager.

Index.