You are previewing Office 2010 Visual™ Quick Tips.
O'Reilly logo
Office 2010 Visual™ Quick Tips

Book Description

Get more done in Office 2010 in less time with these Quick Tips!

Whether you're new to Microsoft Office or updating from older versions, this is the perfect resource to get you quickly up to speed on Office 2010. Every application is covered, including Word, Excel, PowerPoint, Outlook, and Publisher. Full-color screenshots and numbered steps clearly explain dozens of features and functions-while quick shortcuts, tips, and tricks help you save time and boost productivity. You'll also find great new ways to access and use some Office apps right from the Web.

  • Walks you through dozens of new features and functions of Microsoft Office 2010

  • Covers Word, Excel, PowerPoint, Outlook, and Publisher

  • Uses straightforward descriptions and explanations, full-color screenshots, and easy-to-follow numbered steps to help you glean what you need, fast

  • Boosts your productivity with shortcuts, tips, and tricks that help you work smarter and faster

Put Office 2010 to work for you in no time with the invaluable quick tips in Office 2010 Visual Quick Tips.

Table of Contents

  1. Copyright
  2. Credits
  3. About the Author
  4. 1. General Office 2010 Maximizing Tips
    1. 1.1. Customize the Quick Access Toolbar
    2. 1.2. Customize the Ribbon
    3. 1.3. Control the Ribbon Display
      1. 1.3.1. Control the Ribbon with the Arrow Button
      2. 1.3.2. Control the Ribbon with the Context Menu
    4. 1.4. Share a Customized Ribbon
    5. 1.5. Preview Paste Options
    6. 1.6. Automate Office Tasks with Macros
    7. 1.7. Change the Default Font and Size
      1. 1.7.1. Change Word's Default Font
      2. 1.7.2. Change Excel's Default Font
    8. 1.8. Organize Notes with OneNote
  5. 2. Timesaving Tips for Office Files
    1. 2.1. Change the Default File Save Location
    2. 2.2. Check Document Compatibility
      1. 2.2.1. Convert a Word File to 2010 Format
      2. 2.2.2. Check for Compatibility
    3. 2.3. Save Office Files as PDF Documents
    4. 2.4. Assign Document Properties
      1. 2.4.1. Open the Document Panel
      2. 2.4.2. Open the Properties Dialog Box
    5. 2.5. Remove Sensitive Document Information
    6. 2.6. Encrypt a Document
    7. 2.7. Add a Digital Signature
    8. 2.8. Control Author Permissions
    9. 2.9. Mark a Document as Final
    10. 2.10. Recover an Unsaved Document
  6. 3. Boosting Your Productivity in Word
    1. 3.1. Add a Header or Footer Building Block
      1. 3.1.1. Create a Header/Footer Building Block
      2. 3.1.2. Apply a Header/Footer Building Block
    2. 3.2. Share Building Blocks with Others
    3. 3.3. Translate Text
      1. 3.3.1. Translate a Word or Phrase
      2. 3.3.2. Translate a Document
    4. 3.4. Create a Blog Post
    5. 3.5. Search Through a Document
      1. 3.5.1. Finding Text
      2. 3.5.2. Finding and Replacing Text
    6. 3.6. Look Up a Synonym or Definition
      1. 3.6.1. Find a Synonym
      2. 3.6.2. Look Up a Word
    7. 3.7. Jump Around Documents with Bookmarks
      1. 3.7.1. Create a Bookmark
      2. 3.7.2. Navigate to a Bookmark
    8. 3.8. Navigate Long Documents with the Navigation Pane
    9. 3.9. Automate Typing with AutoText
    10. 3.10. Fix Misspellings with AutoCorrect
    11. 3.11. Emphasize Text with Drop Caps
    12. 3.12. Set a New Default Line Spacing
    13. 3.13. Quickly Insert a Horizontal Line
    14. 3.14. Resume Numbering in an Interrupted Numbered List
    15. 3.15. Set Off a Paragraph with a Border
      1. 3.15.1. Add a Border
      2. 3.15.2. Format a Border
    16. 3.16. Track Changes in a Document
    17. 3.17. Compare Documents
    18. 3.18. Add Filler Text
    19. 3.19. Keep Words Together with a Nonbreaking Space
    20. 3.20. Summarize Information with a Chart
  7. 4. Utilizing Word's Document Building Tools
    1. 4.1. Create a Bibliography
      1. 4.1.1. Add a Citation
      2. 4.1.2. Generate the Bibliography
    2. 4.2. Insert Footnotes and Endnotes
    3. 4.3. Generate a Table of Contents
      1. 4.3.1. Style Text as Headings
      2. 4.3.2. Generate a Table of Contents
    4. 4.4. Insert a Cover Page
      1. 4.4.1. Add a Cover Page
      2. 4.4.2. Save a Custom Cover Page to the Gallery
    5. 4.5. Generate an Index
      1. 4.5.1. Mark a Word or Phrase for an Index
      2. 4.5.2. Mark a Word or Phrase that Spans a Range of Pages
      3. 4.5.3. Generate the Index
      4. 4.5.4. Update the Index
    6. 4.6. Add a Cross-Reference
    7. 4.7. Add Line Numbers to Your Document
      1. 4.7.1. Add Line Numbers
      2. 4.7.2. Change Numbering Increments
  8. 5. Optimizing Excel
    1. 5.1. Automatically Open Your Favorite Workbook
      1. 5.1.1. Create an Alternate Startup Folder
      2. 5.1.2. Designate a Startup File
    2. 5.2. Automate Data Entry with AutoFill
      1. 5.2.1. AutoFill a Text Series
      2. 5.2.2. AutoFill a Number Series
    3. 5.3. Color-Code and Name Worksheet Tabs
      1. 5.3.1. Color-Code Sheet Tabs
      2. 5.3.2. Name Sheet Tabs
    4. 5.4. Keep Cells in View with a Watch Window
    5. 5.5. Protect Cells from Unauthorized Changes
      1. 5.5.1. Protect Workbook Structure
      2. 5.5.2. Protect Worksheet Elements
    6. 5.6. Generate Random Numbers in Your Cells
    7. 5.7. Freeze Headings for Easier Scrolling
    8. 5.8. Insert a Comment in a Formula
    9. 5.9. Join Text from Separate Cells
    10. 5.10. Add a Calculator to the Quick Access Toolbar
    11. 5.11. Audit a Worksheet for Errors
      1. 5.11.1. Check Errors
      2. 5.11.2. Trace Errors
    12. 5.12. Create Projections
      1. 5.12.1. Determine a Linear Trend
      2. 5.12.2. Determine a Growth Trend
    13. 5.13. Establish What-If Scenarios
    14. 5.14. Set Goals with Goal Seek
    15. 5.15. Define and Solve Problems with Solver
    16. 5.16. Create a Database Table
    17. 5.17. Add and Edit Records Using Data Forms
    18. 5.18. Sort and Filter Records
      1. 5.18.1. Sort with the Sort Dialog Box
      2. 5.18.2. Filter with AutoFilter
    19. 5.19. Restrict Cell Entries with Data-Validation Rules
  9. 6. Polishing Your Spreadsheet Data
    1. 6.1. Apply Workbook Themes
      1. 6.1.1. Apply a Theme
      2. 6.1.2. Save a Theme
    2. 6.2. Change Gridline Color
    3. 6.3. Print Gridlines
    4. 6.4. Add Emphasis with Borders
    5. 6.5. Add a Background Color, Pattern, or Image
      1. 6.5.1. Add a Fill Pattern
      2. 6.5.2. Add a Background Image
    6. 6.6. Color-Code Your Data with Conditional Formatting
    7. 6.7. Customize Your Chart with Chart Objects
    8. 6.8. Reveal Trends with Trendlines
    9. 6.9. Add Sparklines
    10. 6.10. Wrap Text for Easy Reading
    11. 6.11. Change Cell Text Orientation
    12. 6.12. Center-Align Printed Data
    13. 6.13. Center Text Across Columns without Merging Cells
  10. 7. Increasing PowerPoint's Potential
    1. 7.1. Convert a Word Document into a Presentation
    2. 7.2. Organize a Presentation into Sections
    3. 7.3. Send a Presentation to Reviewers
    4. 7.4. Reuse a Slide from Another Presentation
    5. 7.5. Rehearse Timings
    6. 7.6. Record Narration
    7. 7.7. Insert Action Buttons
    8. 7.8. Insert a Hyperlink
    9. 7.9. Add an Equation
    10. 7.10. Create a Self-Running Presentation
    11. 7.11. Write on a Slide During a Presentation
    12. 7.12. Create Speaker Notes
    13. 7.13. Print Handouts
    14. 7.14. Compress Media Files
    15. 7.15. Turn a Presentation into a Video
    16. 7.16. Copy a Presentation to a CD
    17. 7.17. Save a Presentation on SkyDrive
    18. 7.18. Broadcast a Presentation
  11. 8. Enhancing Your Presentations
    1. 8.1. Create a Custom Slide Layout
    2. 8.2. Insert a Custom Slide Master
    3. 8.3. Streamline Your Presentation with Themes
    4. 8.4. Customize a Theme
      1. 8.4.1. Apply a New Color Theme
      2. 8.4.2. Apply a New Font Theme
    5. 8.5. Save a Custom Theme
    6. 8.6. Add a Picture to Your Presentation
      1. 8.6.1. Insert Clip Art
      2. 8.6.2. Insert a Picture
    7. 8.7. Insert a SmartArt Graphic
    8. 8.8. Add Video or Sound to Your Presentation
      1. 8.8.1. Insert a Video Clip
      2. 8.8.2. Insert a Sound Clip
    9. 8.9. Edit a Video
      1. 8.9.1. Trim a Video Clip
      2. 8.9.2. Assign a Video Style
    10. 8.10. Animate Your Slides
    11. 8.11. Create a Photo Album Presentation
  12. 9. Harnessing Access
    1. 9.1. Save Time with Templates
    2. 9.2. Import Data from Excel
    3. 9.3. Collect Data from Outlook
    4. 9.4. Type Less with Default Values
    5. 9.5. Make a Field Required
    6. 9.6. Set a Field Caption
    7. 9.7. Copy a Previous Record
    8. 9.8. Apply Input Masks
    9. 9.9. Set Data Validation Rules
    10. 9.10. Attach Files to Records
    11. 9.11. Insert an OLE Object
    12. 9.12. Save a Filter as a Query
      1. 9.12.1. Save the Filter
      2. 9.12.2. Run the Filter Query
    13. 9.13. Display Summary Statistics
    14. 9.14. View Object Dependencies
    15. 9.15. Document the Database
    16. 9.16. Export a Report to Word
    17. 9.17. Create Mailing Labels
    18. 9.18. Automate Access Tasks with Macros
  13. 10. Customizing Your Database and Forms
    1. 10.1. Assign a Theme to a Form
    2. 10.2. Change a Form's Tab Order
    3. 10.3. Jazz Up Your Forms with Pictures
    4. 10.4. Add a Background to a Report
    5. 10.5. Color-Code Your Data with Conditional Formatting
    6. 10.6. Summarize a Datasheet with a PivotTable
    7. 10.7. Summarize a Datasheet with a PivotChart
  14. 11. Streamlining Outlook Tasks
    1. 11.1. Add Multiple E-mail Accounts
    2. 11.2. Create Your Own Quick Steps
    3. 11.3. Create a Distribution List
    4. 11.4. Customize an E-mail Signature
    5. 11.5. Encrypt a Message
    6. 11.6. Recall a Message
    7. 11.7. Set Up an Out-of-Office Reply
    8. 11.8. Manage Messages Using Rules
    9. 11.9. Clean Up Folders and Conversations
    10. 11.10. Filter Junk E-mail
      1. 11.10.1. Block Messages from a Sender
      2. 11.10.2. Mark a Message as Not Junk
    11. 11.11. Archive E-mails to Create Space
    12. 11.12. View Archived E-mails
      1. 11.12.1. View an Archived Message
      2. 11.12.2. Retrieve an Archived Message
    13. 11.13. Subscribe to RSS Feeds
  15. 12. Managing Multiple Priorities with Outlook
    1. 12.1. Create an Electronic Business Card
    2. 12.2. Locate an Address with Map It
    3. 12.3. Categorize an Outlook Item
    4. 12.4. Create a New Category
    5. 12.5. Assign an Existing Category to an Outlook Item
    6. 12.6. Send a Calendar Snapshot
    7. 12.7. View Two Calendars in Overlay Mode
      1. 12.7.1. Add a New Calendar
      2. 12.7.2. Overlay Two Calendars
    8. 12.8. Record Journal Entries Automatically
    9. 12.9. Delegate a Task
  16. 13. Adding Power to Publisher
    1. 13.1. Find Templates Online
    2. 13.2. Insert a Text File
    3. 13.3. Nudge a Text Box
    4. 13.4. Move a Page
    5. 13.5. Automatically Fit Text
    6. 13.6. Control Hyphenation
      1. 13.6.1. Turn Off Hyphenation
      2. 13.6.2. Turn On Manual Hyphenation
    7. 13.7. Send Your Publication as an E-mail
    8. 13.8. Save a Publication for a Commercial Printer
  17. 14. Creating Pizzazz with Office Graphics
    1. 14.1. Capture a Picture of Your Screen
    2. 14.2. Organize Clip Art
    3. 14.3. Find More Clip Art Online
    4. 14.4. Remove an Image Background
    5. 14.5. Assign Artistic Effects to a Picture
      1. 14.5.1. Assign an Effect
      2. 14.5.2. Customize an Effect
    6. 14.6. Control Graphic Placement with Ordering
    7. 14.7. Group Graphic Objects
      1. 14.7.1. Group Objects
      2. 14.7.2. Ungroup Objects
    8. 14.8. Customize Clip Art with the Ungroup Command
    9. 14.9. Add a Caption to a Graphic
    10. 14.10. Turn a WordArt Object into a Picture File
    11. 14.11. Add a Custom Watermark
    12. 14.12. Wrap Text Around a Graphic
      1. 14.12.1. Apply Text Wrapping
      2. 14.12.2. Apply Custom Wrapping
    13. 14.13. Organize Pictures with Picture Manager