Office 2010 Simplified

by Shoup, Kate

• ISBN13: 9780470571941
• ISBN10: 0470571942
• Edition: 1st
• Format: Paperback
• Copyright: 2010-05-24
• Publisher: Visual

Summary

Demonstrates the software package's updated features while reviewing Word, Excel, PowerPoint, Access, Publisher, and Outlook fundamentals.

Author Biography

Freelance writer/editor Kate Shoup has authored 20 books and edited scores more. Recent titles include Windows 7 Digital Classroom, Teach Yourself VISUALLY Outlook 2007, Office 2007: Top 100 Simplified Tips & Tricks, and Internet Visual Quick Tips. When not working, Kate loves to ski (she was once nationally ranked), read, and ride her motorcycle — and she plays a mean game of 9-ball. Kate lives in Indianapolis with her daughter and their dog.

Table of Contents

Office Features

Office Basics

Start and Exit Office Applications

Navigate the Program Windows

Work with the Ribbon

Customize the Quick Access Toolbar

Find Help with Office

Working with Files

Create a New File

Save a File

Open a File

Print a File

Select Data

Cut, Copy, and Paste Data

View Multiple Files

Office Graphics Tools

Insert Clip Art

Insert a Picture

Resize and Move Objects

Rotate and Flip Objects

Crop a Picture

Add a Picture Effect

Make Image Corrections

Working with Office Files Online

Create a New Workspace

Upload a File to Office Live Workspace

Create a New File in Office Live Workspace

Edit a File in Office Live Workspace

Share a Workspace

View Shared Workspaces

Delete a File from Office Live Workspace

Make Color Adjustments

Apply Artistic Effects

Create a WordArt Object

Add SmartArt

Adding Text

Change Word's Views

Type and Edit Text

Insert Quick Parts

Insert Symbols

Create a Blog Post

Word

Formatting Text

Change the Font, Size, and Color

Align Text

Set Line Spacing

Indent Text

Set Tabs

Set Margins

Adding Extra Touches

Assign a Theme

Add Borders

Create Columns

Insert a Table

Apply Table Styles

Insert an Excel Spreadsheet

Add Headers and Footers

Insert Footnotes and Endnotes

Insert Page Numbers and Page Breaks

Mark Index Entries

Generate an Index

Generate a Table of Contents

Create a Bibliography

Reviewing Documents

Find and Replace Text

Scan Document Content

Check Spelling and Grammar

Work with AutoCorrect

Use Word's Thesaurus and Dictionary

Translate Text

Create Lists

Copy Formatting

Clear Formatting

Format with Styles

Apply a Template

Track and Review Document Changes

Compare Documents

Insert Comments

Building Spreadsheets

Enter Cell Data

Select Cells

Faster Data Entry with AutoFill

Turn On Text Wrapping

Center Data Across Columns

Adjust Cell Alignment

Change the Font and Size

Change Number Formats

Increase or Decrease Decimals

Add Borders

Format Data with Styles

Apply Conditional Formatting

Add Columns and Rows

Resize Columns and Rows

Freeze a Column or Row

Name a Range

Delete Data or Cells

Excel

Worksheet Basics

Add a Worksheet

Name a Worksheet

Change Page Setup Options

Move and Copy Worksheets

Delete a Worksheet

Find and Replace Data

Sort Data

Working with Formulas and Functions

Understanding Formulas

Create a Formula

Apply Absolute and Relative Cell References

Understanding Functions

Apply a Function

Total Cells with AutoSum

Audit a Worksheet for Errors

Add a Watch Window

Working with Charts

Create a Chart

Move and Resize Charts

Change the Chart Type

Change the Chart Style

Change the Chart Layout

Add Axis Titles

Format Chart Objects

Add Gridlines

Change the Chart Data

Use Sparklines to View Data Trends

Filter Data

Track and Review Worksheet Changes

Insert a Comment

Creating a Presentation

Create a Photo Album

Create a Presentation with a Template

Build a Blank Presentation

Change PowerPoint Views

Insert Slides

Change the Slide Layout

Create a Custom Layout

Populating Presentation Slides

Add and Edit Slide Text

Change the Font, Size, and Color

Apply a Theme

Set Line Spacing

Align Text

Add a Text Box to a Slide

Add a Table to a Slide

Add a Chart to a Slide

Add a Picture to a Slide

Add a Video Clip to a Slide

Move a Slide Object

Resize a Slide Object

PowerPoint

Assembling and Presenting a Slide Show

Reorganize Slides

Reuse a Slide

Define Slide Transitions

Add Animation Effects

Create a Custom Animation

Record Narration

Set Up a Slide Show

Create Speaker Notes

Rehearse a Slide Show

Run a Slide Show

Package Your Presentation on a CD

Access

Database Basics

Understanding Database Basics

Create a Database Based on a Template

Create a Blank Database

Create a New Table

Change Table Views

Add a Field to a Table

Delete a Field from a Table

Hide a Field in a Table

Move a Field in a Table

Create a Form

Change Form Views

Move a Field in a Form

Delete a Field in a Form

Apply a Database Theme

Adding, Finding, and Querying Data

Add a Record to a Table

Add a Record to a Form

Navigate Records in a Form

Search for a Record in a Form

Delete a Record from a Table

Delete a Record from a Form

Sort Records

Filter Records

Apply Conditional Formatting

Perform a Simple Query

Create a Report

Organizing with Outlook

View Outlook Components

Schedule an Appointment

Schedule a Recurring Appointment

Schedule an Event

Create a New Contact

Create a New Task

Add a Note

Organize Outlook Items

Perform an Instant Search

Customize the To-Do Bar

Outlook

E-mailing with Outlook

Compose and Send a Message

Send a File Attachment

Read an Incoming Message

Reply To or Forward a Message

Add a Sender to Your Outlook Contacts

Delete a Message

View Conversations

Clean Up a Conversation

Ignore a Conversation

Screen Junk E-mail

Create a Message Rule

Publisher

Publisher Basics

Create a Publication

Create a Blank Publication

Zoom In and Out

Add Text

Add a New Text Box

Add a Picture to a Publication

Fine-Tuning a Publication

Change the Font, Size, and Color

Apply a Text Effect

Change Text Alignment

Add a Border

Control Text Wrap

Link TextBoxes

Move and Resize Publication Objects

Edit the Background

Add a Building Block Object

Create a Building Block Object

OneNote

Taking Notes with OneNote

Navigate OneNote

Type and Draw Notes

Paste a Picture into OneNote

Attach Files to Notes

Insert a Screen Clipping

Record an Audio Note

Organizing and Sharing Notes

Create a New Notebook

Create a New Section

Create a New Page

Rename Sections and Pages

Group Sections

Search Notes

E-mail a Note Page

Convert Notes to PDF or XPS Format

Table of Contents provided by Publisher. All Rights Reserved.