Microsoft Office Professional 2010 Step by Step eBook

xiv Contents

What do you think of this book? We want to hear from you!

Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources

for you. To participate in a brief online survey, please visit:

• Part 2 Microsoft Word


• 3 Edit and Proofread Text
  
  
  • Making Text Changes.
    
    
    • Sidebar: About the Clipboard
    
    
    
    
  
  
  • Finding and Replacing Text.
  
  
  • Fine-Tuning Text
  
  
  • Correcting Spelling and Grammatical Errors
    
    
    • Sidebar: Viewing Document Statistics
    
    
    
    
  
  
  • Inserting Saved Text
    
    
    • Sidebar: Inserting One Document into Another.
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• 4 Change the Look of Text
  
  
  • Quickly Formatting Text.
  
  
  • Changing a Document’s Theme
  
  
  • Manually Changing the Look of Characters
    
    
    • Sidebar: Character Formatting and Case Considerations.
    
    
    
    
  
  
  • Manually Changing the Look of Paragraphs.
    
    
    • Sidebar: Finding and Replacing Formatting
    
    
    
    
  
  
  • Creating and Modifying Lists
    
    
    • Sidebar: Formatting Text as You Type
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• 5 Organize Information in Columns and Tables
  
  
  • Presenting Information in Columns
  
  
  • Creating Tabbed Lists.
  
  
  • Presenting Information in Tables
    
    
    • Sidebar: Performing Calculations in Tables.
    
    
    • Sidebar: Other Layout Options
    
    
    
    
  
  
  • Formatting Tables
    
    
    • Sidebar: Quick Tables
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• 6 Add Simple Graphic Elements Contents v
  
  
  • Inserting and Modifying Pictures.
    
    
    • Sidebar: About Clip Art.
    
    
    
    
  
  
  • Changing a Document’s Background.
  
  
  • Inserting Building Blocks
    
    
    • Sidebar: Drawing Text Boxes
    
    
    
    
  
  
  • Adding WordArt Text.
    
    
    • Sidebar: Formatting the First Letter of a Paragraph
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• 7 Preview, Print, and Distribute Documents
  
  
  • Previewing and Adjusting Page Layout.
  
  
  • Controlling What Appears on Each Page
  
  
  • Printing Documents
  
  
  • Preparing Documents for Electronic Distribution
  
  
  • Key Points.
  
  
  
  


• Part 3 Microsoft Excel


• 8 Set Up a Workbook
  
  
  • Creating Workbooks.
  
  
  • Modifying Workbooks
  
  
  • Modifying Worksheets.
  
  
  • Customizing the Excel 2010 Program Window
    
    
    • Zooming In on a Worksheet
    
    
    • Arranging Multiple Workbook Windows.
    
    
    • Adding Buttons to the Quick Access Toolbar.
    
    
    • Customizing the Ribbon.
    
    
    • Maximizing Usable Space in the Program Window.
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• 9 Work with Data and Excel Tables vi Contents
  
  
  • Entering and Revising Data
  
  
  • Moving Data Within a Workbook.
  
  
  • Finding and Replacing Data.
  
  
  • Correcting and Expanding Upon Worksheet Data
  
  
  • Defining Excel Tables
  
  
  • Key Points.
  
  
  
  


• 10 Perform Calculations on Data
  
  
  • Naming Groups of Data.
  
  
  • Creating Formulas to Calculate Values.
  
  
  • Summarizing Data That Meets Specific Conditions.
  
  
  • Finding and Correcting Errors in Calculations
  
  
  • Key Points.
  
  
  
  


• 11 Change Workbook Appearance
  
  
  • Formatting Cells.
  
  
  • Defining Styles.
  
  
  • Applying Workbook Themes and Excel Table Styles.
  
  
  • Making Numbers Easier to Read.
  
  
  • Changing the Appearance of Data Based on Its Value.
  
  
  • Adding Images to Worksheets
  
  
  • Key Points.
  
  
  
  


• 12 Focus on Specific Data by Using Filters
  
  
  • Limiting Data That Appears on Your Screen.
  
  
  • Manipulating Worksheet Data
    
    
    • Selecting List Rows at Random
    
    
    • Summarizing Worksheets with Hidden and Filtered Rows.
    
    
    • Finding Unique Values Within a Data Set
    
    
    
    
  
  
  • Defining Valid Sets of Values for Ranges of Cells.
  
  
  • Key Points.
  
  
  
  


• Part 4 Microsoft PowerPoint Contents vii


• 13 Work with Slides
  
  
  • Adding and Deleting Slides.
  
  
  • Adding Slides with Ready-Made Content.
    
    
    • Sidebar: Working with Slide Libraries.
    
    
    • Sidebar: Exporting Presentations as Outlines.
    
    
    
    
  
  
  • Dividing Presentations into Sections
  
  
  • Rearranging Slides and Sections.
  
  
  • Key Points.
  
  
  
  


