Office 2010 Visual Quick Steps

Sherry Kinkoph Gunter (Alexandria, IN) has authored more than 60 computer books over the past 10 years on a variety of topics. Office 2007 Top 100 Simplified Tips & Tricks, Microsoft Office 2008 for Mac Bible, and Teach Yourself HTML, 2nd Edition, are just a few of Sherry's publications. A native of the Midwest, Sherry currently resides in the Indianapolis area and continues in her quest to help users of all levels and ages master ever-changing computer technologies.

Chapter 1: General Office 2010 Maximizing Tips Customize the Quick Access Toolbar 4 Customize the Ribbon 6 Control the Ribbon Display 8 Automate Office Tasks with Macros 10 Change the Default Font and Size 12 Chapter 2 Timesaving Tips for Office Files Change the Default File Save Location 16 Save Office Files as PDF Documents 18 Remove Sensitive Document Information 20 Encrypt a Document 22 Add a Digital Signature 24 Recover an Unsaved Document 26 Chapter 3 Boosting Your Productivity in Word Add a Header or Footer Building Block 30 Create a Blog Post 32 Search Through a Document 34 Fix Misspellings with AutoCorrect 36 Emphasize Text with Drop Caps 38 Set a New Default Line Spacing 40 Quickly Insert a Horizontal Line 42 Resume Numbering in an Interrupted Numbered List 43 Set Off a Paragraph with a Border 44 Track Changes in a Document 46 Compare Documents 48 Summarize Information with a Chart 50 Chapter 4 Utilizing Word's Document Building Tools Insert Footnotes and Endnotes 54 Generate a Table of Contents 56 Add a Cross-Reference 58 Chapter 5 Optimizing Excel Automatically Open Your Favorite Workbook 62 Automate Data Entry with AutoFill 64 Color-Code and Name Worksheet Tabs 66 Protect Cells from Unauthorized Changes 68 Generate Random Numbers in Your Cells 70 Freeze Headings for Easier Scrolling 71 Insert a Comment in a Formula 72 Join Text from Separate Cells 73 Audit a Worksheet for Errors 74 Create Projections 76 Create a Database Table 78 Add and Edit Records Using Data Forms 80 Chapter 6 Polishing Your Spreadsheet Data Apply Workbook Themes 84 Change Gridline Color 86 Print Gridlines 87 Add a Background Color, Pattern, or Image 88 Color-Code Your Data with Conditional Formatting 90 Wrap Text for Easy Reading 92 Change Cell Text Orientation 93 Center-Align Printed Data 94 Center Text Across Columns without Merging Cells 95 Chapter 7 Increasing PowerPoint's Potential Convert a Word Document into a Presentation 98 Organize a Presentation into Sections 100 Reuse a Slide from Another Presentation 102 Rehearse Timings 104 Add an Equation 106 Create a Self-Running Presentation 107 Write on a Slide During a Presentation 108 Create Speaker Notes 110 Print Handouts 111 Compress Media Files 112 Turn a Presentation into a Video 114 Broadcast a Presentation 116 Chapter 8 Enhancing Your Presentations Create a Custom Slide Layout 120 Insert a Custom Slide Master 122 Streamline Your Presentation with Themes 124 Customize a Theme 126 Save a Custom Theme 128 Add a Picture to Your Presentation 130 Insert a SmartArt Graphic 132 Add Video or Sound to Your Presentation 134 Animate Your Slides 136