Microsoft Office 2007: Top 100 Simplified Tips & Tricks

Overview

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 ...

See more details below
Other sellers (Paperback)
  • All (21) from $1.99   
  • New (6) from $8.49   
  • Used (15) from $1.99   
Sending request ...

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780470118702
  • Publisher: Wiley
  • Publication date: 12/26/2007
  • Series: Top 100 Simplified Tips & Tricks Series , #3
  • Edition number: 1
  • Pages: 257
  • Sales rank: 1,014,965
  • Product dimensions: 8.50 (w) x 10.00 (h) x 0.68 (d)

Meet the Author

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.

Read More Show Less

Table of Contents

1 Maximize the Power of Office 2007.

#1 Make a Document Backward Compatible.

#2 Save Office Documents as Web Pages.

#3 Automate Office Tasks with Macros.

#4 Set Document Properties.

#5 Remove Sensitive Information from Your Document.

#6 Encrypt a Document.

#7 Digitally Sign a Document.

#8 Mark a Document as Final.

#9 Enable Smart Tags.

#10 Customize the Quick Access Toolbar.

#11 Customize the Ribbon.

#12 Change the Save Settings.

2 Boost Word’s Potential.

#13 Add a Header/Footer Building Block to the Gallery.

#14 Share Building Blocks with Others.

#15 Work with the Document Map.

#16 Scan Document Content with Thumbnails.

#17 Track Changes in a Document.

#18 Compare Documents.

#19 Translate Text.

#20 Use Word’s Thesaurus and Dictionary.

#21 Create a Blog Post.

3 Jazz Up Your Work with Word.

#22 Create a Bibliography.

#23 Insert Footnotes and Endnotes.

#24 Generate a Table of Contents.

#25 Insert a Cover Page.

#26 Generate an Index.

#27 Add a Cross-Reference.

#28 Emphasize Text with Drop Caps.

#29 Summarize Information with a Chart.

#30 Add a Watermark.

#31 Wrap Text Around a Graphic.

#32 Add Line Numbers to Your Document.

4 Optimize Excel.

#33 Automate Data Entry with AutoFill.

#34 Create Projections.

#35 Insert a Comment.

#36 Track and Review Workbook Changes.

#37 Calculate Using Formulas.

#38 Speed Up Your Calculations with Functions.

#39 Audit a Worksheet for Errors.

#40 Establish What-If Scenarios.

#41 Set Goals with Goal Seek.

#42 Define and Solve Problems with Solver.

#43 Create a Database Table.

#44 Add and Edit Records Using Data Forms.

#45 Sort and Filter Records.

#46 Set Data-Validation Rules.

#47 Password-Protect Your Work.

5 Unleash Your Inner Spreadsheet.

#48 Apply Workbook Themes.

#49 Add Emphasis with Borders.

#50 Add a Background Color, Pattern, or Image.

#51 Color-Code Your Data with Conditional Formatting.

#52 Chart Your Data.

#53 Customize Your Chart with Chart Objects.

#54 Reveal Trends with Trendlines.

#55 Align Cell Data.

#56 Wrap Text for Easy Reading.

#57 Set Print Preferences.

6 Explore the Possibilities with PowerPoint.

#58 Convert a Word Document into a Presentation.

#59 Send a Presentation to Reviewers.

#60 Reuse a Slide from Another Presentation.

#61 Rehearse Timing.

#62 Record Narration.

#63 Insert Action Buttons.

#64 Insert a Hyperlink.

#65 Create a Self-Running Presentation.

#66 Write on a Slide During a Presentation.

#67 Create Speaker Notes.

#68 Print Handouts.

#69 Copy a Presentation to CD.

#70 Publish a Web Presentation.

7 Express Yourself through Presentations.

#71 Choose a Slide Layout.

#72 Create a Custom Slide Layout.

#73 Insert a Custom Slide Master.

#74 Streamline Your Presentation with Themes.

#75 Customize a Theme.

#76 Save Your Own Theme.

#77 Add a Picture to Your Presentation.

#78 Insert a SmartArt Graphic.

#79 Add Video or Sound to Your Presentation.

#80 Animate Your Slides.

#81 Create a Photo Album Presentation.

8 Make Your Data Work for You with Access.

#82 Save Time with Templates.

#83 Import Data from Excel.

#84 Collect Data with Outlook.

#85 Import Contacts from Outlook.

#86 Type Less with Default Values.

#87 Make a Field Required.

#88 Set a Field Caption.

#89 Apply Input Masks.

#90 Set Data-Validation Rules.

#91 Attach Files to Records.

#92 Insert an OLE Object.

#93 Save a Filter as a Query.

#94 Display Summary Statistics.

#95 View Object Dependencies.

#96 Document the Database.

#97 Export a Report to Word.

#98 Create Mailing Labels.

#99 Automate Access Tasks with Macros.

9 Customize Your Database and Forms.

#100 Auto-Format a Form.

#101 Change a Form’s Tab Order.

#102 Auto-Format a Report.

#103 Save Your Report as a Web Page.

#104 Jazz Up Your Forms with Pictures.

#105 Color-Code Your Data with Conditional Formatting.

#106 Summarize a Datasheet with a PivotTable.

#107 Summarize a Datasheet with a PivotChart.

10 Tap Outlook’s Inner Power through E-mail.

#108 Create a Distribution List.

#109 Customize an E-mail Signature.

#110 Encrypt a Message.

#111 Recall a Message.

#112 Set Up an Out-of-Office Reply.

#113 Manage Messages Using Rules.

#114 Filter Junk E-mail.

#115 Archive E-mails to Create Space.

#116 View Archived E-mails.

#117 Subscribe to RSS Feeds.

11 Manage Multiple Priorities with Outlook.

#118 Create an Electronic Business Card.

#119 Locate an Address with Contact Maps.

#120 Categorize an Outlook Item.

#121 Forward Outlook Information to Your Mobile Phone.

#122 Send a Calendar Snapshot.

#123 View Calendars in Overlay Mode.

#124 Record Journal Entries Automatically.

#125 Delegate a Task.

Read More Show Less

Customer Reviews

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

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com 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 & Noble.com 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 & Noble.com 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 BN.com 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

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com 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 BN.com. 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)