- Copyright
- Credits
- About the Author
- 1. General Office 2010 Maximizing Tips
- 2. Timesaving Tips for Office Files
- 2.1. Change the Default File Save Location
- 2.2. Check Document Compatibility
- 2.3. Save Office Files as PDF Documents
- 2.4. Assign Document Properties
- 2.5. Remove Sensitive Document Information
- 2.6. Encrypt a Document
- 2.7. Add a Digital Signature
- 2.8. Control Author Permissions
- 2.9. Mark a Document as Final
- 2.10. Recover an Unsaved Document
- 3. Boosting Your Productivity in Word
- 3.1. Add a Header or Footer Building Block
- 3.2. Share Building Blocks with Others
- 3.3. Translate Text
- 3.4. Create a Blog Post
- 3.5. Search Through a Document
- 3.6. Look Up a Synonym or Definition
- 3.7. Jump Around Documents with Bookmarks
- 3.8. Navigate Long Documents with the Navigation Pane
- 3.9. Automate Typing with AutoText
- 3.10. Fix Misspellings with AutoCorrect
- 3.11. Emphasize Text with Drop Caps
- 3.12. Set a New Default Line Spacing
- 3.13. Quickly Insert a Horizontal Line
- 3.14. Resume Numbering in an Interrupted Numbered List
- 3.15. Set Off a Paragraph with a Border
- 3.16. Track Changes in a Document
- 3.17. Compare Documents
- 3.18. Add Filler Text
- 3.19. Keep Words Together with a Nonbreaking Space
- 3.20. Summarize Information with a Chart
- 4. Utilizing Word's Document Building Tools
- 5. Optimizing Excel
- 5.1. Automatically Open Your Favorite Workbook
- 5.2. Automate Data Entry with AutoFill
- 5.3. Color-Code and Name Worksheet Tabs
- 5.4. Keep Cells in View with a Watch Window
- 5.5. Protect Cells from Unauthorized Changes
- 5.6. Generate Random Numbers in Your Cells
- 5.7. Freeze Headings for Easier Scrolling
- 5.8. Insert a Comment in a Formula
- 5.9. Join Text from Separate Cells
- 5.10. Add a Calculator to the Quick Access Toolbar
- 5.11. Audit a Worksheet for Errors
- 5.12. Create Projections
- 5.13. Establish What-If Scenarios
- 5.14. Set Goals with Goal Seek
- 5.15. Define and Solve Problems with Solver
- 5.16. Create a Database Table
- 5.17. Add and Edit Records Using Data Forms
- 5.18. Sort and Filter Records
- 5.19. Restrict Cell Entries with Data-Validation Rules
- 6. Polishing Your Spreadsheet Data
- 6.1. Apply Workbook Themes
- 6.2. Change Gridline Color
- 6.3. Print Gridlines
- 6.4. Add Emphasis with Borders
- 6.5. Add a Background Color, Pattern, or Image
- 6.6. Color-Code Your Data with Conditional Formatting
- 6.7. Customize Your Chart with Chart Objects
- 6.8. Reveal Trends with Trendlines
- 6.9. Add Sparklines
- 6.10. Wrap Text for Easy Reading
- 6.11. Change Cell Text Orientation
- 6.12. Center-Align Printed Data
- 6.13. Center Text Across Columns without Merging Cells
- 7. Increasing PowerPoint's Potential
- 7.1. Convert a Word Document into a Presentation
- 7.2. Organize a Presentation into Sections
- 7.3. Send a Presentation to Reviewers
- 7.4. Reuse a Slide from Another Presentation
- 7.5. Rehearse Timings
- 7.6. Record Narration
- 7.7. Insert Action Buttons
- 7.8. Insert a Hyperlink
- 7.9. Add an Equation
- 7.10. Create a Self-Running Presentation
- 7.11. Write on a Slide During a Presentation
- 7.12. Create Speaker Notes
- 7.13. Print Handouts
- 7.14. Compress Media Files
- 7.15. Turn a Presentation into a Video
- 7.16. Copy a Presentation to a CD
- 7.17. Save a Presentation on SkyDrive
- 7.18. Broadcast a Presentation
- 8. Enhancing Your Presentations
- 8.1. Create a Custom Slide Layout
- 8.2. Insert a Custom Slide Master
- 8.3. Streamline Your Presentation with Themes
- 8.4. Customize a Theme
- 8.5. Save a Custom Theme
- 8.6. Add a Picture to Your Presentation
- 8.7. Insert a SmartArt Graphic
- 8.8. Add Video or Sound to Your Presentation
- 8.9. Edit a Video
- 8.10. Animate Your Slides
- 8.11. Create a Photo Album Presentation
- 9. Harnessing Access
- 9.1. Save Time with Templates
- 9.2. Import Data from Excel
- 9.3. Collect Data from Outlook
- 9.4. Type Less with Default Values
- 9.5. Make a Field Required
- 9.6. Set a Field Caption
- 9.7. Copy a Previous Record
- 9.8. Apply Input Masks
- 9.9. Set Data Validation Rules
- 9.10. Attach Files to Records
- 9.11. Insert an OLE Object
- 9.12. Save a Filter as a Query
- 9.13. Display Summary Statistics
- 9.14. View Object Dependencies
- 9.15. Document the Database
- 9.16. Export a Report to Word
- 9.17. Create Mailing Labels
- 9.18. Automate Access Tasks with Macros
- 10. Customizing Your Database and Forms
- 11. Streamlining Outlook Tasks
- 11.1. Add Multiple E-mail Accounts
- 11.2. Create Your Own Quick Steps
- 11.3. Create a Distribution List
- 11.4. Customize an E-mail Signature
- 11.5. Encrypt a Message
- 11.6. Recall a Message
- 11.7. Set Up an Out-of-Office Reply
- 11.8. Manage Messages Using Rules
- 11.9. Clean Up Folders and Conversations
- 11.10. Filter Junk E-mail
- 11.11. Archive E-mails to Create Space
- 11.12. View Archived E-mails
- 11.13. Subscribe to RSS Feeds
- 12. Managing Multiple Priorities with Outlook
- 12.1. Create an Electronic Business Card
- 12.2. Locate an Address with Map It
- 12.3. Categorize an Outlook Item
- 12.4. Create a New Category
- 12.5. Assign an Existing Category to an Outlook Item
- 12.6. Send a Calendar Snapshot
- 12.7. View Two Calendars in Overlay Mode
- 12.8. Record Journal Entries Automatically
- 12.9. Delegate a Task
- 13. Adding Power to Publisher
- 14. Creating Pizzazz with Office Graphics
- 14.1. Capture a Picture of Your Screen
- 14.2. Organize Clip Art
- 14.3. Find More Clip Art Online
- 14.4. Remove an Image Background
- 14.5. Assign Artistic Effects to a Picture
- 14.6. Control Graphic Placement with Ordering
- 14.7. Group Graphic Objects
- 14.8. Customize Clip Art with the Ungroup Command
- 14.9. Add a Caption to a Graphic
- 14.10. Turn a WordArt Object into a Picture File
- 14.11. Add a Custom Watermark
- 14.12. Wrap Text Around a Graphic
- 14.13. Organize Pictures with Picture Manager
Executive Editor
Jody Lefevere
Sr. Project Editor
Sarah Hellert
Technical Editor
Joyce Nielsen
Copy Editor
Scott Tullis
Editorial Director
Robyn Siesky
Business Manager
Amy Knies
Sr. Marketing Manager
Sandy Smith
Vice President and Executive Group Publisher
Richard Swadley
Vice President and Executive Publisher
Barry Pruett
Sr. Project Coordinator
Kristie Rees
Proofreader
Susan Hobbs
Indexer
Estalita Slivoskey
Screen Artists
Ana Carrillo
Jill A. Proll
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.