Skip to main content

Office 2010 Visual Quick Tips

Office 2010 Visual Quick Tips

ISBN: 978-1-118-03621-1

Feb 2011

368 pages

Select type: E-Book


Product not available for purchase


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.

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.