Office 2010 Visual™ Quick Tips -- Table of Contents -- Chapter 1: 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.