Skills for Success Using Microsoft Office 2007

by Townsend, Kris

Edition:

1st

ISBN13:

9780135024560

ISBN10:

0135024560

Format:

Paperback

Pub. Date:

7/8/2008

Publisher(s):

Prentice Hall

Other versions by this Author

List Price: ~~$133.40~~

Rent Textbook

(Recommended)

Term

Due

Price

Short Term

Aug 2

$10.34

Semester

Dec 20

$66.70

Quarter

Sep 17

$60.03

$10.34

Buy Used Textbook

In Stock Usually Ships in 24 Hours.

$5.60

Buy New Textbook

Usually Ships in 3-5 Business Days

$130.07

eTextbook

180 day subscription

$65.99

More New and Used
from Private Sellers

Starting at $0.01

Questions About This Book?

Why should I rent this book?

Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.

How do rental returns work?

Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!

What version or edition is this?

This is the 1st edition with a publication date of 7/8/2008.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
The Used copy of this book is not guaranteed to inclue any supplemental materials. Typically, only the book itself is included.
The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.

Summary

Office 2007 is here! And the new release reflects the most extensive update to the Office suite in the last decade. Master the SKILLS of Office 2007 with Kris Townsend's SKILLS FOR SUCCESS Series for Word, Excel, PowerPoint, Outlook & Access 2007. Illustrated and bulleted, step-by-step instruction gives you the SKILLS you need to succeed with all the features and components of Office 2007.

Author Biography

Kris Townsend is an Information Systems instructor at Spokane Falls Community College in Spokane, Washington. Kris earned a bachelor's degree in both Education and Business, and a master's degre in Education. He has also worked as a public school teacher and as a systems analyst. Kris enjoys working with wood, snowboarding, and camping. He commutes to work by bike and enjoys long rides in the Palouse country south of Spokane.

