Cover -- Title Page -- Copyright -- Contents -- Part I: Common Office Features -- Chapter 1: Welcome to Microsoft Office 2010 -- Learning about Office Applications -- Word -- Excel -- PowerPoint -- Outlook -- Taking Advantage of Other Office Applications -- Publisher -- Access -- OneNote -- Starting an Application -- Closing an Application -- Finding Files -- Getting Help -- Browsing Help Contents -- Searching Office.com -- Summary -- Chapter 2: Navigating in Office -- Discoverability -- The "Results-Oriented" User Interface -- Ribbons and Things -- Title Bar -- The Tab Row -- KeyTips -- Ribbon -- Quick Access Toolbar -- Live Preview -- Galleries -- The MiniBar or Mini Toolbar -- Shortcut or Contextual Menus -- Enhanced ScreenTips -- Dialog Boxes and Launchers -- Task Panes -- Status Bar -- Go Backstage with File -- Options -- Truth in Advertising, or What's in a Name? -- Advanced?…?versus Not Advanced? -- Working with Dialog Boxes -- Navigating Dialog Boxes -- Using Tabbed Dialog Boxes -- Summary -- Chapter 3: Mastering Fundamental Operations -- Working with Files -- Understanding Office 2010 File Formats -- Creating a New, Blank File -- Creating a File with a Document Template -- Saving and Naming a File -- Opening a File -- Closing a File -- Printing a File -- Performing a Basic Preview and Print -- Understanding Page Design Settings -- Choosing Print Settings and Printing -- Working with Multiple Windows -- Switching to Another File or Application Window -- Arranging Windows -- Moving and Copying Information -- Understanding the Clipboard -- Selecting Information -- Copying -- Cutting -- Pasting -- Finding and Replacing -- Spell Checking -- AutoCorrect, AutoFormat, and Actions -- Styles and Live Preview -- Summary -- Part II: Creating Documents with Word -- Chapter 4: Making a Document -- Creating a Blank File -- Typing Text.

Using Word Wrap -- Inserting versus Overtyping -- Using Default Tabs -- Making a New Paragraph -- Creating a File from a Template -- Understanding Templates -- Creating the File from the Template -- Working with Template Content -- Saving and File Formats -- Convert -- Save & Send (Formerly Publish) -- Compatibility with Previous Versions of Word -- To .doc or Not to .doc -- Persistent Save As -- Microsoft Office Compatibility Pack -- .docx versus .docm -- Converting a .docx File into a .docm File -- Understanding .docx -- Navigation Tips and Tricks -- Tricks with Clicks -- Seldom Screen -- Keyboard -- Views -- Draft View Is the New Normal View -- Print Layout -- Full Screen Reading -- Web Layout -- Outline (Master Document Tools) -- Summary -- Chapter 5: Formatting 101: Font/Character Formatting -- The Big Picture -- Styles and Character/Font Formatting -- Style versus Direct -- Character Formatting -- Formatting Techniques -- The Font Group -- The Font Dialog Box -- The Mini Toolbar -- Character-Formatting Shortcut Keys -- Summary -- Chapter 6: Paragraph Formatting -- Styles and Paragraph Formatting -- When to Use Styles -- What Exactly Is a Paragraph, Anyway? -- Paragraph-Formatting Attributes -- Paragraph-Formatting Techniques -- Structural Formatting -- Indentation -- Alignment -- Tabs -- Paragraph Decoration -- Numbering/Bullets -- Shading -- Borders and Boxes -- Random Bonus Tip #1-Sort Paragraphs That Aren't in a Table -- Random Bonus Tip #2-Move Paragraphs Easily -- Summary -- Chapter 7: Styles -- Styles Group -- Using Styles -- Creating and Modifying Styles -- Quick Style Sets -- Styles Task Pane -- Manage Styles -- Style Inspector -- Summary -- Chapter 8: Page Setup and Sections -- Page Setup Basics -- Section Formatting -- Styles, Section Formatting, and Paragraph Formatting -- Page Setup Choices.

