Office 2007 Top 100 Simplified Tips & Tricks

by Shoup, Kate

• ISBN13: 9780470118702
• ISBN10: 0470118709
• Edition: 1st
• Format: Paperback
• Copyright: 2007-12-17
• Publisher: Visual

Summary

You already know Office 2007 basics. Now you're ready to move to the next level, and this book gives you clear, illustrated instructions for 125 tasks that reveal cool secrets, teach timesaving tricks, and explain great tips guaranteed to make you more productive with Office 2007. With minimal text and maximum illustrations, a task-oriented, step-by-step approach, self-contained, two-page lessons for each task, and navigational aids that connect the instructions to their illustrations, it's a no-nonsense way to advance your Office skills.

Author Biography

Kate Shoup has written more than a dozen books, including The Agassi Story, iPhone VISUAL Quick Tips, Windows Vista VISUAL Encyclopedia, Webster’s New World English Grammar Handbook, and more. She has also co-written a screenplay, and worked as the Sports Editor for NUVO Newsweekly. When not writing, Kate loves to ski (she was once nationally ranked), ride her motorcycle, and play video poker — and she plays a mean game of 9-ball. Kate lives in Indianapolis with her daughter and their dog.

Table of Contents

Maximize the Power of Office 2007

Make a Document Backward Compatible

Save Office Documents as Web Pages

Automate Office Tasks with Macros

Set Document Properties

Remove Sensitive Information from Your Document

Encrypt a Document

Digitally Sign a Document

Mark a Document as Final

Enable Smart Tags

Customize the Quick Access Toolbar

Customize the Ribbon

Change the Save Settings

Boost Word's Potential

Add a Header/Footer Building Block to the Gallery

Share Building Blocks with Others

Work with the Document Map

Scan Document Content with Thumbnails

Track Changes in a Document

Compare Documents

Translate Text

Use Word's Thesaurus and Dictionary

Create a Blog Post

Jazz Up Your Work with Word

Create a Bibliography

Insert Footnotes and Endnotes

Generate a Table of Contents

Insert a Cover Page

Generate an Index

Add a Cross-Reference

Emphasize Text with Drop Caps

Summarize Information with a Chart

Add a Watermark

Wrap Text Around a Graphic

Add Line Numbers to Your Document

Optimize Excel

Automate Data Entry with AutoFill

Create Projections

Insert a Comment

Track and Review Workbook Changes

Calculate Using Formulas

Speed Up Your Calculations with Functions

Audit a Worksheet for Errors

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

Set Data-Validation Rules

Password-Protect Your Work

Unleash Your Inner Spreadsheet

Apply Workbook Themes

Add Emphasis with Borders

Add a Background Color, Pattern, or Image

Color-Code Your Data with Conditional Formatting

Chart Your Data

Customize Your Chart with Chart Objects

Reveal Trends with Trendlines

Align Cell Data

Wrap Text for Easy Reading

Set Print Preferences

Explore the Possibilities with PowerPoint

Convert a Word Document into a Presentation

Send a Presentation to Reviewers

Reuse a Slide from Another Presentation

Rehearse Timing

Record Narration

Insert Action Buttons

Insert a Hyperlink

Create a Self-Running Presentation

Write on a Slide During a Presentation

Create Speaker Notes

Print Handouts

Copy a Presentation to CD

Publish a Web Presentation

Express Yourself through Presentations

Choose a Slide Layout

Create a Custom Slide Layout

Insert a Custom Slide Master

Streamline Your Presentation with Themes

Customize a Theme

Save Your Own Theme

Add a Picture to Your Presentation

Insert a SmartArt Graphic

Add Video or Sound to Your Presentation

Animate Your Slides

Create a Photo Album Presentation

Table of Contents provided by Publisher. All Rights Reserved.