Gift Guide

Office 2007 Visual Quick Tips


  • Readers get more bang for their buck! At just $12.99, this easy-to-use, full-color guide provides secrets, tips, and techniques to becoming efficient with Word, Excel, Access, Outlook, and PowerPoint
  • Offers straightforward task descriptions and full-color screen shots with step-by-step instructions that show how to increase productivity with Office 2007
  • Helps readers to get down to work and get more done in ...
See more details below
Other sellers (Paperback)
  • All (33) from $1.99   
  • New (12) from $6.46   
  • Used (21) from $1.99   
Sending request ...


  • Readers get more bang for their buck! At just $12.99, this easy-to-use, full-color guide provides secrets, tips, and techniques to becoming efficient with Word, Excel, Access, Outlook, and PowerPoint
  • Offers straightforward task descriptions and full-color screen shots with step-by-step instructions that show how to increase productivity with Office 2007
  • Helps readers to get down to work and get more done in less time
  • Addresses new Office 2007 features, including how to improve database productivity in Access, create dynamic PowerPoint presentations, and use new tools for image editing and research
Read More Show Less

Product Details

  • ISBN-13: 9780470089729
  • Publisher: Wiley
  • Publication date: 11/13/2006
  • Series: Visual Quick Tips Series
  • Pages: 212
  • Sales rank: 839,977
  • Product dimensions: 6.60 (w) x 7.12 (h) x 0.43 (d)

Meet the Author

Paul McFedries ( Toronto, Ontario) is the president of Logophilia Limited, a technical writing company. He has been programming since he was a teenager in the mid-1970s, has programmed everything from mainframes to desktops to bar code scanners, and has worked with many different languages, including Fortran, assembly language, C++, and, of course, JavaScript. Paul has written more than three dozen books that have sold more than two million copies worldwide. These books include Teach Yourself VISUALLY Windows XP, 2nd Edition, Excel PivotTables and PivotCharts: Your visual blueprint, VBA for Office 2000 Unleashed, Windows XP Simplified, 2nd Edition, and The Complete Idiot's Guide to Creating a Web Page. Paul encourages all readers to drop by his Web site,

Read More Show Less

Table of Contents

Chapter 1: Lighten Your Workload with General Office Techniques.

Shorten the AutoRecover Interval.

Learn Shortcut Keys Faster.

Customize the Quick Access Toolbar.

Embed TrueType Fonts While Saving.

Preview a Document Before Opening It.

Customize the Places Bar.

Manage Computer Files from Any Office Program.

Store Files in a Different Default Location.

Make Documents Private.

Save a Document as an XPS File.

Turn Scanned Documents into Text.

Diagnose Office Problems.

Customize Clip Art with the Ungroup Command.

Position Clip Art Using Text Boxes.

Chapter 2: Timesaving Tips for Word.

Utilize Status Bar Shortcuts.

Register a Blog Account.

Post a Blog Entry.

Remove a File from the Recent Documents List.

Conserve Paper When Printing with the Zoom Options.

Navigate Long Documents Using a Table of Contents.

Navigate Long Documents Using Bookmarks.

Compare Two Documents Side by Side.

Using AutoText to Automate Repetitive Typing.

Keep Words Together with a Non-Breaking Space.

Control Sentence Spacing.

Using the Research Pane to Translate Text.

Add Line Numbers in the Document Margin.

Set Off a Paragraph with a Border.

Resume Numbering in an Interrupted Numbered List.

Insert Quick Horizontal Lines.

Emphasize Paragraphs with Drop Caps.

Customize Comment Text.

Add Captions to Your Graphics.

Insert a Table from the Keyboard.

Keep Table Column Headings in Sight.

Place a Table Within a Table.

Align Shapes with Gridlines.

Add Gradient Fills to Text Boxes.

Create a Watermark.

Chapter 3: Increase the Power of Your Spreadsheet with Excel.

Automatically Open Your Favorite Workbook.

Increase the Size of the Recent Documents List.

Set a New Default Font and Size.

Change the Gridline Color.

Increase Readability by Printing Gridlines.

Center Align Printed Data.

Print Formulas Instead of Formula Results.

Organize Worksheets by Color-Coding Tabs.

Label Rows and Columns in R1C1 Style.

Keep Cells in View with a Watch Window.

Protect Cells from Unauthorized Changes.

Freeze Headings for Easier Scrolling.

Wrap Text in Worksheet Cells.

Add Visual Interest with Slanted Text.

Magnify a Selection of Cells.

Add Pizzazz with a Background Picture.

Center Text Across Columns Without Merging Cells.

Add Comments to Formulas.

Turn Excel Data into a Pasteable Picture.

Analyze Data with Conditional Formatting Graphics.

Generate Random Numbers in Your Cells.

Prevent Excel from Converting Fractions.

Retrieve a Stock Quote.

Count the Number of Days Between Two Dates.

Join Text from Separate Cells.

Copy Page Setup Settings from One Worksheet to Another.

Find Data on Multiple Sheets with VLookup.

Chapter 4: Enhance Your PowerPoint Presentations.

Turn a Word Outline into a PowerPoint Presentation.

Convert a Slide into an Image.

Repeatedly Draw the Same Shape.

Create Evenly Spaced Duplicate Shapes.

Add Connector Lines to Objects.

Save File Size by Compressing Pictures.

Create Better-Looking Shadowed Text.

Turn a Photo into a Slide Background.

Create a Custom Color Theme.

Enhance Presentations with Movies.

Create Scrolling Credits.

Launch a Mini Slide Show Window.

Make Your Slide Show Start Automatically.

Create a Custom Slide Theme.

Chapter 5: Customize and Optimize Outlook.

Send Message Replies to Another Recipient.

Customize a Personal Distribution List.

Create a Custom Signature.

Clean a Mailbox of Space-Stealing Files.

Print a Master Copy of an Address Book.

Insert a Contact Address on an Envelope or Label.

Display a Map to an Outlook Contact.

View a Calendar with Nonconsecutive Dates.

Display Two Time Zones.

Chapter 6: Improve Your Database Productivity Using Access.

Personalize a Database with a Custom Splash Screen.

Customize the Database Title and Icon.

Make a Database Window Work Like a Web Browser.

Zoom Entries for Easy Editing.

Make Form Values Stand Out with Conditional Formatting.

Automatically Open a Form at Startup.

Change a Form’s Tab Order.

Make a Form Interesting by Adding a Picture.

Automatically Open a Specific Record.

Set Up Forms to Close Automatically.

Add Ampersands to Caption Labels.

Save Time with Default Table Values.

Move Automatically to the End of a Field.

Copy a Previous Record into a New Record.

Print a Table Relationships Map.

Using the Navigation Pane to Append Records.

Optimize Performance by Reducing Database Size.

Using Input Masks to Control Users’ Table Data Entry.

Force Page Breaks after Report Sections.

Avoid Widowed Data in a Report Section.

Export Data to a Web Page.

Appendix: Office Shortcuts.


Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)