Office 2010: The Missing Manual

Office 2010: The Missing Manual

by Nancy Conner, Matthew MacDonald
Released July 2010
Publisher(s): O'Reilly Media, Inc.
ISBN: 9781449395919

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

Microsoft Office is the most widely used software suite in the world. The half-dozen programs in Office 2010 are packed with amazing features, but most people just know the basics. This entertaining guide not only gets you started with Office, it reveals all kinds of useful things you didn't know the software could do -- with plenty of power-user tips and tricks when you're ready for more.

  • Create professional-looking documents. Learn everything you need to know to craft beautiful Word documents.
  • Stay organized. Keep track of your email, calendar, and contacts with Outlook.
  • Crunch numbers with ease. Assemble data, make calculations, and summarize the results with Excel.
  • Make eye-catching presentations. Build PowerPoint slideshows with video and audio clips, animations, and more.
  • Build Access databases quickly. Make your data easy to find, sort, and manage.
  • Manage your files more efficiently. Use the new Backstage view to quickly work with your Office files.
  • Get to know the whole suite. Learn to use other handy Office tools: Publisher, OneNote, and Office Web Apps.

Publisher resources

View/Submit Errata

Table of contents

  1. Office 2010: The Missing Manual
  2. A Note Regarding Supplemental Files
  3. The Missing Credits
    1. About the Authors
    2. About the Creative Team
    3. Acknowledgements
    4. The Missing Manual Series
  4. Introduction
    1. What Is Office 2010?
    2. What’s New in Office 2010
    3. About This Book
    4. The Very Basics
      1. About→These→Arrows
      2. About MissingManuals.com
      3. Safari® Books Online
  5. One. Word
    1. 1. Basic Word Processing
      1. Opening Word
        1. The Word 2010 Screen
        2. Using Keyboard Shortcuts
      2. Creating a New Document
        1. Creating a New Blank Document
        2. Creating a New Document from a Template
        3. Creating a New Document from an Existing Document
      3. Typing in Some Text
      4. Saving a Document
        1. Saving a Document Using Your Mouse
        2. Saving a Document Using Keyboard Shortcuts
        3. Using the Save As Dialog Box
      5. Closing a Document
      6. Opening an Existing Document
      7. Different Ways to View Your Work
        1. Viewing a Document in the Navigation Pane
          1. Outline view in the Navigation pane
          2. Page view in the Navigation pane
        2. Zooming In and Out
          1. Using the Zoom slider
          2. Using the Zoom dialog box
        3. Working with Multiple Windows
    2. 2. Editing and Formatting
      1. Selecting and Moving Text
        1. Four Ways to Move Text
          1. Option 1: Use the Ctrl key
          2. Option 2: Right-click your mouse
          3. Option 3: Use the Home tab
          4. Option 4: Use the Clipboard pane
      2. Finding and Replacing Text
        1. Searching with the Navigation Pane
        2. Setting Search Options
        3. Searching with the Traditional Find and Replace Dialog Box
        4. Replacing Text
      3. Text Formatting: Font, Size, and Style
        1. The Home Tab’s Control Center
        2. Copy Formatting with Format Painter
        3. Quick Formatting with the Mini Toolbar
        4. Formatting Power with Styles
          1. Applying styles using style sets
          2. Creating your own style set
      4. Paragraph Formatting: Aligning, Indenting, Spacing
        1. Aligning Text
        2. Indenting Paragraphs
          1. Indenting the first line of a paragraph
          2. Indenting an entire paragraph
          3. Creating a hanging indent
        3. Spacing Within a Paragraph
        4. Spacing Between Paragraphs
      5. Working with Lists
        1. Creating a List
        2. Formatting a List
          1. Formatting a bulleted list
          2. Formatting a numbered list
          3. Formatting a multilevel list
      6. Formatting a Document
        1. Using the Page Setup Section
        2. Using the Page Background Section
          1. Adding a watermark
          2. Customizing a watermark with text
          3. Customizing a watermark with an image
          4. Editing or deleting a watermark
          5. Adding color to page backgrounds
          6. Adding patterns to page backgrounds
          7. Giving pages a border
        3. Inserting Headers, Footers, and Page Numbers
          1. Inserting a header or footer
          2. Editing a header or footer
          3. Inserting the date and time into a header or footer
          4. Inserting an image into a header or footer
          5. Removing a header or footer
          6. Inserting page numbers
          7. Formatting page numbers
          8. Removing page numbers
    3. 3. Tables, Graphics, and Charts
      1. Creating a Table
        1. Creating a Table from Scratch
          1. Inserting a table
          2. Inserting a preformatted table
          3. Drawing a table
        2. Creating a Table from Text
      2. Adding Information to a Table
      3. Editing a Table
        1. Selecting Part or All of a Table
          1. Using your mouse
          2. Using the ribbon
        2. Inserting Rows and Columns
        3. Moving Rows and Columns
        4. Merging and Splitting Cells
        5. Deleting All or Part of a Table
      4. Formatting a Table
        1. Save Time with Ready-to-Use Table Styles
        2. Applying Shading and Borders
        3. Shading a Table
        4. Working with Borders
      5. Inserting Images
        1. Inserting a Picture
        2. Inserting Clip Art
        3. Inserting a Screenshot
      6. Editing an Image
        1. Changing an Image’s Size
        2. Cropping an Image
        3. Removing a Picture’s Background
        4. Moving and Rotating Images
          1. Moving an image
          2. Rotating an image
        5. Adjusting an Image’s Appearance
        6. Using Picture Styles
        7. Wrapping Text Around an Image
        8. Searching for Images
      7. Fun with Fonts and Art That’s Smart
        1. Creating WordArt
        2. Editing WordArt Text
        3. Inserting SmartArt into Word Documents
      8. Adding Charts and Diagrams
    4. 4. Proofing and Research Tools
      1. Checking Spelling and Grammar
        1. Catching Spelling Mistakes
          1. Using contextual spelling
          2. Checking spelling in an entire document
        2. Word’s Grammar Checker
      2. Getting Things Right with AutoCorrect
        1. Undoing an AutoCorrect Change
        2. Setting AutoCorrect Options
          1. Making an exception
          2. Adding custom corrections
          3. Deleting an AutoCorrect correction
        3. AutoFormatting in Word
      3. Word’s Built-in Research Tools
        1. Looking Up a Word in the Dictionary
        2. Using the Thesaurus
        3. Getting Information about a Subject
        4. Translating Text
          1. Getting a quick translation with the Mini Translator
          2. Using the Research pane for translations
          3. Translating an entire document
    5. 5. Printing Documents
      1. Getting Started with Printing
        1. Previewing a Document Before You Print It
        2. Printing a Document
      2. Selecting Print Options and Settings
        1. Choosing a Printer
        2. Specifying Settings
      3. Sending a Fax
        1. Creating a Cover Page
        2. Sending a Fax
      4. Printing Envelopes
        1. Formatting Envelope Addresses
        2. Selecting a Feed Method
        3. Adding Electronic Postage
      5. Printing Labels
      6. Merging Names and Addresses with Documents
        1. Step 1: Select Document Type
        2. Step 2: Select Starting Document
        3. Step 3: Select Recipients
        4. Step 4: Write Your Letter
        5. Step 5: Preview Your Letters
        6. Step 6: Complete the Merge
        7. Do-It-Yourself Mail Merge with the Mailings Tab’s Buttons
    6. 6. Reports and Long Documents
      1. Inserting Page Breaks
      2. Breaking a Document into Sections
        1. Kinds of Section Breaks
        2. Inserting a Section Break
        3. Changing the Orientation of a New Section
        4. Changing the Page Numbering of a New Section
      3. Footnotes and Endnotes
        1. Inserting a Footnote
        2. Inserting an Endnote
        3. Editing a Note
        4. Navigating Notes
        5. Changing the Position of Footnotes or Endnotes
        6. Converting Footnotes to Endnotes (or Vice Versa)
        7. Changing Footnote or Endnote Markers
        8. Deleting a Note
      4. Citations and Bibliographies
        1. Creating and Inserting a Citation
        2. Inserting an Existing Citation
        3. Inserting a Placeholder
        4. Editing a Citation or Its Source
        5. Deleting a Citation
        6. Deleting a Source
        7. Building a Bibliography
        8. Updating a Bibliography
      5. Helping Readers Navigate Your Document
        1. Inserting Bookmarks and Cross-References
          1. Creating a bookmark
          2. Jumping to a bookmark
          3. Deleting a bookmark
          4. Creating cross-references
        2. Creating a Table of Contents
        3. Creating an Index
          1. Marking index entries
          2. Generating an index
          3. Updating an index
          4. Editing index entries
          5. Deleting an index entry
          6. Deleting an index
    7. 7. Customizing Your Documents with Themes, Templates, and Macros
      1. Themes: The Way to Better Designs
        1. Choosing a Theme
        2. Customizing a Theme
        3. Saving a Theme
        4. Finding a Saved Theme
      2. Templates: Reusable Document Blueprints
        1. Choosing a Template
        2. Creating Your Own Template
          1. Creating a template from scratch
          2. Creating a template from a document
          3. Creating a template from an existing template
        3. Customizing a Template
          1. Changing an existing style within a template
          2. Creating a new style for a template
          3. Copying a style from one template to another
          4. Deleting a style from a template
      3. Save Time with Macros
        1. Recording a Macro
        2. Running a Macro
        3. Copying a Macro Between Templates
        4. Deleting a Macro
    8. 8. Desktop and Web Publishing
      1. Newsletters and Brochures
        1. Laying Out Text in Columns
        2. Formatting Columns
        3. Inserting a Text Box
        4. Images and Text Wrapping
          1. Inserting an image into a document with columns
          2. Inserting an image into a document with text boxes
      2. Web Page Design
        1. Saving a Word Document as a Web Page
        2. Creating a Web Page from Scratch
          1. Creating your site’s home page
            1. Step 1: Set up a table
            2. Step 2: Create a header
            3. Step 3: Add a navigation bar
            4. Step 4: Add a footer
            5. Step 5: Save the page as a template
            6. Step 6: Adding text and images
        3. Creating More Pages for Your Site
    9. 9. Sharing and Collaborating on Documents
      1. Sharing a Document
        1. Emailing a Document
          1. Emailing a document as an attachment
          2. Emailing a link to a document
        2. Saving a Document to SkyDrive
        3. Saving a Document to SharePoint
      2. Adding Comments
        1. Inserting a Comment
        2. Viewing Comments
        3. Editing a Comment
        4. Deleting a Comment
      3. Tracking Changes
        1. Selecting Which Changes to View
        2. Accepting or Rejecting Changes
        3. Setting Track Changes Options
      4. Comparing Documents
      5. Combining Documents
      6. Protecting Your Documents
        1. Removing Hidden Data and Personal Information
        2. Restricting Formatting and Editing
        3. Restricting Permissions
      7. Coauthoring and Simultaneous Editing
  6. Two. Outlook
    1. 10. Getting Started with Outlook
      1. Setting Up Outlook
      2. Taking a Quick Look Around
        1. Mail
        2. Calendar
        3. Contacts
        4. Tasks
        5. Notes
      3. Composing and Sending Email
        1. Sending an Email to More Than One Recipient
        2. Proofreading a Message
        3. Attaching a File to an Email Message
        4. Inserting a Picture into an Email Message
        5. Adding a Signature
          1. Creating a signature
          2. Editing a signature
          3. Choosing a signature to add
          4. Deleting a signature
        6. Adding a Theme or Stationery
        7. Setting a Message’s Priority and Confidentiality
        8. Making Sure They Got the Message
        9. Setting a Delivery Time
        10. Directing Replies to Another Address
        11. Adding Voting Buttons
        12. Working Offline
      4. Receiving Email
        1. Replying to or Forwarding an Email
        2. Opening an Attachment
        3. Getting Notified
        4. Deleting a Message
        5. Marking a Message as Unread
        6. Flagging a Message
          1. Flagging a message you’ve received
          2. Flagging an outgoing message
          3. Finding flagged messages
        7. Organizing Messages
        8. Routing Incoming Messages
        9. Translating a Message
      5. Printing a Message
      6. Fighting Spam
        1. What If It’s Not Spam?
        2. Setting Up a Safe Senders List
        3. Managing Junk Email
      7. Saving Time with Quick Steps
        1. Applying a Quick Step
        2. Customizing a Quick Step
        3. Creating Your Own Quick Step
        4. Deleting a Quick Step
      8. Managing Multiple Email Accounts
        1. Adding Another Email Account
        2. Keeping Accounts Straight
        3. Choosing Which Account to Send From
    2. 11. Outlook’s Address Book
      1. Adding and Editing Contacts
        1. Adding Contacts
          1. Creating a new contact from scratch
          2. Creating a new contact from an email message
        2. Importing Email Addresses from Another Program
          1. Importing from Outlook Express, Windows Mail, or Eudora
          2. Importing from another email program
        3. Editing a Contact’s Information
          1. Editing all fields
          2. Creating a new field
          3. Adding details
          4. Editing business cards
          5. Deleting a contact
      2. Finding a Contact
      3. Viewing Contacts
        1. Sorting and Grouping Contacts
          1. Sorting contacts
          2. Grouping contacts
        2. Customizing a View
        3. Saving a View
        4. Deleting a View
        5. The People Pane
      4. Communicating with a Contact
      5. Gathering Contacts into a Group
        1. Creating a Contact Group
        2. Sending Email to a Contact Group
        3. Managing a Contact Group
      6. Printing Your Contacts
    3. 12. Getting Organized with Folders
      1. Finding Folders in the Navigation Pane
      2. Creating a New Folder
      3. Filling Up and Managing Folders
        1. Copying a Folder
        2. Moving a Folder
        3. Renaming a Folder
        4. Deleting a Folder
      4. Categorizing Items
        1. Assigning a Category
        2. Creating a New Category
        3. Viewing Items by Category
        4. Clearing Categories
        5. Renaming a Category
      5. Customizing Views
        1. Customizing the Navigation Pane
        2. Customizing the Reading Pane
        3. Customizing the To-Do Bar
      6. Searching Folders
        1. Searching the Current Folder
        2. Repeating a Search
        3. Expanding Your Search
        4. Refining Your Search
        5. Doing an Advanced Search
        6. Changing Search Settings
      7. Cleaning Out Folders
        1. Archiving Old Data
          1. Setting up AutoArchive
          2. Adjusting AutoArchive settings for a specific folder
          3. Archiving manually
        2. Cleaning up Your Mailbox
    4. 13. Getting Organized with Outlook’s Calendar, Tasks, and Notes
      1. Your Schedule, Your Calendar
      2. Creating an Appointment or Meeting
        1. Scheduling an Appointment
        2. Setting up a Meeting
        3. Accepting an Invitation to a Meeting
        4. Adding or Removing Attendees
        5. Keeping Track of Who’s Attending
        6. Canceling a Meeting
      3. Editing Events
        1. Turning an Appointment into a Meeting
        2. Making an Event Recur
        3. Getting Reminders
        4. Deleting an Appointment
      4. Viewing Your Schedule
      5. Tasks
      6. Adding a Task
        1. Creating a Task
          1. Creating a recurring task
          2. Assigning a task
        2. Accepting a Task
      7. Managing Tasks
        1. Editing a Task
        2. Flagging Tasks
        3. Marking a Task as Completed
      8. Viewing Tasks
      9. Taking Notes in Outlook
        1. Adding a Note
        2. Working with Notes
        3. Viewing Notes
          1. Icon view
          2. Notes List view
          3. Last 7 Days view
  7. Three. Excel
    1. 14. Creating Your First Spreadsheet
      1. Creating a Basic Worksheet
        1. Starting a New Workbook
        2. Adding the Column Titles
        3. Adding Data
        4. Editing Data
      2. Moving Around the Grid
        1. Shortcut Keys
        2. The Go To Feature
      3. A Tour of the Excel Window
        1. The Tabs of the Ribbon
        2. The Formula Bar
        3. The Status Bar
        4. Going Backstage
        5. Excel Options
      4. Saving Files
        1. The Excel File Format
        2. Preparing Your Spreadsheet for Excel 2007
        3. Saving Your Spreadsheet for Excel 2003
        4. Saving a Spreadsheet in Other Formats
        5. Saving Your Spreadsheet As a PDF
        6. Saving Your Spreadsheet with a Password
        7. Disaster Recovery
          1. AutoRecover settings
      5. Opening Files
        1. Opening Recent Documents
        2. Protected View
        3. Opening Files—with a Twist
        4. Opening Multiple Spreadsheets at Once
      6. Adding Different Types of Data
        1. How Excel Identifies Text
        2. How Excel Identifies Numbers
        3. How Excel Identifies Dates and Times
        4. Regional Dating
      7. Printing
        1. How to Print an Excel File
        2. Page Layout View: A Better Print Preview
        3. Creating Headers and Footers
      8. Controlling Pagination
        1. Page Breaks
        2. Scaling
        3. Page Break Preview: A Bird’s-Eye View of Your Worksheet
    2. 15. Moving Data and Managing Worksheets
      1. Selecting Cells
        1. Making Continuous Range Selections
        2. Making Noncontiguous Selections
        3. Automatically Selecting Your Data
        4. Making Selections with the Keyboard
      2. Moving Cells Around
        1. A Simple Cut-and-Paste or Copy-and-Paste
        2. A Quicker Cut-and-Paste or Copy-and-Paste
        3. Fancy Pasting Tricks
        4. Paste Special
      3. Adding and Moving Columns or Rows
        1. Inserting Columns
        2. Inserting Rows
        3. Inserting Copied or Cut Cells
        4. Deleting Columns and Rows
      4. Worksheets and Workbooks
        1. Adding and Removing Worksheets
        2. Hiding Worksheets
        3. Naming and Rearranging Worksheets
        4. Moving Worksheets from one Workbook to Another
    3. 16. Formatting Cells
      1. Formatting Cell Values
        1. Changing the Cell Value Format
        2. Formatting Numbers
          1. General
          2. Number
          3. Currency
          4. Accounting
          5. Percentage
          6. Fraction
          7. Scientific
          8. Text
        3. Formatting Dates and Times
        4. Special Formats for Special Numbers
      2. Formatting Cell Appearance
        1. Alignment and Orientation
        2. Fonts and Color
          1. Special characters
        3. Borders and Fills
    4. 17. Building Basic Formulas
      1. Creating a Basic Formula
        1. Excel’s Order of Operations
        2. Cell References
        3. How Excel Formats Cells That Contain Cell References
      2. Functions
        1. Using a Function in a Formula
        2. Using Cell References with a Function
        3. Using Cell Ranges with a Function
        4. Excel Compatibility Functions
      3. Formula Errors
      4. Logical Operators
      5. Formula Shortcuts
        1. Point-and-Click Formula Creation
        2. Point-and-Click Formula Editing
        3. The Formulas Tab
        4. Using the Insert Function Button
      6. Copying Formulas
        1. Absolute Cell References
        2. Partially Fixed References
        3. Referring to Other Worksheets
    5. 18. A Function Sampler and Formula Troubleshooting
      1. Rounding Numbers
        1. ROUND(), ROUNDDOWN(), ROUNDUP(): Rounding Numbers
      2. Manipulating Text
        1. CONCATENATE(): Joining Strings of Text Together
        2. LEFT(), MID(), and RIGHT(): Copying Portions of a Text String
        3. TRIM() and CLEAN(): Removing Unwanted Spaces and Non-Printing Characters
        4. SUBSTITUTE(): Replacing One Sequence of Characters with Another
      3. Solving Formula Errors
        1. Step-by-Step Evaluation
        2. Tracing Precedents and Dependents
        3. Error Checking
    6. 19. Creating Charts
      1. Charting 101
        1. Embedded and Standalone Charts
        2. Creating a Chart with the Ribbon
        3. The Chart Tools Ribbon Tabs
      2. Basic Tasks with Charts
        1. Moving and Resizing a Chart
        2. Creating a Standalone Chart
        3. Editing and Adding to Chart Data
        4. Changing the Chart Type
        5. Printing Charts
          1. Embedded charts
          2. Standalone charts
      3. Practical Charting
        1. Charts with Multiple Series of Numbers
        2. Controlling the Data Excel Plots on the X-Axis
        3. Data That Uses a Date or Time Scale
        4. Non-Contiguous Chart Ranges
        5. Changing the Order of Your Data Series
        6. Changing the Way Excel Plots Blank Values
      4. Chart Types
        1. Column
        2. Bar
        3. Line
        4. Pie
        5. Area
      5. Chart Styles and Layouts
        1. Chart Styles
        2. Chart Layouts
      6. Adding Chart Elements
        1. Adding Titles
        2. Adding a Legend
        3. Adding Data Labels to a Series
        4. Adding Individual Data Labels
  8. Four. PowerPoint
    1. 20. Creating a Presentation
      1. Creating a New Presentation
        1. Creating a New Presentation from a Template
        2. Choosing a Theme
        3. Adding Text to a Slide
        4. Creating a New Slide
        5. Adding Content
        6. Deleting Content
      2. Saving a Presentation
      3. Opening an Existing Presentation
        1. Open a Recent Presentation from the Windows Start Menu
        2. Open a Recent Presentation in PowerPoint
        3. Open Any Saved Presentation in PowerPoint
      4. Adding Notes
      5. Viewing a Presentation
        1. Normal View
        2. Slide Sorter View
        3. Reading View
        4. Notes Page View
        5. Slide Show View
        6. Zooming In and Out
      6. Printing a Presentation
    2. 21. Editing Slides
      1. Editing Text
        1. Formatting Text
        2. Adjusting Character Spacing
        3. Positioning Text
        4. Formatting a Text Box
        5. Creating Lists
        6. Linking Text to a Web Page
        7. Checking Your Spelling
        8. Turning Text into WordArt
      2. Embedding Other Files in Slides
        1. Embedding an Existing File in a Slide
        2. Updating Links
        3. Creating a New Embedded File
      3. Adding Tables to Slides
        1. Inserting a Table
          1. Inserting a table when you add a new slide
          2. Inserting a table on an existing slide
          3. Insert a table using an Excel-style spreadsheet
          4. Drawing a table
        2. Adding Information to a Table
        3. Editing a Table
          1. Selecting all or part of a table
          2. Resizing a table
          3. Moving a table
          4. Changing a table’s style
      4. Adding Images to Slides
        1. Creating a Photo Album
          1. Setting up a photo album
          2. Editing a photo album
        2. Working with Shapes
          1. Inserting a shape
          2. Changing a shape’s size or position
          3. Adding text to a shape
          4. Formatting a shape
        3. Working with SmartArt
          1. Inserting SmartArt
          2. Converting text to SmartArt
          3. Adding a shape
          4. Reordering shapes
          5. Applying a different layout
          6. Adjusting a SmartArt graphic’s style
          7. Formatting shapes within a SmartArt graphic
          8. Rotating a SmartArt graphic
          9. Resizing a SmartArt graphic
        4. Working with Charts and Diagrams
          1. Creating a chart or diagram using Excel
          2. Creating a diagram using shapes
      5. Arranging Objects on a Slide
        1. Aligning Objects on a Slide
        2. Ordering Objects
        3. Grouping Objects
    3. 22. Editing a Presentation
      1. Copying, Rearranging, and Deleting Slides
        1. Copying a Slide
        2. Duplicating a Slide
        3. Inserting a Slide from a Different Presentation
        4. Rearranging Slides in a Presentation
        5. Deleting a Slide
        6. Hiding Slides
      2. Headers and Footers
        1. Time-Stamping Your Slides
        2. Adding a Footer to Your Slides
        3. Numbering Slides
        4. Adding a Header and Footer to Notes and Handouts
      3. Organizing Your Presentation with Sections
        1. Creating a Section
        2. Naming a Section
        3. Collapsing and Expanding Sections
        4. Moving a Section Within a Presentation
        5. Hiding All Slides Within a Section
        6. Removing a Section from a Presentation
      4. Navigating with Links and Action Buttons
        1. Inserting a Hyperlink to Another Slide
        2. Creating a Table of Contents for Your Presentation
        3. Linking to a Hidden Slide
        4. Inserting an Action Button
        5. Opening an Inserted File
      5. Slide Masters: Powerful Slide Blueprints
        1. Changing the Look of All Slides in Your Presentation
        2. Changing the Layout for a Particular Type of Slide
        3. Creating a New Layout
        4. Working with Masters for Handouts and Notes
          1. Modifying the handout master
          2. Modifying the notes master
      6. Collaborating with Others
        1. Adding and Reading Comments
          1. Inserting a comment
          2. Reading comments
          3. Editing a comment
          4. Hiding comments
          5. Deleting comments
        2. Comparing Versions of a Presentation
    4. 23. Adding Multimedia and Movement
      1. Putting Media Clips in a Presentation
        1. Adding Video from Your Hard Drive
        2. Adding Video from a Website
        3. Adding Animated Clip Art
        4. Adding Sound from Your Hard Drive
        5. Adding Clip Art Audio
        6. Recording Audio
        7. Formatting Video Clips
          1. Adjust brightness and contrast
          2. Add a frame or border
          3. Add effects
          4. Crop the player
        8. Formatting Audio Clips
        9. Editing Media Clips
          1. Using bookmarks
          2. Trimming a media clip
          3. Fading in and fading out
          4. Hide a clip until you want it to play
          5. Other media clip settings
      2. Animating Objects
        1. Animating an Object
        2. Changing an Animation
        3. Adjusting Effect Options
          1. Adding sound to an animation
          2. Dimming text
          3. Animating paragraphs and words
        4. Adding More Animation
        5. Creating a Motion Path
        6. Triggering an Animation
        7. Timing Animations
        8. Reordering Animations
        9. Removing an Animation
        10. Using the Animation Pane
        11. Animating Lists
          1. Adjusting animation for individual list items
          2. Giving subitems their own animation
          3. Animating a list as a single block of text
        12. Stacking Objects
        13. Animating SmartArt Graphics
      3. Creating Transitions Between Slides
        1. Adding a Transition
        2. Tweaking Transition Effects
        3. Adding Sound to a Transition
        4. Timing Transitions
    5. 24. It’s Showtime! Giving a Presentation
      1. Start, Navigate, End: Tips and Shortcuts
        1. Starting a Slideshow
        2. Moving From Slide to Slide
        3. Ending a Slideshow
      2. Before the Show: Prep Work
        1. Adding Narration to Your Presentation
          1. Recording a narration
          2. Playing back a narrated slideshow
          3. Turning off narration
        2. Creating a Custom Slideshow
        3. Creating a Handout
        4. Setting Up Your Show
          1. Following your notes in Presenter view
      3. At the Event
        1. Settings to Check
        2. Launching a Slideshow
        3. During the Show
          1. Hiding or showing the pointer
          2. Marking up slides
          3. Changing markup color
          4. Erasing markup
          5. Making the mouse pointer a laser pointer
          6. Making the screen go blank
          7. Switching to another program (and back)
        4. Ending the Show
      4. Other Presentation Options
        1. Broadcasting a Slideshow
        2. Creating a Slideshow that Runs by Itself
        3. Creating an Interactive Slideshow
        4. Turning Your Presentation into a Video
      5. Sharing Your Presentation
        1. Packaging Your Presentation on a CD or DVD
  9. Five. Access
    1. 25. Creating Your First Database
      1. Understanding Access Databases
      2. Getting Started with Your First Database
        1. Understanding Tables
        2. Creating a Simple Table
        3. Editing a Table
          1. Edit mode
          2. Datasheet shortcut keys
          3. Cut, copy, and paste
      3. Saving Databases
        1. Making Backups
        2. Saving a Database with a Different Name or Format
      4. Opening Databases
        1. Designating a Database as Trusted
        2. Opening Recent Databases
        3. Opening More Than One Database at Once
      5. The Navigation Pane
        1. Browsing Tables with the Navigation Pane
        2. Managing Database Objects
    2. 26. Building Smarter Tables
      1. Understanding Data Types
      2. Design View
        1. Organizing and Describing Your Fields
        2. How Updates Work in Design View
      3. Access Data Types
        1. Text
          1. Text length
        2. Memo
          1. Formatted text
        3. Number
          1. Number size
          2. Number formatting
        4. Currency
        5. Date/Time
          1. Custom date formats
        6. Yes/No
        7. Hyperlink
        8. Attachment
        9. AutoNumber
          1. Using AutoNumbers without revealing the size of your table
          2. Using replication IDs
        10. Calculated
      4. The Primary Key
        1. Creating Your Own Primary Key Field
      5. Six Principles of Database Design
        1. 1. Choose Good Field Names
        2. 2. Break Down Your Information
        3. 3. Include All the Details in One Place
        4. 4. Avoid Duplicating Information
        5. 5. Avoid Redundant Information
        6. 6. Include an ID Field
      6. Blocking Bad Data
      7. Data Integrity Basics
        1. Preventing Blank Fields
          1. Blank values and empty text
        2. Setting Default Values
        3. Preventing Duplicate Values with Indexes
          1. Multifield indexes
      8. Lookups
        1. Creating a Simple Lookup with Fixed Values
        2. Adding New Values to Your Lookup List
    3. 27. Mastering the Datasheet: Sorting, Searching, Filtering, and More
      1. Datasheet Customization
        1. Formatting the Datasheet
        2. Rearranging Columns
        3. Resizing Rows and Columns
        4. Hiding Columns
        5. Freezing Columns
      2. Datasheet Navigation
        1. Sorting
          1. Sorting on multiple fields
        2. Filtering
          1. Quick filters
          2. Filter by selection
          3. Filter by condition
        3. Searching
      3. Printing the Datasheet
        1. Print Preview
          1. Moving around the print preview
          2. Changing the page layout
        2. Fine-Tuning a Printout
    4. 28. Linking Tables with Relationships
      1. Relationship Basics
        1. Redundant Data vs. Related Data
        2. Matching Fields: The Relationship Link
        3. Linking with the ID Column
        4. The Parent-Child Relationship
      2. Using a Relationship
        1. Defining a Relationship
        2. Editing Relationships
        3. Referential Integrity
          1. Blank values for unlinked records
          2. Cascading deletes
          3. Cascading updates
        4. Navigating a Relationship
        5. Lookups with Related Tables
      3. More Exotic Relationships
        1. One-to-One Relationships
        2. Many-to-Many Relationships
          1. Junction tables
          2. Multi-value fields
  10. Six. Other Office Tools
    1. 29. Publisher
      1. Creating a New Publication
        1. Creating a Publication from a Template
        2. Creating a Publication from Scratch
        3. Viewing the Page
        4. Entering Text
        5. Inserting an Image
        6. Adding Pages
        7. Navigating Pages
        8. Saving a Publication
      2. Adding Text
        1. Editing and Formatting Text
          1. Aligning text within a text box
          2. Fitting text to a text box
          3. Adjusting hyphenation
          4. Working with character spacing
          5. Formatting text
          6. Adding some style to your text
        2. Inserting Your Business Information
        3. Flowing Text from One Box to Another
          1. Flowing text manually
          2. Connecting text boxes to autoflow text
        4. Flowing Text Around an Object
      3. Adding Pictures, Shapes, and Other Objects
        1. Formatting Objects
          1. Formatting pictures
          2. Formatting shapes and WordArt
        2. Stacking and Grouping Objects
      4. Designing and Laying Out Pages
        1. Setting up Your Pages
        2. Choosing a Color Scheme
        3. Choosing a Font Scheme
        4. Using Layout Guides
        5. Snapping an Object to a Guide
      5. Reviewing Your Design
      6. Printing a Publication
        1. Preparing a Publication for a Commercial Printer
    2. 30. OneNote
      1. What is OneNote?
        1. Getting Familiar with the OneNote Workspace
      2. Creating and Filling up a Notebook
        1. Adding Notes to a Page
          1. Typing a note
          2. Pasting in a note
          3. Drawing a note
          4. Inserting a screen clipping
          5. Recording audio and video notes
      3. Organizing a Notebook
        1. Working with Sections and Pages
          1. Moving a section
          2. Merging sections
          3. Moving a page
          4. Changing a page’s level
        2. Deleting Notebooks, Sections, and Pages
      4. Managing Individual Notes
        1. Writing Side Notes
        2. Linking a Note to its Source
        3. Tagging a Note
          1. Creating a custom tag
          2. Finding tagged notes
          3. Removing a tag
        4. Finding a Note
          1. Searching a page
          2. Changing the scope of your search
      5. Viewing Your Notebooks
      6. Sharing Notes
        1. Finding Changes Others Have Made
        2. Emailing a Page
      7. Using OneNote with Other Office Programs
        1. Using Linked Notes
          1. Viewing note links
          2. Removing links from linked notes
          3. Turning off linked notes
        2. Getting Office Files into OneNote
          1. Attaching a file to a note
          2. Inserting a copy of a file into OneNote
    3. 31. Office Web Apps
      1. Introducing Office on the Web
      2. Setting Up Office Web Apps
        1. Signing into SkyDrive
      3. Creating and Editing Files
        1. Saving a Web Apps File
      4. Working with Folders in SkyDrive
        1. Creating a Folder
        2. Viewing Files in a Folder
        3. Renaming a Folder
        4. Deleting a Folder
      5. Managing Files in SkyDrive
        1. Opening a File
        2. Uploading Files to SkyDrive from Your Computer
          1. Starting point: your SkyDrive page
          2. Starting point: a SkyDrive folder
          3. Starting point: an Office program
        3. Downloading Files from SkyDrive to Your Computer
        4. Move, Rename, Delete: File Management Tips
      6. Sharing Files
        1. Setting Permissions
          1. Making a shared folder private
          2. Sharing a private folder or changing a shared folder’s permissions
        2. Leaving Comments
        3. Simultaneous Editing in Excel
      7. Docs.com: Office Web Apps for Facebook
        1. Adding Docs
          1. Creating a doc from scratch
          2. Uploading a file from your computer
        2. Viewing Your Docs
        3. Editing a Doc
        4. Sharing a Doc
        5. Viewing Friends’ Docs
  11. Seven. Appendix
    1. A. Customizing Office 2010 Applications
      1. Customizing the Quick Access Toolbar
      2. Customizing the Ribbon
      3. Customizing the Status Bar
  12. Index
  13. About the Authors
  14. Colophon
  15. Copyright

Product information

  • Title: Office 2010: The Missing Manual
  • Author(s): Nancy Conner, Matthew MacDonald
  • Release date: July 2010
  • Publisher(s): O'Reilly Media, Inc.
  • ISBN: 9781449395919