Habraken J. Microsoft Office 2010 In Depth

Que, 2011. — 969 p.
Author: Joe Habraken.Office 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Office 2010, and get more done in less time. Best selling technology expert Joe Habraken provides specific, tested, proven solutions to the problems Office users run into every day: challenges other books ignore or oversimplify. Habraken thoroughly covers all facets of working with Office 2010's core features and techniques, and powerful new enhancements such as: " The updated customizable Ribbon and new Backstage full-screen options menu " Vastly improved image and illustration tools " Live Preview for tasks like Paste, Insert, or Theme change " Improved integration with SharePoint services, Windows Live, and Office Web Apps " And much more Simply put, no other book offers Office 2010 users this much simplicity, usable content, flexibility, and value. As with all In Depth books, Office 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out. This book is both a reference and a desk-side resource, providing in depth coverage of important Office 2010 applications features and tools.Who Should Buy This Book.
How This Book Is Organized.
Conventions Used in This Book.
Key Combinations.
Special Elements.
Cross References.Office 2010 Interface and Common FeaturesGetting Oriented to the Office 2010 Applications
Introducing Office 2010.
New Features and Tools in Office 2010.
The Office Backstage.
Enhanced Smart Art Graphics.
New Screen Capture Tool.
New Background Removal Tool.
Other Office 2010 Improvements and Updates.
Introducing the Office Web Apps.
The Office 2010 Suite Applications.
The Different Versions of the Office 2010 Suite.
Hardware and Software Requirements for Office 2010.
Installing Office 2010.
Getting Help and Support for Office Applications.Navigating and Customizing the Office Interface
Getting Familiar with the Office Interface.
Galleries.
Contextual Tabs.
Changes in the Office 2010 User Interface.
Overview of the Office Application Window.
Navigating the Office Applications.
Working with the Ribbon.
Working in the Backstage.
Dialog Boxes and Task Panes.
Using the Status Bar.
Customizing an Application Interface.
Customizing the Ribbon.
Customizing the Quick Access Toolbar.
Customizing the Status Bar.
Configuring Application Options.
Advanced Option Settings.
Add-Ins.
Using the Trust Center.
Trusted Publishers.
Trusted Locations.Managing and Sharing Office Files
Understanding Office File Formats.
Saving Files to Different File Types.
Converting Files to Different File Types.
Configuring Save File Options.
Creating and Managing Files.
Managing Files.
Viewing File Versions in an Application.
Searching for Office Files.
Sharing Files Using Windows 7 Homegroup.
Setting Office Permissions.
Restricting Permission by People.
Adding a Digital Signature to a File.
Prepare a File for Sharing.
Sharing Files Using SharePoint Workspace.
Creating a New Workspace.
Adding Files to the Workspace.
Inviting Members.Using and Creating Graphics
The Office 2010 Options for Graphics and Pictures.
Working with SmartArt Graphics.
Inserting SmartArt Graphics.
Modifying SmartArt Graphics.
Aligning Graphics and Text.
Adding and Manipulating Pictures.
Inserting Pictures.
Adjusting Pictures.
Cropping an Image.
Using the Background Removal Tool.
Using Shapes and the Office Drawing Tools.
Adding Multiple Shapes to a Drawing Canvas.
Adding Text to a Shape.
Formatting a Shape with the Drawing Tools.
Using the Screenshot Feature.
Working with Clip Art.
Viewing Clip Art Properties.
Adding Clip Art to Your Collection.
Using WordArt.Working with the Office Web Apps
What the Web Apps Can Do.
Where the Web Apps Live.
Saving Office Application Files to SkyDrive and SharePoint Sites.
Saving a File to SkyDrive.
Saving a File to a SharePoint Site.
Sharing a OneNote Notebook Online.
Other Ways to Get Files Online.
Using the Word Web App.
The File Tab.
The Word Web App Home Tab.
The Word Web App Insert Tab.
The Word Web App View Tab.
Using the Excel Web App.
The Excel Web App File Tab.
Working in the Excel Web App.
Inserting Formulas and Functions in the Excel Web App.
Using the PowerPoint Web App.
Working with Slides.
Adding Pictures and SmartArt.
Using the OneNote Web App.
Adding Sections and Pages.
Adding Notes and Note Tags to Pages.
Inserting Tables and Other Objects onto Pages.Word
Requisite Word: Essential Features
Introducing Word 2010.
The Word 2010 Interface.
Word 2010 Improvements.
Options for Creating a New Word Document.
Using Templates.
Creating a Template.
Attaching a Template.
Navigating a Word Document.
Moving Around a Document with the Mouse.
Moving Around a Document with the Keyboard.
Selecting Text.
Understanding Document Formatting.
Character Formatting Versus Paragraph Formatting.
Manual Formatting Versus Styles and Themes.
Working with Fonts and Text Formatting.
Formatting Text.
Working with Paragraph Formatting.
Setting Paragraph Alignment.
Changing Line Spacing.
Setting Line and Page Breaks.
Setting Indents.
Working with Tabs.
Revealing Format Settings.
Page Layout: Margins and Page Options.
Changing Margins.
Changing Page Orientation and Paper Size.
Inserting Page Breaks.
Printing Documents.Enhancing Word Documents
Creating Better Documents.
Creating Bulleted and Numbered Lists.
Bulleted Lists.
Numbered Lists.
Multilevel Lists.
Working with Borders and Shading.
Formatting with Themes.
Creating Headers and Footers.
Creating Headers and Footers.
The Header and Footer Tools.
Working with Page Numbering.
Inserting Pictures, Clip Art, and Charts.
Inserting Pictures.
Adding Clip Art.
Inserting a Chart.
Integrating Text and Images.
Changing the Document Display.
Using the Navigation Pane.
Splitting the Document Window.
Using the Review Tools.
Running Spelling and Grammar.
Using the Thesaurus.
Using the Research Pane.
Working with Quick Parts.
Creating and Inserting an AutoText Entry.
Creating and Inserting Building Blocks.
Configuring AutoCorrect.
Understanding Styles.
Using Quick Styles.
Creating Styles.
Editing Styles.
Managing Styles.Working with Tables, Columns, and Sections
Options for Adding a Table.
Inserting a Table.
Drawing a Table.
Converting Text to a Table.
Entering Text and Navigating a Table.
Selecting and Positioning a Table.
Formatting Tables.
Adjusting Columns and Rows.
Formatting Cells.
Using Table Styles.
Sorting Table Data.
Using Formulas in Tables.
Adding Columns to a Document.
Understanding Sections.
Adding and Removing Section Breaks.
Formatting Page Attributes in a Section.Managing Mailings and Forms
Options for Mail-Related Documents.
Creating an Envelope.
Creating a Sheet of Labels.
Understanding Word’s Options for Mass Mailings.
Performing a Mail Merge.
Using the Mail Merge Commands.
Understanding Recipient Lists.
Creating a Recipient List.
Editing and Manipulating a Recipient List.
Using Merge Fields.
Using Merge Rules.
Previewing Merge Results.
Completing the Merge.
Creating Merged Envelopes and Labels.
Understanding Word Fields.
Building a Form with Form Controls.Creating Special Documents
Options for Large Documents.
Creating a Table of Contents.
Creating a Table of Contents with Built-in Styles.
Creating a Table of Contents with Your Own Styles.
Adding Entries and Updating the TOC.
Building a TOC with Field Codes.
Working with Captions and Tables of Figures.
Inserting a Caption.
Inserting a Table of Figures.
Using Cross-References.
Generating an Index.
Marking Index Entries.
Inserting the Index.
Working with Citations and Bibliographies.
Creating Citations.
Managing Citations.
Inserting the Bibliography.
Inserting Footnotes and Endnotes.
Tracking Document Changes.
Options for Viewing Changes.
Reviewing Changes.
Comparing Documents.
Building a Better Big Document.
Creating Bookmarks.
Inserting Comments.
Creating a Master Document.Excel
Requisite Excel: Essential Features
Introducing Excel 2010.
Sparklines.
Slicers.
The New Solver.
Navigating the Excel Workspace.
The Excel Ribbon.
Moving Around a Worksheet.
Creating Workbooks and Worksheets.
Using Office.com Templates.
Inserting and Rearranging Worksheets.
Understanding Cell Addresses and Ranges.
Managing Excel Workbooks.
Protecting Workbooks and Worksheets.
Locking Cells.
Specifying Edit Ranges.
Preparing a Workbook for Sharing.
Managing Versions.
Entering Data in a Worksheet.
Entering Labels.
Entering Values.
Using AutoComplete.
Filling and Entering Series.
Using the Fill Handle.
Creating Custom Fill Lists.
Creating Custom Series.
Copying, Moving, and Deleting Cell Contents.
Using the Paste Special Dialog Box.
Moving Cells and Ranges.
Clearing and Deleting Cells.
Editing Cell Content.
Viewing Worksheets.
Printing Worksheets.
Using the Page Layout Commands.
Setting a Print Area.
Working in the Print Window.
Inserting Headers and Footers.Worksheet Formatting and Management
Formatting Text Entries.
Accessing the Format Cells Dialog Box.
Changing Text Orientation.
Formatting Values.
Using the Format Cells Dialog Box.
Creating Custom Number Formats.
Adding Comments to Cells.
Formatting Comment Text.
Deleting and Viewing Comments.
Using Themes.
Formatting Cells Using Borders and Color.
Adding Cell Borders.
Using Background Colors.
Using Cell Styles and the Format Painter.
Creating a Cell Style.
Using the Format Painter.
Using Conditional Formatting.
Using Highlight Cell Rules.
Using Top/Bottom Rules.
Using Data Bars.
Using Color Scales.
Using Icon Sets.
Creating Conditional Formatting Rules.
Manipulating Cells and Cell Content.
Inserting Cells.
Merging Cells and Wrapping Text.
Finding and Replacing Cell Items.
Working with Columns and Rows.
Changing Column Width and Row Height.
Inserting Columns and Rows.
Deleting Columns and Rows.
Hiding Columns and Rows.
Working with Worksheets.
Freezing Rows and Columns.
Splitting Worksheets.
Hiding Worksheets.
Naming Ranges.
Creating Range Names from Selections.
Managing Range Names.
Adding Images and Graphics to Worksheets.Getting the Most from Formulas and Functions
Performing Calculations in Excel Worksheets.
Relative Versus Absolute Referencing.
Creating and Editing Formulas.
Understanding Operator Precedence.
Entering Formulas.
Editing Formulas.
Working with Excel Functions.
Entering a Function in a Cell.
Using AutoSum.
Using the Status Bar Statistical Functions.
Using the Insert Function Dialog Box.
Using the Function Library.
Using Range Names in Formulas and Functions.
Inserting a Range Name into a Formula.
Inserting a Range Name into a Function.
Referencing Cells or Ranges on Other Worksheets.
Copying and Moving Formulas and Functions.
Choosing the Right Function.
Financial Functions.
Logical Functions.
Statistical Functions.
Lookup & Reference Functions.
Date and Time Functions.
Text Functions.
Other Function Categories.
Proofing Your Formulas and Functions.
Common Error Messages.
Using the Auditing Tools.
Using the Watch Window.Enhancing Worksheets with Charts
Understanding Excel Charts.
Chart Terminology.
Using Different Chart Types.
Creating Charts.
Inserting a Chart.
Moving, Copying, or Deleting a Chart.
Modifying a Chart.
Changing Chart Type or Chart Data.
Creating and Using a Chart Template.
Selecting Chart Layouts and Styles.
Working with Chart Elements.
Modifying Titles and Data Labels.
Working with the Legend and Data Points.
Manipulating Axes and Gridlines.
Adding Trendlines, Drop Lines, and Bars to a Chart.
Using the Chart Tools Format Tab.
Creating a Combination Chart.
Working with a Pie of Pie Chart.
Creating a Custom Combination Chart.
Using Sparklines.
Creating Sparklines.
Modifying Sparklines.Using Excel Tables and PivotTables
Excel and Databases.
Defining a Table Range.
Creating a Table Using Styles.
Using the Table Tools.
Sorting Table Data.
How Excel Sorts Data.
Using the Sort Dialog Box.
Filtering Table Data.
Using the AutoFilter Search Box.
Creating Custom AutoFilters.
Creating Advanced Filters.
Using the Data Form.
Creating Outlines and Subtotals.
Working with External Data.
Importing Data from Access.
Importing a Web Table.
Importing Text Files.
Connecting to a SQL Server.
Using Microsoft Query.
Viewing and Refreshing Connections.
Working with PivotTables.
Creating a PivotTable.
Working with the PivotTable Tools.
Using Slicers.Validating and Analyzing Worksheet Data
Taking Advantage of Data Validation.
Specifying Validation Criteria.
Configuring Input Messages and Error Alerts.
Circling Invalid Data.
Performing a What-If Analysis.
Creating a Data Table.
Creating Scenarios.
Viewing Scenarios and Creating Reports.
Using Goal Seek and Solver.
Working with Goal Seek.
Working with the Solver.
Using PowerPivot.
Connecting to a Data Source.
Manipulating Data in PowerPivot.PowerPoint
Requisite PowerPoint: Essential Features
Introducing PowerPoint 2010.
The PowerPoint Workspace.
Options for Creating a New
Presentation.
Using Templates.
Using a Theme to Create a New Presentation.
Creating a Presentation from an Existing Presentation.
Creating Individual Slides Using Slide Templates.
Creating a Template.
Inserting Slides.
Inserting a New Slide.
Inserting Slides from Another Presentation.
Inserting Slides from an Outline.
Modifying a Slide’s Layout.
Working with Slides in Different Views.
Zooming in and Out.
Rulers, Gridlines, and Guides.
Color/Grayscale Commands.
Opening a New Presentation Window.
Rearranging and Deleting Slides.
Modifying Bulleted Lists.
Picture Bullets.
Symbol Bullets.
Using Numbered Lists.
Viewing a Presentation During Editing.Advanced Presentation Formatting,
Themes, and Masters
Working with Text Boxes and Formatting.
Inserting a Text Box.
Basic Text Formatting.
Changing Paragraph Attributes.
Formatting a Text Box with the Drawing Tools.
Selecting Quick Styles and Shape Attributes.
Shape Fill, Outline, and Effects.
Using WordArt Styles and Text Settings.
Arranging Text in Tables.
Insert a Table on an Existing Slide.
Formatting a Table.
Table Layout Commands.
Working with Themes.
Applying Themes.
Adjusting Colors, Fonts, and Effects.
Using Headers and Footers.
Understanding Masters.
Altering and Creating Master Slides.
Altering the Slide Master.
Create a New Slide Master.
Creating Layout Masters.
Using Slide Sections.Better Slides with Clip Art, Pictures, and SmartArt
Using Graphics to Enhance Slides.
Inserting a Picture.
Adding Clip Art to Slides.
Creating a Photo Album.
Adjusting Picture Settings.
Setting Album Layout Settings.
Working with Shapes.
Using SmartArt Graphics.
Inserting a SmartArt Graphic.
Converting Text to a SmartArt Graphic.
Using the SmartArt Tools.
Adding Charts to Slides.
Inserting a Chart onto a Slide.
Modifying and Formatting a Chart.
Working with Slide Objects.
Grouping Objects.
Layering Objects.
Adding Hyperlinks to Slides.Enhancing Slides with Animation, Transitions, and Multimedia
Animations Versus Transitions.
Assigning Animation to a Slide Object.
Accessing Additional Animation Effects.
Using Motion Paths.
Advanced Animation Techniques.
Changing Effect Options.
Adding Additional Animations.
Using the Animation Painter.
Including Sound Effects with Animations.
Setting Timings for Animations.
Managing Slide Animations.
Adding Transitions to Slides.
Modifying Transitions.
Adding Sound to a Slide.
Editing Sound Options.
Adding Video to a Slide.
Inserting a Video File.
Modifying Video Clips.
Embedding Web Video Clips.Delivering a Presentation and Creating Support Materials
Planning Your Presentation.
Checking the Presentation for Spelling and Grammar Errors.
Running Through a Completed
Presentation.
Using Hidden Slides.
Creating a Custom Slide Show.
Creating a Self-Running Presentation.
Setting Up the Slide Show.
Rehearsing Timings.
Recording a Slide Show.
Creating an Interactive Presentation.
Broadcasting a Slide Show on the Web.
Working with the Notes and Handouts Masters.
Setting Handout Master Options.
Setting Notes Master Options.
Printing Presentations, Notes, and Handouts.
Collaborating with Others on a Presentation.Outlook
Requisite Outlook: Configuration and Essential Features
Introducing Outlook 2010.
Quick Steps.
Outlook and Email Accounts.
Internet Email.
Exchange Server.
Windows Live Hotmail.
Configuring Outlook at First Start.
Understanding Outlook Profiles.
Creating a New Profile.
Managing Profiles.
Loading Profiles.
Understanding Outlook Data Files.
Protecting and Creating Personal Folders
Files.
Repairing Outlook Data Files.
Importing and Exporting Data.
Importing Data.
Exporting Data.
Navigating the New Outlook Interface.
Accessing Outlook Items Using the
Navigation Pane.
Working with Views in Outlook.
Categorizing Outlook Items.
Searching for Outlook Items.
Using Advanced Find.
Using Search Folders.
Printing Outlook Items.Managing Email in Outlook
Working in the Mail Folder.
Creating an Email Message.
Using the Outlook Address Book.
Setting Message Options.
Specifying Email Format.
Setting Message Importance, Flags, and Policies.
Setting Permissions and Tracking Options.
Installing the Information Rights Management Service.
Configuring Voting Buttons and Receipts.
Requesting Receipts.
Setting Delivery Options.
The Message Properties Dialog Box.
Attaching Files and Items to a Message.
Attaching a Business Card.
Attaching a Calendar.
Using Themes and Email Stationery.
Adding a Signature.
Sending Mail.
Recalling a Message.
Working with Received Email.
Managing Email.
Answering a Message.
Forwarding a Message.
Saving an Attachment.
Deleting Messages.
Printing Mail.
Organizing Messages.
Filtering Email.
Moving Email.
Managing Email Accounts.
Editing Email Account Settings.
Adding an Email Account.
Adding a Hotmail Account.
Setting Outlook Mail Options.Using the Calendar for Appointments and Tasks
Navigating the Calendar.
Changing the Calendar View.
Change the Time Scale and Time Zone.
Scheduling a Recurring Appointment.
Scheduling an Event.
Sharing Your Calendar.
Opening a Shared Calendar.
Viewing Multiple Calendars.
Emailing a Calendar.
Publishing a Calendar Online.
Using the Task Folder.
Creating a New Task from the Task Folder.
Creating a Recurring Task.
Viewing and Managing Tasks.
Viewing the Tasks List.
Editing Tasks.
Managing Tasks.Working with Contacts and Planning Meetings
Navigating the Contacts List.
Creating a New Contact.
Entering Details Fields Information.
Adding Fields for a Contact.
Taking Advantage of Suggested Contacts.
Editing Contact Information.
Editing a Business Card.
Tagging Contacts with Flags and Categories.
Mapping a Contact’s Address.
Finding Contacts.
Organizing Contacts with Groups.
Forwarding and Sharing Contacts.
Forwarding Contacts.
Sharing Contacts.
Contact Communication and Action Options.
Other Communication Options.
Contact Actions.
Checking Contact Activities.
Printing Contact Information.
Setting Contact Options.
Scheduling Meetings.
Selecting the Meeting Location.
Using the Scheduling Assistant.
Viewing and Editing Meeting Information.
Responding to Meeting Requests.Using the Journal and Notes
Using the Outlook Journal.
Enabling Automatic Journaling.
Viewing the Journal.
Journal Actions.
Viewing a Journal Entry.
Manually Adding Journal Items.
Creating New Journal Entries.
Using the Timer.
Changing Journal Options.
Working with Notes.
Viewing and Managing Notes.
Creating Appointments and Tasks from Notes.
Configuring Notes Options.Securing and Maintaining Outlook
Security Overview.
Malware and Anti-Virus Software.
Strong Password Protection.
Keeping Office and Windows Up to Date.
Configuring Outlook Security Settings.
Encrypting Email and Using Digital Signatures.
Options for Encrypting Email.
Digitally Signing Emails.
The Perils of HTML Email.
Dealing with Message Attachments.
Coping with Junk Email.
Working with the Junk E-mail Commands.
Setting Junk E-Mail Options.
Creating Email Rules.
Create a Quick Rule for a Specific Sender.
Creating Complex Rules.
The Rule Wizard.
Managing Rules.
Archiving Outlook Items.
Configuring AutoArchive Settings.
Setting AutoArchive Options for a Folder.
Archiving Manually.
Configuring an Automatic Reply Message.Requisite Publisher: Essential Features
Introducing Publisher 2010.
Planning Your Publication.
Working with Publication Templates.
Creating a New Publication.
Using a Template.
Using Blank Sizes.
Creating a New Template.
Navigating the Publisher Workspace.
Using the Rulers and Guides.
Options for Viewing the Publication.
Creating a Business Information Set.
Creating a New Business Information Set.
Creating Additional Business Information Sets.
Working with Text.
Editing Text in a Text Box.
Creating Your Own Text Boxes.
Formatting Text Boxes.
Linking Text Boxes.
Inserting a Text File.
Inserting Illustrations.
Options for Inserting Pictures.
Insert a Picture.
Insert a Picture Placeholder.
Formatting a Picture.
Inserting Clip Art.
Inserting Shapes.
Using Building Blocks.
Printing Publications.
Advanced Publisher Features.
Adding Pages to a Publication.
Configuring Page Settings.
Changing the Current Template.
Working with Master Pages.
Placing Objects on the Master Page.
Inserting Headers and Footers.
Creating Master Pages.
Using Tables in Publications.
Table Design Commands.
Table Layout Commands.
Manipulating Publication Objects.
Grouping Objects.
Layering Objects.
Swapping Images.
Merging Data into a Publication.
Performing a Mail Merge.
Performing a Catalog Merge.
Fine-Tuning Your Publications.
The Spelling Feature.
Hyphenation.
Design Checker.OneNote
Requisite OneNote: Essential Features
Introducing OneNote 2010.
New Features in OneNote 2010.
How OneNote Notebooks Are Organized.
Navigating the OneNote Workspace.
The OneNote Ribbon.
The OneNote Navigation Bar.
Creating a Notebook.
Modifying a Notebook.
Sharing a Notebook.
Viewing the Sync Status.
Changing Other Notebook Properties.
Working with Sections.
Creating or Deleting a Section.
Modifying Sections.
Creating a Section Group.
Working with Pages.
Creating Pages Using Templates.
Creating Subpages.
Restoring Sections and Pages from the Notebook Recycle Bin.
Inserting and Formatting Notes.
Using Tags.
Finding Tagged Notes.
Using Tables to Store Information.Working with Notebook Pages
Managing Pages.
Using the Move Copy Dialog Box.
Making More Space Available on a Page.
Modifying the Page Setup and View.
Viewing Page Versions.
Viewing Recent Edits.
Viewing Changes by Author.
Adding Objects to Notebook Pages.
Adding Pictures.
Recording Audio.
Recording Video.
Adding Drawings to OneNote
Pages.
Printing Notebook Pages.Integrating OneNote with Other Office Applications
Taking Linked Notes.
Using File Printout.
Adding Links.
Attaching Files.
Inserting Screen Clips.
Integrating OneNote and Outlook.
Emailing a Notebook Page.
Adding Outlook Tasks.
Inserting Meeting Details.Office Application Integration
Sharing Application Data.
Understanding Object Linking and Embedding.
Choosing Between Linking and Embedding.
Linking Objects.
Linking with Paste Special.
Linking with the Paste Options Gallery.
Linking Using the Object Command.
Updating and Breaking Links.
Editing Linked Objects.
Embedding Objects.
Embedding with Paste Special.
Embedding Using the Object Command.
Embedding New Objects.
Editing Embedded Objects.
Sharing Data with Outlook Using Actions.
Office Macros
Macros and Office 2010.
Adding the Developer Tab to the Ribbon.
Enabling Macros in the Trust Center.
Creating Macro-Enabled Office Files.
Understanding Macros.
Creating a Macro.
Recording a Macro.
Assigning a Macro Button to the Quick Access Toolbar.
Running Macros.
Editing Recorded Macros.
Exploring the VBA Editor.
Stepping Through a Macro.
Digitally Signing Macros.