• 14 Work with Slide Text
  
  
  • Entering Text in Placeholders
  
  
  • Adding Text Boxes.
    
    
    • Sidebar: Changing the Default Font for Text Boxes.
    
    
    
    
  
  
  • Editing Text.
    
    
    • Sidebar: About the Clipboard
    
    
    
    
  
  
  • Correcting and Sizing Text While Typing.
  
  
  • Checking Spelling and Choosing the Best Words
    
    
    • Sidebar: Researching Information and Translating Text
    
    
    
    
  
  
  • Finding and Replacing Text and Fonts.
  
  
  • Key Points.
  
  
  
  


• 15 Format Slides
  
  
  • Applying Themes.
  
  
  • Using Different Color and Font Schemes
  
  
  • Changing the Slide Background.
  
  
  • Changing the Look of Placeholders.
  
  
  • Changing the Alignment, Spacing, Size, and Look of Text.
    
    
    • Sidebar: Non–Color Scheme Colors.
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• 16 Add Simple Visual Enhancements viii Contents
  
  
  • Inserting Pictures and Clip Art Images.
  
  
  • Inserting Diagrams
    
    
    • Sidebar: Graphic Formats.
    
    
    • Sidebar: Converting Existing Bullet Points into Diagrams.
    
    
    
    
  
  
  • Inserting Charts.
  
  
  • Drawing Shapes.
    
    
    • Sidebar: Connecting Shapes
    
    
    
    
  
  
  • Adding Transitions.
  
  
  • Key Points.
  
  
  
  


• 17 Review and Deliver Presentations
  
  
  • Setting Up Presentations for Delivery
  
  
  • Previewing and Printing Presentations
  
  
  • Preparing Speaker Notes and Handouts.
    
    
    • Sidebar: Enhanced Handouts.
    
    
    
    
  
  
  • Finalizing Presentations
    
    
    • Sidebar: Setting Up Presenter View
    
    
    
    
  
  
  • Delivering Presentations.
  
  
  • Key Points.
  
  
  
  


• Part 5 Microsoft OneNote


• 18 Explore OneNote
  
  
  • Navigating in the OneNote Program Window.
    
    
    • Sidebar: Working with Multiple Notebooks
    
    
    
    
  
  
  • Working in the OneNote Program Window.
    
    
    • Working from the Ribbon and Quick Access Toolbar.
    
    
    • Working in the Backstage View.
    
    
    
    
  
  
  • Exploring OneNote in the Default Notebook.
  
  
  • Customizing OneNote
  
  
  • Key Points.
  
  
  
  


• 19 Create and Configure Notebooks Contents ix
  
  
  • Creating a Notebook for Use by One Person.
  
  
  • Creating a Notebook for Use by Multiple People
    
    
    • Sharing a New or Existing Notebook.
    
    
    • Managing a Shared Notebook
    
    
    
    
  
  
  • Creating Sections and Pages.
    
    
    • Creating Pages and Subpages.
    
    
    • Naming Sections and Pages
    
    
    • Creating Sections and Section Groups.
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• 20 Create and Organize Notes
  
  
  • Working with Note Containers.
  
  
  • Entering Content Directly onto a Page
    
    
    • Referencing External Files
    
    
    • Creating Handwritten Notes
    
    
    • Inserting Images
    
    
    • Formatting Notes, Pages, and Sections.
    
    
    • Sidebar: Tagging Content.
    
    
    
    
  
  
  • Sending Content to OneNote.
    
    
    • Collecting Screen Clippings.
    
    
    • Collecting Web Notes.
    
    
    • Sidebar: Inserting the Date and Time.
    
    
    
    
  
  
  • Capturing Audio and Video Notes.
    
    
    • Sidebar: Missing the OneNote Icon?
    
    
    
    
  
  
  • Taking Notes on the Side.
    
    
    • Sidebar: Collecting Information Outside of OneNote.
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• Part 6 Microsoft Outlook x Contents


• 21 Send and Receive E-Mail Messages
  
  
  • Creating and Sending Messages.
    
    
    • Addressing Messages
    
    
    • Troubleshooting Message Addressing.
    
    
    • Entering Content
    
    
    • Saving and Sending Messages
    
    
    • Sidebar: Managing Multiple Accounts.
    
    
    
    
  
  
  • Attaching Files to Messages
    
    
    • Sidebar: Troubleshooting File Types and Extensions.
    
    
    
    
  
  
  • Viewing Messages and Message Attachments.
    
    
    • Sidebar: Viewing Conversations
    
    
    
    
  
  
  • Configuring Reading Pane Behavior
    
    
    • Viewing Reading Pane Content.
    
    
    • Marking Messages as Read
    
    
    • Single Key Reading
    
    
    
    
  
  
  • Viewing Message Participant Information
    
    
    • Presence Icons
    
    
    • Contact Cards.
    
    
    • The People Pane
    
    
    • Sidebar: Troubleshooting the People Pane.
    
    
    
    
  
  
  • Responding to Messages.
  
  
  • Key Points.
    
    
    • Sidebar: Resending and Recalling Messages.
    
    
    
    
  
  
  
  


