Office 2007

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.

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.