Page Layout Settings -- Page Borders -- The Header and Footer Layer -- Document Sections -- Header and Footer Navigation and Design -- Editing the Header and Footer Areas -- Header and Footer Styles -- Section Surfing -- Link to Previous -- Different First Page -- Different Odd & Even Pages -- Show Document Text -- Distance from Edge of Paper -- Adding Header and Footer Material -- Page Numbers -- Themes -- What Are Themes? -- Using Built-In Themes -- Summary -- Chapter 9: Tables and Graphics -- Quick Start -- Table Basics -- Inserting Tables from Scratch -- Inserting Tables Based on Existing Data -- Handling Tables -- Table Properties -- Table Layout and Design -- Modifying Table Layout -- Table Math -- Modifying Table Design -- Inserting Pictures from Files -- If Your Picture Format Isn't Supported -- Pictures from the Clipboard and Internet -- Manipulation 101 -- Wrapping -- Dragging and Nudging -- Resizing and Cropping -- Adjust -- Arranging Pictures on the Page -- Inserting Clip Art -- SmartArt -- Inserting SmartArt -- Summary -- Chapter 10: Data Documents and Mail Merge -- Understanding Data Sources -- Choosing the Type of Data Document -- Restoring a Word Document to Normal -- Attaching a Data Source -- Selecting Recipients -- Assembling a Data Document -- Merge Fields -- Rules -- Match Fields -- Preview Results -- Find Recipient -- Update Labels -- Highlight Merge Fields -- Auto Check for Errors -- Finishing the Merge -- Mail Merge Task Pane/Wizard -- Step 1: Document Type -- Step 2: Starting Document -- Step 3: Select Recipients -- Step 4: Write Your Letter -- Step 5: Preview Your Letters -- Step 6: Complete the Merge -- Summary -- Chapter 11: Security, Tracking, and Comments -- Protection Types -- Restricting Permission (Information Rights Management) -- Digital Signatures.

Document Inspector (Removing Private/Personal Information) -- Formatting and Editing Restrictions -- Password to Open/Modify -- Comments and Tracked Changes -- Comments -- Tracked Changes -- Show Markup -- Display for Review -- Reviewing Pane -- Reviewing Comments and Changes -- Accepting and Rejecting Comments -- Accepting and Rejecting Changes -- Protecting Documents for Review -- Summary -- Part III: Making the Numbers Work with Excel -- Chapter 12: Using Excel Worksheets and Workbooks -- What Is Excel Good For? -- What's New in Excel 2010? -- Understanding Workbooks and Worksheets -- Moving around a Worksheet -- Navigating with Your Keyboard -- Navigating with Your Mouse -- Introducing Excel's Ribbon Tabs -- Ribbon Tabs -- Contextual Tabs -- Creating Your First Excel Worksheet -- Getting Started on Your Worksheet -- Filling in the Month Names -- Entering the Sales Data -- Formatting the Numbers -- Making Your Worksheet Look a Bit Fancier -- Summing the Values -- Creating a Chart -- Printing Your Worksheet -- Saving Your Workbook -- Summary -- Chapter 13: Entering and Editing Worksheet Data -- Exploring the Types of Data You Can Use -- About Numeric Values -- About Text Entries -- About Formulas -- Entering Text and Values into Your Worksheets -- Entering Dates and Times into Your Worksheets -- Entering Date Values -- Entering Time Values -- Modifying Cell Contents -- Erasing the Contents of a Cell -- Replacing the Contents of a Cell -- Editing the Contents of a Cell -- Learning Some Handy Data-Entry Techniques -- Applying Number Formatting -- Using Automatic Number Formatting -- Formatting Numbers by Using the Ribbon -- Using Shortcut Keys to Format Numbers -- Formatting Numbers Using the Format Cells Dialog Box -- Summary -- Chapter 14: Essential Worksheet and Cell Range Operations.

Learning the Fundamentals of Excel Worksheets -- Working with Excel Windows -- Adding a New Worksheet to Your Workbook -- Deleting a Worksheet You No Longer Need -- Changing the Name of a Worksheet -- Changing a Sheet Tab Color -- Rearranging Your Worksheets -- Hiding and Unhiding a Worksheet -- Controlling the Worksheet View -- Zooming in or out for a Better View -- Viewing a Worksheet in Multiple Windows -- Comparing Sheets Side-by-Side -- Splitting the Worksheet Window into Panes -- Keeping the Titles in View by Freezing Panes -- Monitoring Cells with a Watch Window -- Working with Rows and Columns -- Inserting Rows and Columns -- Deleting Rows and Columns -- Hiding Rows and Columns -- Changing Column Widths and Row Heights -- Understanding Cells and Ranges -- Selecting Ranges -- Selecting Complete Rows and Columns -- Selecting Noncontiguous Ranges -- Selecting Multisheet Ranges -- Selecting Special Types of Cells -- Selecting Cells by Searching -- Copying or Moving Ranges -- Copying by Using Ribbon Commands -- Copying by Using Shortcut Menu Commands -- Copying or Moving by Using Drag-and-Drop -- Copying to Adjacent Cells -- Copying a Range to Other Sheets -- Using the Office Clipboard to Paste -- Pasting in Special Ways -- Using the Paste Special Dialog Box -- Using Names to Work with Ranges -- Creating Range Names in Your Workbooks -- Managing Names -- Adding Comments to Cells -- Formatting Comments -- Working Further with Comments -- Summary -- Chapter 15: Introducing Formulas and Functions -- Understanding Formula Basics -- Using Operators in Formulas -- Understanding Operator Precedence in Formulas -- Using Functions in Your Formulas -- Entering Formulas into Your Worksheets -- Entering Formulas Manually -- Entering Formulas by Pointing -- Pasting Range Names into Formulas.

Inserting Functions into Formulas.