• 22 Store and Access Contact Information
  
  
  • Saving and Updating Contact Information.
    
    
    • Creating Contact Records.
    
    
    • Address Books
    
    
    • Sidebar: Dialing Rules.
    
    
    • Sidebar: Conforming to Address Standards
    
    
    
    
  
  
  • Communicating with Contacts
    
    
    • Initiating Communication from Contact Records.
    
    
    • Selecting Message Recipients from Address Books.
    
    
    
    
  
  
  • Displaying Different Views of Contact Records Contents xi
    
    
    • Sidebar: User-Defined Fields
    
    
    
    
  
  
  • Printing Contact Records.
  
  
  • Key Points.
  
  
  
  


• 23 Manage Scheduling
  
  
  • Scheduling and Changing Appointments.
    
    
    • Sidebar: Adding National Holidays to Your Calendar
    
    
    • Sidebar: Creating an Appointment from a Message.
    
    
    
    
  
  
  • Scheduling and Changing Events.
  
  
  • Scheduling Meetings
    
    
    • Sidebar: Updating and Canceling Meetings.
    
    
    
    
  
  
  • Responding to Meeting Requests.
  
  
  • Displaying Different Views of a Calendar
    
    
    • Views
    
    
    • Arrangements.
    
    
    • Using the Date Navigator.
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• 24 Track Tasks
  
  
  • Creating Tasks
    
    
    • Creating Tasks from Scratch.
    
    
    • Task Options.
    
    
    • Creating Tasks from Outlook Items
    
    
    
    
  
  
  • Updating Tasks.
  
  
  • Removing Tasks and Items from Task Lists
  
  
  • Managing Task Assignments.
    
    
    • Tasks You Assign to Others
    
    
    • Tasks Other People Assign to You.
    
    
    
    
  
  
  • Displaying Different Views of Tasks
    
    
    • Sidebar: Finding and Organizing Tasks
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• Part 7 Microsoft Access xii Contents


• 25 Explore an Access 2010 Database
  
  
  • Working in Access
    
    
    • Sidebar: Enabling Macros and Other Database Content.
    
    
    
    
  
  
  • Understanding Database Concepts
  
  
  • Exploring Tables.
    
    
    • Sidebar: Tabbed Pages vs. Overlapping Windows.
    
    
    
    
  
  
  • Exploring Forms.
  
  
  • Exploring Queries
  
  
  • Exploring Reports
  
  
  • Previewing and Printing Access Objects
  
  
  • Key Points.
  
  
  
  


• 26 Create Databases and Simple Tables
  
  
  • Creating Databases from Templates
    
    
    • Sidebar: Web Databases.
    
    
    
    
  
  
  • Creating Databases and Tables Manually
    
    
    • Sidebar: Database Design.
    
    
    
    
  
  
  • Manipulating Table Columns and Rows.
  
  
  • Refining Table Structure.
  
  
  • Creating Relationships Between Tables.
  
  
  • Key Points.
  
  
  
  


• 27 Create Simple Forms
  
  
  • Creating Forms by Using the Form Tool
  
  
  • Changing the Look of Forms.
  
  
  • Changing the Arrangement of Forms
  
  
  • Key Points.
  
  
  
  


• 28 Display Data Contents xiii
  
  
  • Sorting Information in Tables
    
    
    • Sidebar: How Access Sorts.
    
    
    
    
  
  
  • Filtering Information in Tables.
  
  
  • Filtering Information by Using Forms
    
    
    • Sidebar: Wildcards.
    
    
    
    
  
  
  • Locating Information That Matches Multiple Criteria.
    
    
    • Sidebar: Generating Reports
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• Part 8 Microsoft Publisher


• 29 Get Started with Publisher
  
  
  • Starting New Publications
    
    
    • Using Templates.
    
    
    • Sidebar: Custom Templates
    
    
    • Importing Word Documents.
    
    
    
    
  
  
  • Storing Personal and Company Information
  
  
  • Previewing and Printing Publications.
    
    
    • Checking Publications.
    
    
    • Working with Advanced Printer Settings.
    
    
    
    
  
  
  • Key Points.
  
  
  
  


• 30 Create Visual Interest
  
  
  • Working with Text Boxes
    
    
    • Manipulating Text Boxes
    
    
    • Formatting Text for Visual Impact
    
    
    
    
  
  
  • Working with WordArt.
  
  
  • Working with Graphics.
  
  
  • Working with Shapes
    
    
    • Manipulating Shapes.
    
    
    • Connecting and Grouping Shapes
    
    
    
    
  
  
  • Working with Ready-Made Visual Elements.
  
  
  • Key Points.
  
  
  
  


• 31 Create Colorful Cards and Calendars microsoft.com/learning/booksurvey
  
  
  • Creating Folded Cards
    
    
    • Choosing a Design or Layout.
    
    
    • Changing the Color Scheme
    
    
    • Using Non–Color-Scheme Colors.
    
    
    • Choosing Text.
    
    
    
    
  
  
  • Creating Postcards.
    
    
    • Using Mail Merge
    
    
    • Using Catalog Merge
    
    
    
    
  
  
  • Creating Calendars
    
    
    • Adding Captions, Credits, and Copyrights
    
    
    • Changing Page Backgrounds.
    
    
    • Working with Master Pages.
    
    
    
    
  
  
  • Key Points.
  
  
  • Index.
  
  
  • About the Authors.