Title Details

Sherry Kinkoph Gunter has written and edited oodles of books over the past 18 years covering a wide variety of computer topics, including Microsoft Office programs, digital photography, and Web applications. Her recent titles include Teach Yourself VISUALLY Office 2007,  Microsoft Office 2008 for Mac Bible, and Master VISUALLY Dreamweaver CS3 and Flash CS3 Professional. Sherry began writing computer books back in 1992, and her flexible writing style has allowed her to author for a varied assortment of imprints and formats. Sherry’s ongoing quest is to aid users of all levels in the mastering of ever-changing computer technologies, helping users make sense of it all and get the most out of their machines and online experiences. Sherry currently resides in a swamp in the wilds of east central Indiana with a lovable ogre and a menagerie of interesting creatures.

Chapter1: 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.