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.

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.