Introduction
Start! Common Features of Office 2007
Explore Your Computer Using Folder Windows
Start Word and Navigate the Word Window
Start Excel and PowerPoint and Work with Multiple Windows
Create a Folder and Save Files
Print and Save Office Files
Open a Student Data File and Save a Copy Using Save As
Edit and Format Text
Use Contextual tabs, Dialog Boxes, and Shortcut Menus
Use Office Help
Create a New Access Database
More Skills
Capture a Screen with the Snipping Tool
Organize Files
Search and Preview Files
Delete and Restore Files
Word Chapter 1 Creating Documents with Word 2007
Create a New Document and Enter Text
Edit Text Using the Delete and Backspace Keys
Select, Delete, and Insert Text
Insert Text from another Document
Navigate a Document
Format the Font, Font Size, and Font Style
Insert a Picture
Check Spelling and Grammar
Create a Document Footer
Preview, Print, and Save a Document
More Skills
Split Windows and Arrange Windows
Insert Symbols
Use Quick Styles
Use Research Tools
Word Chapter 2 Format and Organize Text
Set Document Margins
Align Text and Set Indents
Modify Line and Paragraph Spacing
Format Text Using the Format Painter
Find and Replace Text
Cut, Copy, Paste, and Move Text
Create a Bulleted List
Create a Numbered List Using AutoFormat
Insert and Format Headers and Footers
Insert and Modify Footnotes
More Skills
Record AutoCorrect Entries
Add Citations and a Bibliography
Format and Customize Lists
Manage Document Properties
Word Chapter 3 Work with Graphics, Tabs, and Tables
Insert a Picture from a File
Resize and Move a Picture
Format Pictures Using Styles and Borders
Set Tab Stops
Enter Text with Tab Stops
Apply a Predefined Format to a Table
Create a Table
Add Rows and Columns to a Table
Format Text in Table Cells
Format a Table
More Skills
Insert a Text Box
Create a WordArt Title
Create a Table from an Existing List
Insert a Drop Cap
Word Chapter 4 Applying Special Text, Paragraph, and Document Formats
Collect Information using the Office Clipboard
Use the Office Clipboard to Build a Document
Create Multiple Column Text
Insert a Column Break
Add a Border and Shading to a Paragraph
Insert Hyperlinks to Text and Graphics
Insert a SmartArt Graphic
Format a SmartArt Graphic
Create Labels Using the Mail Merge Wizard
Preview and Print a Mail Merge Document
More Skills
Create a Resume from a Template
Create an Outline
Prepare a Document for Distribution
Preview and Save a Document as a Web Page
Excel Chapter 1 Create Workbooks with Excel 2007
Create and Save a New Workbook
Enter Worksheet Data and Merge and Center Titles
Adjust Column Widths and Format Cells
Use the SUM Function
Copy Formulas and Insert Columns
Format, Edit, and Check the Spelling of Data
Create a Column Chart
Format a Column Chart
Create a Footer Containing a Graphic
Display and Print Formulas and Scale a Worksheet for Printing
More Skills
Create a New Workbook by Using a Template
Change a Chart Type
Change the Office Theme in an Excel Workbook
Manage Document Properties in an Excel Workbook
Excel Chapter 2 Construct Formulas and Charts
Create a New Workbook from an Existing Workbook and Align Text
Construct Formulas for Mathematical Operations
Format Numbers
Construct and Copy Formulas Containing Absolute Cell References
Format Percentages and Insert Rows in a Worksheet Containing Formulas
Create a Pie Chart and a Chart Sheet
Format a Pie Chart with 3-D and Rotate Slices
Explode and Color a Pie Slice, Format the Chart Area, and Insert a Text Box
Edit a Workbook, Update a Chart, and Insert WordArt
Prepare a Chart Sheet for Printing
More Skills
Add and Edit Comments
Use Range Names in a Formula
Use the Payment (PMT) Function
Use Goal Seek
Excel Chapter 3 Manage Multiple Worksheets in a Workbook
Navigate, Rename, and Change the Tab Color of Worksheets
Enter and Format Dates
Clear Cells of Contents and Formats
Move, Copy, and Paste Cell Contents
Group Worksheets for Editing
Use More Than One Math Operator in a Formula
Edit and Format Multiple Worksheets
Insert and Move a Worksheet
Construct Formulas that Refer to Cells in Another Worksheet
Create a Clustered Bar Chart
More Skills
Add SmartArt Graphics to a Worksheet
Create a Line Chart
Set and Clear a Print Area
Create a Hyperlink in a Workbook
Excel Chapter 4 Use Excel Functions and Tables
Use the SUM and AVERAGE Functions
Use the MEDIAN, MIN, and MAX Functions
Move Data, Add Borders, and Rotate Text
Use the IF and COUNTIF Functions
Apply Conditional Formats With Custom Formats and Data Bars
Use Find and Replace and Insert the Date Function
Freeze and Unfreeze Panes
Create and Sort an Excel Table
Filter an Excel Table
Convert a Table to a Range of Data and Format a Large Worksheet
More Skills
Apply Conditional Formats by Using Color Scales, Icon Sets, and Top/Bottom Rules
Hide or Unhide Rows and Columns
Create PivotTable Reports
Use Auto Fill to Fill Data Automatically in Worksheet Cells
Access Chapter 1 Working with Database Management Systems
Open and Organize an Existing Database
Modify Table Data Using a Form
Modify a Query and Print the Results in a Report
Format a Datasheet and Modify Table Design
Modify Table Data and Use Find and Replace
Sort Table Data and Hide Datasheet Columns
Filter, Summarize, and Print a Datasheet
Create a Relational Database from a Template
Add Records to Related Tables
Format a Report in Layout View
More Skills
Compact and Repair a Database
Convert Databases to and from the 2002 - 2003 File Format
Work with the Attachment Data Type
Work with the Hyperlink and Yes/No Data Types
Access Chapter 2 Building a Relational Database and Creating Forms
Design a Relational Database and Build a Table in Datasheet View
Build a Table in Design View
Create Tables by Importing Data from Excel
Import Access Tables and Create an Input Mask
Create a Lookup Column
Relate Tables
Create a Many-to-Many Relationship
Create a Form Using the Form Tool
Create a Form and a Subform Using the Form Wizard
Modify a Form in Design View and Enter Records in a One-to-Many Form
More Skills
Set Field Properties to Validate Data
Create Indexes and Establish a One-to-One Relationship
Create a Multiple Items Form
Create and Format a Split Form
Access Chapter 3 Creating Queries and Reports
Use the Simple Query Wizard to Create a Query
Create a Labels Report Based on a Query
Create a Query with Numeric and Date Criteria
Create a Report Using the Report Wizard
Modify a Report in Design View and Add Summary Data
Format a Report in Layout View
Create a Parameter Query
Create a Report Based on a Parameter Query
Group, Sort, and Filter Records in a Report
Export Reports to Other File Formats
More Skills
Create a Crosstab Query
Export Data to Other Applications
Use a Query to Find Duplicate Data
Use a Query to Find Unmatched Data
Access Chapter 4 Designing Advanced Queries and Reports
Use Logical Operators in a Query
Create a Form Based on a Query
Group, Sort , and Add Wildcards to a Query Criteria
Add Calculated Fields to a Query
Add Summary Statistics to a Query
Create a Report with a Calculated Control in Design View
Format a Report in Design View
Create a Report Using the Blank Report Tool
Add a Chart to a Report
Customize the Navigation Pane
More Skills
Encrypt a Database File
Specify Relationship Join Types
Create Macros
Create a Switchboard
PowerPoint Chapter 1 Getting Started with PowerPoint 2007
Open, View, and Save a Presentation
Edit and Replace Text in Normal View
Format Slide Text
Check Spelling and Use the Thesaurus
Insert Slides and Modify Slide Layouts
Insert and Format Pictures
Organize Slides Using Slide Sorter View
Apply Slide Transitions and View a Slide Show
Insert Headers and Footers and Print Presentation Handouts
Add Speakers Notes and Print Notes Pages
More Skills
Type Text in the Outline Pane
Use Keyboard Shortcuts
Move and Delete Slides in Normal View
Design a Presentation for Audience and Location
PowerPoint Chapter 2 Format a Presentation
Create a New Presentation
Change the Presentation Theme
Apply Font and Color Themes
Format the Slide Background
Apply a Picture or Texture to the Slide Background
Format Text with WordArt
Change Character Spacing and Font Color
Modify Bulleted and Numbered Lists
Move and Copy Text and Objects
Use Format Painter and Clear All Formatting
More Skills
Edit the Slide Master
Save and Apply a Presentation Template
Create Slides from a Microsoft Word Outline
Design a Presentation with Contrast
PowerPoint Chapter 3 Enhance a Presentation with Graphics
Insert Slides from an Existing Presentation
Insert, Size, and Move Clip Art
Change Picture Shape and Apply Picture Effects and Borders
Insert, Size, and Move Shapes
Add Text to Shapes and Insert Text Boxes
Format, Group, and Align Shapes and Pictures
Insert a SmartArt Graphic
Modify SmartArt Layout, Color, and Style
Convert Text to a SmartArt Graphic
Add Shapes to a SmartArt Graphic
More Skills
Compress Pictures
Save a Group as a Picture
Change Object Order
Design a Presentation Using Appropriate Graphics
PowerPoint Chapter 4 Present Data using Tables, Charts, and Animation
Insert a Table
Modify Table Layout
Select and Align Table Text
Change the Table Style
Insert a Chart
Delete Chart data and Change the Chart Type
Format a Chart
Apply Animation to Text and Graphics
Set Animation Effect and Timing Options
Animate Objects using the Animate List
More Skills
Prepare a Presentation for Remote Delivery
Create a Photo Album
Insert Hyperlinks in a Presentation
Design a Presentation that includes a Custom Show
Table of Contents provided by Publisher. All Rights Reserved.