You are previewing Office 2010 Made Simple.
O'Reilly logo
Office 2010 Made Simple

Book Description

Office 2010 Made Simple for Windows is a practical and highly effective approach to using the Office 2010 Home & Business (Word, Excel, PowerPoint, Outlook, OneNote) and Home & Student (Word, Excel, PowerPoint, OneNote) programs to create and edit documents and get work done efficiently. Conveying information quickly and concisely, the book brings you from a beginner or low intermediate to an experienced and confident user.

  • Illustrated graphical approach shows what happens at each stage

  • Short sections provide instant access to each task the reader needs to perform

  • Step-by-step instructions help the reader grasp even complex procedures in full confidence

  • What you'll learn

  • Master the Ribbon interface and become expert with keyboard shortcuts

  • Capture every important piece of information—and find it when you need it

  • Create attractive documents and powerful presentations

  • Process incoming mail automatically and keep your Inbox under control

  • Organize your work life with Outlook's appointments and tasks

  • Record and analyze your business data in simple databases

  • Who this book is for

    Beginning and intermediate users looking to get up to speed quickly with the Office 2010 applications and use them productively, both online and offline.

    Table of Contents

    1. Title Page
    2. Contents at a Glance
    3. Contents
    4. About the Author
    5. About the Technical Reviewer
    6. Acknowledgments
    7. Part I
      1. Quick Start Guide
        1. Logging On to Windows
        2. Locating the Office Programs and Launching Word
        3. Meeting the Major Components of the Word Window
        4. Closing a Document
        5. Creating and Saving a New Document
        6. Closing Word
        7. Where to Learn More
    8. Part II
      1. Introduction
        1. Who Is This Book For?
        2. What Does This Book Cover?
        3. Conventions Used in This Book
    9. Part III
      1. Chapter 1: Meeting the Office Programs and Learning What They Do
        1. Understanding the Office Programs
        2. Launching a Program
        3. Identifying the Standard Components of the Office Program Windows
        4. Creating, Saving, Closing, and Reopening Files
        5. Closing a Program
        6. Summary
      2. Chapter 2: Using the Ribbon, Backstage, and Common Tools
        1. Using the Ribbon
        2. Using Backstage View
        3. Entering Text Faster Using AutoCorrect
        4. Checking Spelling and Grammar in Your Files
        5. Printing Your Documents
        6. Summary
      3. Chapter 3: Working with Text
        1. Entering Text in Your Documents
        2. Navigating with the Keyboard and Selecting Document Objects
        3. Applying Direct Formatting to Text and Objects
        4. Using Cut, Copy, and Paste
        5. Using Find and Replace
        6. Laying Out Material with Tables
        7. Inserting Hyperlinks in Your Documents
        8. Summary
      4. Chapter 4: Using Graphics in Your Documents
        1. Understanding How You Position Graphical Objects in Documents
        2. Illustrating Your Documents with Clip Art Items
        3. Inserting Other Pictures in Your Documents
        4. Inserting Shapes in Your Documents
        5. Positioning Graphical Objects
        6. Wrapping Text Around Graphical Objects in Word and Outlook
        7. Making Your Pictures Look the Way You Want Them
        8. Creating Illustrations by Inserting SmartArt Graphics
        9. Arranging Graphical Objects to Control Which Are Visible
        10. Summary
      5. Chapter 5: Coauthoring in Real Time and Sharing Documents
        1. Working on Documents with Your Colleagues
        2. Coauthoring in Real Time
        3. Sharing Documents on a Network
        4. Working on Separate Copies of the Same Document
        5. Sharing Documents via E-mail, SkyDrive, and Electronic Documents
        6. Summary
      6. Chapter 6: Making the Office Programs Work Your Way
        1. Customizing the Quick Access Toolbar
        2. Customizing the Status Bar
        3. Customizing the Ribbon
        4. Creating Custom Keyboard Shortcuts in Word
        5. Setting Essential Options
        6. Summary
    10. Part IV
      1. Chapter 7: Entering and Editing Text in Your Documents
        1. Creating and Saving a New Document
        2. Entering Text in Your Word Documents
        3. Selecting Text and Navigating Through Your Documents
        4. Creating Your Own Templates
        5. Setting Word to Create Backup Documents Automatically
        6. Working the Smart Way by Using Views and Windows
        7. Navigating Your Documents Quickly with the Navigation Pane
        8. Summary
      2. Chapter 8: Formatting Your Documents Easily and Efficiently
        1. Why You Should Use Styles Rather Than Direct Formatting
        2. Applying Styles to a Document
        3. Creating Custom Styles
        4. Applying Direct Formatting on Top of Styles
        5. Summary
      3. Chapter 9: Adding Headers, Footers, Tables, and Columns
        1. Using Sections to Create Complex Layouts
        2. Adding Headers, Footers, and Page Numbers
        3. Adding Tables to Your Documents
        4. Creating Newspaper-Style Columns of Text
        5. Summary
      4. Chapter 10: Revising, Finalizing, and Printing Your Documents
        1. Revising a Document
        2. Finalizing a Document
        3. Printing Your Documents
        4. Summary
    11. Part V
      1. Chapter 11: Creating Workbooks and Entering Data
        1. Creating and Saving a New Workbook
        2. Navigating the Excel Interface, Worksheets, and Workbooks
        3. Entering Data in Your Worksheets
        4. Inserting, Renaming, Deleting, and Rearranging Worksheets
        5. Displaying Worksheets the Way You Prefer to See Them
        6. Sharing Your Workbooks and Tracking Changes
        7. Summary
      2. Chapter 12: Editing Worksheets and Applying Formatting
        1. Working with Rows and Columns
        2. Formatting Cells and Ranges
        3. Formatting Quickly with Table Formatting and Styles
        4. Adding Headers and Footers to Your Worksheets
        5. Printing Your Excel Worksheets and Workbooks
        6. Summary
      3. Chapter 13: Performing Calculations with Formulas and Functions
        1. Understanding the Difference Between Formulas and Functions
        2. Referring to Cells and Ranges in Formulas and Functions
        3. Performing Custom Calculations by Creating Formulas
        4. Performing Standard Calculations by Inserting Functions
        5. Summary
      4. Chapter 14: Creating Charts to Present Your Data
        1. Learning the Essentials of Charts in Excel
        2. Creating, Laying Out, and Formatting a Chart
        3. Summary
      5. Chapter 15: Creating Databases and Solving Business Problems
        1. Creating Databases
        2. Resizing a Database
        3. Sorting a Database by One or More Fields
        4. Filtering a Database
        5. Solving Business Problems with Scenarios and Goal Seek
        6. Summary
    12. Part VI
      1. Chapter 16: Getting Up to Speed and Taking Notes
        1. Meeting the OneNote User Interface
        2. Working with Notebooks, Section Groups, Sections, and Pages
        3. Entering Notes on a Page
        4. Using Views, Windows, and Side Notes
        5. Summary
      2. Chapter 17: Searching, Protecting, and Synchronizing Your Notes
        1. Searching for Information in Your Notebooks
        2. Protecting Your Notes with Passwords
        3. Sharing an Existing Notebook
        4. Using Different Versions of Pages
        5. Summary
      3. Chapter 18: Customizing OneNote and Using It with Word, Excel, PowerPoint, and Outlook
        1. Choosing the Most Important Options for OneNote
        2. Recording Audio and Video into Your Notebooks
        3. Previewing and Printing Your Notebook Pages
        4. Using OneNote with the Other Office Programs
        5. Summary
    13. Part VII
      1. Chapter 19: Starting a Presentation
        1. Creating a Presentation
        2. Changing the Presentation's Theme, Colors, Fonts, and Effects
        3. Changing the Slide Size or Orientation
        4. Navigating the PowerPoint Window
        5. Adding, Deleting, and Rearranging Slides
        6. Add Content to a Slide
        7. Using Views to Work on Your Presentation
        8. Creating the Outline of a Presentation
        9. Organizing Your Slides into Sections
        10. Summary
      2. Chapter 20: Building Effective Slides for Your Presentation
        1. Planning the Slides in Your Presentation
        2. Choosing Slide Layouts to Suit the Contents
        3. Formatting Text on Your Slides
        4. Adding Tables, SmartArt, Charts, and Hyperlinks to Slides
        5. Summary
      3. Chapter 21: Giving a Presentation Life and Impact
        1. Adding Pictures to a Presentation
        2. Adding Movies and Sounds to a Presentation
        3. Adding Transitions to Slides
        4. Adding Animations to Slides
        5. Keeping Extra Information Up Your Sleeve with Hidden Slides
        6. Summary
      4. Chapter 22: Delivering a Presentation in Person or Online
        1. Preparing to Deliver a Presentation in Person
        2. Delivering a Presentation to a Live Audience
        3. Creating a Handout for a Presentation
        4. Recording Narration into a Presentation
        5. Exporting and Sharing a Presentation
        6. Summary
    14. Part VIII
      1. Chapter 23: Setting Up Outlook and Meeting the Interface
        1. Set Up Your E-mail Accounts in Outlook
        2. Changing the Default Settings for an E-mail Account
        3. Meeting the Outlook Interface
        4. Summary
      2. Chapter 24: Sending and Receiving E-mail
        1. Sending an E-mail Message
        2. Receiving and Reading Messages
        3. Sending and Receiving Attachments
        4. Replying to and Forwarding Messages
        5. Deleting, Storing, and Organizing Messages
        6. Adding Consistent Closings to Your Messages with Signatures
        7. Dealing with Spam
        8. Summary
      3. Chapter 25: Managing Your Contacts with Outlook
        1. Creating Contacts
        2. Working with Contacts
        3. Summary
      4. Chapter 26: Organizing Your Schedule, Tasks, and Notes
        1. Organizing Your Schedule with the Calendar
        2. Working with Tasks
        3. Taking Notes
        4. Summary
    15. Index