Office 2010 Visual Quick Tips

Sherry Kinkoph Gunter has written and edited oodles of books over the past 18 years covering a wide variety of computer topics, including Microsoft Office programs, digital photography, and Web applications. Her recent titles include Teach Yourself VISUALLY Office 2007 , Microsoft Office 2008 for Mac Bible , and Master VISUALLY Dreamweaver CS3 and Flash CS3 Professional . Sherry began writing computer books back in 1992, and her flexible writing style has allowed her to author for a varied assortment of imprints and formats. Sherry's ongoing quest is to aid users of all levels in the mastering of ever-changing computer technologies, helping users make sense of it all and get the most out of their machines and online experiences. Sherry currently resides in a swamp in the wilds of east central Indiana with a lovable ogre and a menagerie of interesting creatures.

Chapter1: General Office 2010 Maximizing Tips. Customize the Quick Access Toolbar. Customize the Ribbon. Control the Ribbon Display. Share a Customized Ribbon. Preview Paste Options. Automate Office Tasks with Macros. Change the Default Font and Size. Organize Notes with OneNote. Chapter 2: Timesaving Tips for Office Files. Change the Default File Save Location. Check Document Compatibility. Save Office Files as PDF Documents. Assign Document Properties. Remove Sensitive Document Information. Encrypt a Document. Add a Digital Signature. Control Author Permissions. Mark a Document as Final. Recover an Unsaved Document. Chapter 3: Boosting Your Productivity in Word. Add a Header or Footer Building Block. Share Building Blocks with Others. Translate Text. Create a Blog Post. Search Through a Document. Look Up a Synonym or Definition. Jump Around Documents with Bookmarks. Navigate Long Documents with the Navigation Pane. Automate Typing with AutoText. Fix Misspellings with AutoCorrect. Emphasize Text with Drop Caps. Set a New Default Line Spacing. Quickly Insert a Horizontal Line. Resume Numbering in an Interrupted Numbered List. Set Off a Paragraph with a Border. Track Changes in a Document. Compare Documents. Add Filler Text. Keep Words Together with a Nonbreaking Space. Summarize Information with a Chart. Chapter 4: Utilizing Word's Document Building Tools. Create a Bibliography. Insert Footnotes and Endnotes. Generate a Table of Contents. Insert a Cover Page. Generate an Index. Add a Cross-Reference. Add Line Numbers to Your Document. Chapter 5: Optimizing Excel. Automatically Open Your Favorite Workbook. Automate Data Entry with AutoFill. Color-Code and Name Worksheet Tabs. Keep Cells in View with a Watch Window. Protect Cells from Unauthorized Changes. Generate Random Numbers in Your Cells. Freeze Headings for Easier Scrolling. Insert a Comment in a Formula. Join Text from Separate Cells. Add a Calculator to the Quick Access Toolbar. Audit a Worksheet for Errors. Create Projections. 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. Restrict Cell Entries with Data-Validation Rules. Chapter 6: Polishing Your Spreadsheet Data Apply Workbook Themes. Change Gridline Color. Print Gridlines. Add Emphasis with Borders. Add a Background Color, Pattern, or Image. Color-Code Your Data with Conditional Formatting. Customize Your Chart with Chart Objects. Reveal Trends with Trendlines. Add Sparklines. Wrap Text for Easy Reading. Change Cell Text Orientation. Center-Align Printed Data. Center Text Across Columns without Merging Cells. Chapter 7: Increasing PowerPoint's Potential. Convert a Word Document into a Presentation. Organize a Presentation into Sections. Send a Presentation to Reviewers. Reuse a Slide from Another Presentation. Rehearse Timings. Record Narration. Insert Action Buttons. Insert a Hyperlink. Add an Equation. Create a Self-Running Presentation. Write on a Slide During a Presentation. Create Speaker Notes. Print Handouts. Compress Media Files. Turn a Presentation into a Video. Copy a Presentation to a CD. Save a Presentation on SkyDrive. Broadcast a Presentation. Chapter 8: Enhancing Your Presentations. Create a Custom Slide Layout. Insert a Custom Slide Master. Streamline Your Presentation with Themes. Customize a Theme. Save a Custom Theme. Add a Picture to Your Presentation. Insert a SmartArt Graphic. Add Video or Sound to Your Presentation. Edit a Video. Animate Your Slides. Create a Photo Album Presentation. Chapter 9: Harnessing Access. Save Time with Templates. Import Data from Excel. Collect Data from Outlook. Type Less with Default Values. Make a Field Required. Set a Field Caption. Copy a Previous Record. Apply Input Masks. Set Data Validation Rules. Attach Files to Records. Insert an OLE Object. Save a Filter as a Query. Display Summary Statistics. View Object Dependencies. Document the Database. Export a Report to Word. Create Mailing Labels. Automate Access Tasks with Macros. Chapter 10: Customizing Your Database and Forms. Assign a Theme to a Form. Change a Form's Tab Order. Jazz Up Your Forms with Pictures. Add a Background to a Report. Color-Code Your Data with Conditional Formatting. Summarize a Datasheet with a PivotTable. Summarize a Datasheet with a PivotChart. Chapter 11: Streamlining Outlook Tasks. Add Multiple E-mail Accounts. Create Your Own Quick Steps. Create a Distribution List. Customize an E-mail Signature. Encrypt a Message. Recall a Message. Set Up an Out-of-Office Reply. Manage Messages Using Rules. Clean Up Folders and Conversations. Filter Junk E-mail. Archive E-mails to Create Space. View Archived E-mails. Subscribe to RSS Feeds. Chapter 12: Managing Multiple Priorities with Outlook Create an Electronic Business Card. Locate an Address with Map It. Categorize an Outlook Item. Send a Calendar Snapshot. View Two Calendars in Overlay Mode. Record Journal Entries Automatically. Delegate a Task. Chapter 13: Adding Power to Publisher. Find Templates Online. Insert a Text File. Nudge a Text Box. Move a Page. Automatically Fit Text. Control Hyphenation. Send Your Publication as an E-mail. Save a Publication for a Commercial Printer. Chapter 14: Creating Pizzazz with Office Graphics. Capture a Picture of Your Screen. Organize Clip Art. Find More Clip Art Online. Remove an Image Background. Assign Artistic Effects to a Picture. Control Graphic Placement with Ordering. Group Graphic Objects. Customize Clip Art with the Ungroup Command. Add a Caption to a Graphic. Turn a WordArt Object into a Picture File. Add a Custom Watermark. Wrap Text Around a Graphic. Organize Pictures with Picture Manager. Index.