Get the fast facts that make learning Office 2010 plain and simple! This colorful, no-nonsense guide uses easy-to-follow steps and screenshots, and clear, concise language to show the simplest ways to get things done with Microsoft Word, Excel®, Outlook®, PowerPoint®, Access®, Publisher, and OneNote®.
Here's WHAT You'll Learn
Create documents, Web pages, and other publications
Organize your e-mail, calendar, contacts and tasks
Build spreadsheets to analyze and visualize data
Set up a simple database
Capture notes with ink, voice or text
Here's HOW You'll Learn It
Jump in wherever you need answers
Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
Handy TIPS teach new techniques and shortcuts
Quick TRY THIS! exercises help you apply what you learn right away
Chapter 1 About This Book
No Computerspeak!
A Quick Overview
What's New in Office 2010?
A Few Assumptions
A Final Word (or Two)
Chapter 2 Working in Office 2010
What's What in Office 2010?
Using the Ribbon
Using Galleries and Lists
Using Shortcut Menus and Dialog Boxes
Using Only the Keyboard
Moving and Copying Content
Working with Backstage View
Getting Help
Saving Your Work
Office's File Formats
Chapter 3 Common Tasks in Office
Working with Old Documents
Inserting Pictures
Changing the Size of a Picture
Editing a Picture
Enhancing Your Pictures
Making Your Pictures Pop
Adding Clip Art
Inserting Screenshots
Adding Shapes
Formatting a Shape
Inserting the Date and Time
Creating Stylized Text
Inserting a SmartArt Diagram
Translating Your Text
Researching a Subject
Chapter 4 Viewing and Editing Text in Word
What's Where in Word 2010?
Creating a New Document
Composing Different Types of Documents
Word's Views
Reading a Document
Editing Text
Discovering the Many Ways to Work with Text
Navigating Your Document
Replacing Text
Correcting Your Spelling and Grammar
Correcting Text Automatically
Adding Page Numbers
Co-Authoring in Word 2010
Marking and Reviewing Changes in a Document
Comparing Documents Side by Side
Chapter 5 Formatting in Word
Controlling the Look: Themes, Styles, and Fonts
Choosing a Theme for Your Document
Formatting Text with Styles
Choosing Styles from the Styles Window
Changing Character Fonts
Setting Paragraph Alignment
Adjusting Paragraph Line Spacing
Setting Spacing Between Paragraphs
Indenting a Paragraph
Formatting with Tabs
Adding Emphasis and Special Formatting
Copying Your Formatting
Creating a Bulleted or Numbered List
Formatting a List
Creating a Table from Scratch
Using a Predesigned Table
Creating a Table from Text
Adding or Deleting Rows and Columns
Formatting a Table
Improving the Layout with Hyphenation
Laying Out the Page
Creating Special Page Setups
Creating Headers and Footers
Changing Page Orientation Within a Document
Flowing Text into Columns
Creating Sections
Wrapping Text Around a Graphic
Sorting Your Information
Reorganizing a Document
Chapter 6 Working with Special Content in Word
Numbering Headings and Lines
Inserting a Cover Page
Inserting Information with Additional Actions
Inserting an Equation
Adding a Sidebar or a Pull Quote
Inserting a Watermark
Creating Footnotes and Endnotes
Inserting a Citation
Creating a Table of Contents
Printing an Envelope
Printing a Mailing Label
Mail Merge: The Power and the Pain
Creating a Form Letter
Finalizing Your Document
Chapter 7 Working in Excel
What's Where in Excel?
Excel 2010 Basics
Using a Predefined Workbook
Choosing a Theme for Your Worksheet
Entering the Data
Editing the Data
Formatting Cells
Formatting Numbers
Moving, Copying, and Pasting Data
Adding and Deleting Columns and Rows
Hiding Columns and Rows
Creating a Data Series
Formatting Cell Dimensions
Organizing Your Worksheets
Preparing for Printing
Printing a Worksheet
Adding and Viewing Comments
Working with the Excel Web App
Chapter 8 Analyzing and Presenting Data in Excel
Applying Conditional Formatting to Cells
Customizing Conditional Formatting
Cell References, Formulas, and Functions
Adding Sparklines
Introducing Formulas
Doing the Math
Summing the Data
Making Calculations with Functions
Creating a Series of Calculations
Troubleshooting Formulas
Creating a Table
Sorting the Data
Filtering the Data
Separating Data into Columns
Creating Subtotals
Summarizing the Data with a PivotTable
Adding Slicers
Reviewing the Data
The Anatomy of a Chart
Charting Your Data
Formatting a Chart
Customizing a Chart
Chapter 9 Creating a PowerPoint Presentation
What's Where in PowerPoint?
Creating a Presentation
Set the Page Background
Entering Content
Formatting a Slide
Editing a Presentation
Adding Headers and Footers
Reusing Slides
Modifying the Default Layout
Inserting a Table
Turning Text into SmartArt
Applying WordArt Styles to Text
Animating Items on a Slide
Customizing Your Animation
Adding an Action to a Slide
Adding and Editing Video
Adding Sound to Your Slides
Setting Slide Transitions
Creating a Photo Album
Chapter 10 Presenting a PowerPoint Slide Show
Exploring Your Presentation Options
Recording a Narration
Timing a Presentation
Adding Speaker Notes
Customizing the Presentation
Reviewing a Presentation
Creating Different Versions of a Slide Show
Printing Handouts
Running a Slide Show
Sharing a Presentation
Publishing Your Slides
Packaging Your Presentation
Creating Pictures of Your Slides
Saving Your Presentation as a Video
Broadcasting Your Presentation
Changing Slide-Show Settings
Chapter 11 Working with Messages in Outlook
What's Where in Outlook Messages?
Sending E-mail
Receiving and Reading E-mail
Replying to and Forwarding a Message
Staying in Touch with Outlook Social Connector
Sending or Receiving a File
Formatting E-mail Messages
Managing Messages with Quick Steps
Signing Your E-mail
Reading RSS Items
Setting Up E-mail Accounts
Chapter 12 Organizing with Outlook
A Quick Look at Outlook's Organizing Abilities
Setting an Appointment
Keeping Track of Your Schedule
Sharing Calendars
Viewing Your Group's Schedule
Scheduling a Meeting
Managing Your Contacts
Keeping Track of Your Tasks
Assigning Tasks
Tacking Up Notes
Creating and E-mailing Contact Business Cards
Chapter 13 Creating a Publication in Publisher
Exploring the New Look of Publisher 2010
Starting with a Template
Creating a Publication from Scratch
Adding Text
Flowing Text Among Text Boxes
Tweaking Your Text
Inserting and Modifying a Picture
Adding a Table
Repeating Objects on Every Page
Adding Building Blocks
Arranging Objects on the Page
Stacking and Grouping Objects
Flowing Text Around an Object
Reusing Content
Inserting Your Contact Information
Checking Your Publication
Sending a Publication as E-mail
Printing Your Publication
Chapter 14 Organize and Share Information in OneNote 2010
What's Where in OneNote?
OneNote Basics: Gathering Your Thoughts
Creating a OneNote Notebook
Adding and Working with Sections
Inserting and Working with Notes Pages
Inking in OneNote
Adding Audio Notes
Grabbing Web Clippings
Sharing Notes in Word and PowerPoint
Saving Outlook Data to OneNote
Working with Side Notes and Unfiled Notes
Chapter 15 Working in Access
What's Where in Access?
Databases: A Simple Approach
Creating a Database from a Template
Using an Existing Database
Adding a Data Table
Adding and Changing Fields and Records
Adding Data to a Table
Importing Data
Exporting Data
Defining Table Relationships
Creating a Form
Creating a Report from the Data
Formatting Reports
Querying Information from Your Data Tables
Analyzing Data with a PivotChart
Chapter 16 Customizing and Securing Office
Customizing the Ribbon
Customizing the Quick Access Toolbar
Customizing the Work Area
Customizing Your Editing
Changing Your User Information
Customizing the Spelling and Grammar Checkers
Customizing Your Spelling Dictionaries
Changing the Location and Type of Saved Files
Understanding Security in Office 2010
Changing File Validation
Choosing What's Displayed in Protected View
Password Protecting a File
Limiting File Changes
Recovering Unsaved Versions of a File
Setting AutoRecover Options
Signing a Document or Workbook with a Digital Signature
Katherine Murray is a communications expert who specializes in teaching people and businesses how to improve their productivity with Microsoft® technologies. She has written more than 50 books related to Microsoft® Office, Web technologies, and the digital lifestyle, including MICROSOFT® OFFICE WORD 2007 INSIDE OUT.