Microsoft® Office 2010 Plain & Simple

Larger Cover

By Katherine Murray

Publisher: Microsoft Press

Released: June 2010

Pages: 448

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
1. No Computerspeak!
2. A Quick Overview
3. What's New in Office 2010?
4. A Few Assumptions
5. A Final Word (or Two)
Chapter 2 Working in Office 2010
1. What's What in Office 2010?
2. Using the Ribbon
3. Using Galleries and Lists
4. Using Shortcut Menus and Dialog Boxes
5. Using Only the Keyboard
6. Moving and Copying Content
7. Working with Backstage View
8. Getting Help
9. Saving Your Work
10. Office's File Formats
Chapter 3 Common Tasks in Office
1. Working with Old Documents
2. Inserting Pictures
3. Changing the Size of a Picture
4. Editing a Picture
5. Enhancing Your Pictures
6. Making Your Pictures Pop
7. Adding Clip Art
8. Inserting Screenshots
9. Adding Shapes
10. Formatting a Shape
11. Inserting the Date and Time
12. Creating Stylized Text
13. Inserting a SmartArt Diagram
14. Translating Your Text
15. Researching a Subject
Chapter 4 Viewing and Editing Text in Word
1. What's Where in Word 2010?
2. Creating a New Document
3. Composing Different Types of Documents
4. Word's Views
5. Reading a Document
6. Editing Text
7. Discovering the Many Ways to Work with Text
8. Navigating Your Document
9. Replacing Text
10. Correcting Your Spelling and Grammar
11. Correcting Text Automatically
12. Adding Page Numbers
13. Co-Authoring in Word 2010
14. Marking and Reviewing Changes in a Document
15. Comparing Documents Side by Side
Chapter 5 Formatting in Word
1. Controlling the Look: Themes, Styles, and Fonts
2. Choosing a Theme for Your Document
3. Formatting Text with Styles
4. Choosing Styles from the Styles Window
5. Changing Character Fonts
6. Setting Paragraph Alignment
7. Adjusting Paragraph Line Spacing
8. Setting Spacing Between Paragraphs
9. Indenting a Paragraph
10. Formatting with Tabs
11. Adding Emphasis and Special Formatting
12. Copying Your Formatting
13. Creating a Bulleted or Numbered List
14. Formatting a List
15. Creating a Table from Scratch
16. Using a Predesigned Table
17. Creating a Table from Text
18. Adding or Deleting Rows and Columns
19. Formatting a Table
20. Improving the Layout with Hyphenation
21. Laying Out the Page
22. Creating Special Page Setups
23. Creating Headers and Footers
24. Changing Page Orientation Within a Document
25. Flowing Text into Columns
26. Creating Sections
27. Wrapping Text Around a Graphic
28. Sorting Your Information
29. Reorganizing a Document
Chapter 6 Working with Special Content in Word
1. Numbering Headings and Lines
2. Inserting a Cover Page
3. Inserting Information with Additional Actions
4. Inserting an Equation
5. Adding a Sidebar or a Pull Quote
6. Inserting a Watermark
7. Creating Footnotes and Endnotes
8. Inserting a Citation
9. Creating a Table of Contents
10. Printing an Envelope
11. Printing a Mailing Label
12. Mail Merge: The Power and the Pain
13. Creating a Form Letter
14. Finalizing Your Document
Chapter 7 Working in Excel
1. What's Where in Excel?
2. Excel 2010 Basics
3. Using a Predefined Workbook
4. Choosing a Theme for Your Worksheet
5. Entering the Data
6. Editing the Data
7. Formatting Cells
8. Formatting Numbers
9. Moving, Copying, and Pasting Data
10. Adding and Deleting Columns and Rows
11. Hiding Columns and Rows
12. Creating a Data Series
13. Formatting Cell Dimensions
14. Organizing Your Worksheets
15. Preparing for Printing
16. Printing a Worksheet
17. Adding and Viewing Comments
18. Working with the Excel Web App
Chapter 8 Analyzing and Presenting Data in Excel
1. Applying Conditional Formatting to Cells
2. Customizing Conditional Formatting
3. Cell References, Formulas, and Functions
4. Adding Sparklines
5. Introducing Formulas
6. Doing the Math
7. Summing the Data
8. Making Calculations with Functions
9. Creating a Series of Calculations
10. Troubleshooting Formulas
11. Creating a Table
12. Sorting the Data
13. Filtering the Data
14. Separating Data into Columns
15. Creating Subtotals
16. Summarizing the Data with a PivotTable
17. Adding Slicers
18. Reviewing the Data
19. The Anatomy of a Chart
20. Charting Your Data
21. Formatting a Chart
22. Customizing a Chart
Chapter 9 Creating a PowerPoint Presentation
1. What's Where in PowerPoint?
2. Creating a Presentation
3. Set the Page Background
4. Entering Content
5. Formatting a Slide
6. Editing a Presentation
7. Adding Headers and Footers
8. Reusing Slides
9. Modifying the Default Layout
10. Inserting a Table
11. Turning Text into SmartArt
12. Applying WordArt Styles to Text
13. Animating Items on a Slide
14. Customizing Your Animation
15. Adding an Action to a Slide
16. Adding and Editing Video
17. Adding Sound to Your Slides
18. Setting Slide Transitions
19. Creating a Photo Album
Chapter 10 Presenting a PowerPoint Slide Show
1. Exploring Your Presentation Options
2. Recording a Narration
3. Timing a Presentation
4. Adding Speaker Notes
5. Customizing the Presentation
6. Reviewing a Presentation
7. Creating Different Versions of a Slide Show
8. Printing Handouts
9. Running a Slide Show
10. Sharing a Presentation
11. Publishing Your Slides
12. Packaging Your Presentation
13. Creating Pictures of Your Slides
14. Saving Your Presentation as a Video
15. Broadcasting Your Presentation
16. Changing Slide-Show Settings
Chapter 11 Working with Messages in Outlook
1. What's Where in Outlook Messages?
2. Sending E-mail
3. Receiving and Reading E-mail
4. Replying to and Forwarding a Message
5. Staying in Touch with Outlook Social Connector
6. Sending or Receiving a File
7. Formatting E-mail Messages
8. Managing Messages with Quick Steps
9. Signing Your E-mail
10. Reading RSS Items
11. Setting Up E-mail Accounts
Chapter 12 Organizing with Outlook
1. A Quick Look at Outlook's Organizing Abilities
2. Setting an Appointment
3. Keeping Track of Your Schedule
4. Sharing Calendars
5. Viewing Your Group's Schedule
6. Scheduling a Meeting
7. Managing Your Contacts
8. Keeping Track of Your Tasks
9. Assigning Tasks
10. Tacking Up Notes
11. Creating and E-mailing Contact Business Cards
Chapter 13 Creating a Publication in Publisher
1. Exploring the New Look of Publisher 2010
2. Starting with a Template
3. Creating a Publication from Scratch
4. Adding Text
5. Flowing Text Among Text Boxes
6. Tweaking Your Text
7. Inserting and Modifying a Picture
8. Adding a Table
9. Repeating Objects on Every Page
10. Adding Building Blocks
11. Arranging Objects on the Page
12. Stacking and Grouping Objects
13. Flowing Text Around an Object
14. Reusing Content
15. Inserting Your Contact Information
16. Checking Your Publication
17. Sending a Publication as E-mail
18. Printing Your Publication
Chapter 14 Organize and Share Information in OneNote 2010
1. What's Where in OneNote?
2. OneNote Basics: Gathering Your Thoughts
3. Creating a OneNote Notebook
4. Adding and Working with Sections
5. Inserting and Working with Notes Pages
6. Inking in OneNote
7. Adding Audio Notes
8. Grabbing Web Clippings
9. Sharing Notes in Word and PowerPoint
10. Saving Outlook Data to OneNote
11. Working with Side Notes and Unfiled Notes
Chapter 15 Working in Access
1. What's Where in Access?
2. Databases: A Simple Approach
3. Creating a Database from a Template
4. Using an Existing Database
5. Adding a Data Table
6. Adding and Changing Fields and Records
7. Adding Data to a Table
8. Importing Data
9. Exporting Data
10. Defining Table Relationships
11. Creating a Form
12. Creating a Report from the Data
13. Formatting Reports
14. Querying Information from Your Data Tables
15. Analyzing Data with a PivotChart
Chapter 16 Customizing and Securing Office
1. Customizing the Ribbon
2. Customizing the Quick Access Toolbar
3. Customizing the Work Area
4. Customizing Your Editing
5. Changing Your User Information
6. Customizing the Spelling and Grammar Checkers
7. Customizing Your Spelling Dictionaries
8. Changing the Location and Type of Saved Files
9. Understanding Security in Office 2010
10. Changing File Validation
11. Choosing What's Displayed in Protected View
12. Password Protecting a File
13. Limiting File Changes
14. Recovering Unsaved Versions of a File
15. Setting AutoRecover Options
16. Signing a Document or Workbook with a Digital Signature
17. Setting Macros, Add-Ins, and ActiveX Controls
18. Checking File Compatibility

Title:

Microsoft® Office 2010 Plain & Simple

By:

Katherine Murray

Publisher:

Microsoft Press

Formats:

Print
Ebook
Safari Books Online

Print:

June 2010

Ebook:

June 2010

Pages:

448

Print ISBN:

978-0-7356-2697-3

| ISBN 10:

0-7356-2697-9

Ebook ISBN:

978-0-7356-4751-0

| ISBN 10:

0-7356-4751-8

Description

Table of Contents

Product Details

About the Author

Recommended for You

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