You are previewing Office 2007: Top 100 Simplified® Tips & Tricks.
O'Reilly logo
Office 2007: Top 100 Simplified® Tips & Tricks

Book Description

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. Copyright
  2. Praise for Visual Books
  3. Credits
  4. About the Author
  5. How To Use This Book
  6. 1. Maximize the Power of Office 2007
    1. 1.1. Make a document BACKWARD COMPATIBLE
    2. 1.2. Save Office documents as WEB PAGES
    3. 1.3. Automate Office tasks with MACROS
    4. 1.4. Set DOCUMENT PROPERTIES
    5. 1.5. REMOVE SENSITIVE INFORMATION from your document
    6. 1.6. ENCRYPT a document
    7. 1.7. DIGITALLY SIGN a document
    8. 1.8. Mark a document as FINAL
    9. 1.9. Enable SMART TAGS
    10. 1.10. Customize the QUICK ACCESS TOOLBAR
    11. 1.11. Customize the RIBBON
    12. 1.12. Change the SAVE SETTINGS
  7. 2. Boost Word's Potential
    1. 2.1. Add a HEADER/FOOTER BUILDING BLOCK to the gallery
    2. 2.2. SHARE BUILDING BLOCKS with others
    3. 2.3. Work with the DOCUMENT MAP
    4. 2.4. Scan document content with THUMBNAILS
    5. 2.5. TRACK CHANGES in a document
    6. 2.6. COMPARE DOCUMENTS
    7. 2.7. TRANSLATE TEXT
    8. 2.8. Use Word's THESAURUS AND DICTIONARY
    9. 2.9. Create a BLOG POST
  8. 3. Jazz Up Your Work with Word
    1. 3.1. Create a BIBLIOGRAPHY
    2. 3.2. Insert FOOTNOTES AND ENDNOTES
    3. 3.3. Generate a TABLE OF CONTENTS
    4. 3.4. Insert a COVER PAGE
    5. 3.5. Generate an INDEX
    6. 3.6. Generate an INDEX
    7. 3.7. Add a CROSS-REFERENCE
    8. 3.8. Emphasize text with DROP CAPS
    9. 3.9. Summarize information WITH A CHART
    10. 3.10. Add a WATERMARK
    11. 3.11. WRAP TEXT around a graphic
    12. 3.12. ADD LINE NUMBERS to your document
  9. 4. Optimize Excel
    1. 4.1. AUTOMATE DATA ENTRY with AutoFill
    2. 4.2. Create PROJECTIONS
    3. 4.3. INSERT a comment
    4. 4.4. TRACK AND REVIEW workbook changes
    5. 4.5. CALCULATE using formulas
    6. 4.6. SPEED UP YOUR CALCULATIONS with functions
    7. 4.7. AUDIT A WORKSHEET for errors
    8. 4.8. Establish WHAT-IF SCENARIOS
    9. 4.9. Set goals with GOAL SEEK
    10. 4.10. Define and solve problems with SOLVER
    11. 4.11. Create a DATABASE TABLE
    12. 4.12. ADD AND EDIT RECORDS using data forms
    13. 4.13. SORT AND FILTER records
    14. 4.14. Set DATA-VALIDATION RULES
    15. 4.15. PASSWORD-PROTECT your work
  10. 5. Unleash Your Inner Spreadsheet
    1. 5.1. Apply WORKBOOK THEMES
    2. 5.2. Add emphasis with BORDERS
    3. 5.3. Add a background COLOR, PATTERN, OR IMAGE
    4. 5.4. Color-code your data with CONDITIONAL FORMATTING
    5. 5.5. CHART your data
    6. 5.6. Customize your chart with CHART OBJECTS
    7. 5.7. Reveal trends with TRENDLINES
    8. 5.8. Align CELL DATA
    9. 5.9. WRAP TEXT for easy reading
    10. 5.10. Set PRINT PREFERENCES
  11. 6. Explore the Possibilities with PowerPoint
    1. 6.1. CONVERT A WORD DOCUMENT into a presentation
    2. 6.2. SEND A PRESENTATION to reviewers
    3. 6.3. REUSE A SLIDE from another presentation
    4. 6.4. Rehearse TIMING
    5. 6.5. Record NARRATION
    6. 6.6. Insert ACTION BUTTONS
    7. 6.7. Insert a HYPERLINK
    8. 6.8. Create a SELF-RUNNING PRESENTATION
    9. 6.9. WRITE ON A SLIDE during a presentation
    10. 6.10. Create SPEAKER NOTES
    11. 6.11. Print HANDOUTS
    12. 6.12. COPY A PRESENTATION to CD
    13. 6.13. PUBLISH a Web presentation
  12. 7. Express Yourself Through Presentations
    1. 7.1. Choose a SLIDE LAYOUT
    2. 7.2. Create a CUSTOM SLIDE LAYOUT
    3. 7.3. Insert a CUSTOM SLIDE MASTER
    4. 7.4. Streamline your presentation with THEMES
    5. 7.5. CUSTOMIZE a theme
    6. 7.6. SAVE your own theme
    7. 7.7. Add A PICTURE to your presentation
    8. 7.8. Insert a SMARTART GRAPHIC
    9. 7.9. ADD VIDEO OR SOUND to your presentation
    10. 7.10. ANIMATE your slides
    11. 7.11. Create a PHOTO ALBUM PRESENTATION
  13. 8. Make Your Data Work for You with Access
    1. 8.1. Save time with TEMPLATES
    2. 8.2. Import data from EXCEL
    3. 8.3. Import data from EXCEL
    4. 8.4. COLLECT DATA with Outlook
    5. 8.5. COLLECT DATA with Outlook
    6. 8.6. IMPORT CONTACTS from Outlook
    7. 8.7. TYPE LESS with default values
    8. 8.8. Make a FIELD REQUIRED
    9. 8.9. Set a FIELD CAPTION
    10. 8.10. Apply INPUT MASKS
    11. 8.11. Set DATA-VALIDATION RULES
    12. 8.12. ATTACH FILES to records
    13. 8.13. Insert an OLE OBJECT
    14. 8.14. SAVE A FILTER as a query
    15. 8.15. Display SUMMARY STATISTICS
    16. 8.16. View OBJECT DEPENDENCIES
    17. 8.17. DOCUMENT the database
    18. 8.18. EXPORT A REPORT to Word
    19. 8.19. Create MAILING LABELS
    20. 8.20. Automate Access tasks with MACROS
  14. 9. Customize Your Database and Forms
    1. 9.1. AUTO-FORMAT a form
    2. 9.2. Change a form's TAB ORDER
    3. 9.3. AUTO-FORMAT a report
    4. 9.4. Save your report as a WEB PAGE
    5. 9.5. Jazz up your forms with PICTURES
    6. 9.6. Color-code your data with CONDITIONAL FORMATTING
    7. 9.7. Summarize a datasheet with a PIVOTTABLE
    8. 9.8. Summarize a datasheet with a PIVOTCHART
  15. 10. Tap Outlook's Inner Power Through E-mail
    1. 10.1. Create a DISTRIBUTION LIST
    2. 10.2. Customize an E-MAIL SIGNATURE
    3. 10.3. ENCRYPT a message
    4. 10.4. RECALL a message
    5. 10.5. Set up an OUT-OF-OFFICE REPLY
    6. 10.6. MANAGE MESSAGES using rules
    7. 10.7. FILTER JUNK e-mail
    8. 10.8. ARCHIVE E-MAILS to create space
    9. 10.9. View ARCHIVED E-MAILS
    10. 10.10. Subscribe to RSS FEEDS
  16. 11. Manage Multiple Priorities with Outlook
    1. 11.1. Create an ELECTRONIC BUSINESS CARD
    2. 11.2. Locate an address with CONTACT MAPS
    3. 11.3. CATEGORIZE an Outlook item
    4. 11.4. Forward Outlook information to your MOBILE PHONE
    5. 11.5. Send a CALENDAR SNAPSHOT
    6. 11.6. View calendars in OVERLAY MODE
    7. 11.7. RECORD JOURNAL ENTRIES automatically
    8. 11.8. DELEGATE a task