Exploring Microsoft Office 2007 Volume 2 / Edition 1

Paperback (Print)
Buy Used
Buy Used from BN.com
$90.92
(Save 39%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $28.22
Usually ships in 1-2 business days
(Save 81%)
Other sellers (Paperback)
  • All (5) from $28.22   
  • Used (5) from $28.22   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$28.22
Seller since 2006

Feedback rating:

(61620)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Acceptable
Shows definite wear, and perhaps considerable marking on inside. 100% Money Back Guarantee. Shipped to over one million happy customers. Your purchase benefits world literacy!

Ships from: Mishawaka, IN

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$99.74
Seller since 2009

Feedback rating:

(1878)

Condition: Good
2007 Spiral-bound Good Books have varying amounts of wear and highlighting. Usually ships within 24 hours in quality packaging. Satisfaction guaranteed. This item may not ... include any CDs, Infotracs, Access cards or other supplementary material. Read more Show Less

Ships from: Lincoln, NE

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$112.25
Seller since 2009

Feedback rating:

(3542)

Condition: Good
Ships out same day or next business day via UPS (Priority Mail for AK/HI/APO/PO Boxes)! Used sticker and some writing and/or highlighting. Used books may not include working ... access code or dust jacket. Read more Show Less

Ships from: Columbia, MO

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$112.30
Seller since 2005

Feedback rating:

(49664)

Condition: Very Good
SHIPS FAST! via UPS(AK/HI Priority Mail) within 24 hrs/ used sticker/some hilite

Ships from: Columbia, MO

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$134.67
Seller since 2008

Feedback rating:

(18251)

Condition: Acceptable
Used, Acceptable Condition, may show signs of wear and previous use. Please allow 4-14 business days for delivery. 100% Money Back Guarantee, Over 1,000,000 customers served.

Ships from: Westminster, MD

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Close
Sort by

Overview

The Exploring series helps students master the "How and Why" of performing tasks in Office to gain a greater understanding of how to use the individual applications together to solve business problems. Exploring titles feature “Perfect pages” where every step of every hands-on exercise as well as every end-of-chapter problem begins on a new page and has its own screen shot to make it easier to follow. Each chapter contains Hands-on Exercises, Capstone Exercises, and Mini-Cases for practicing and reviewing skills acquired.

Exploring Microsoft Office 2007 Volume 2, 1/e covers intermediate and advanced-level features of Word, Excel, Access, and PowerPoint.

Ideal for anyone looking to advance their Microsoft Office skills.

Read More Show Less

Product Details

  • ISBN-13: 9780136130376
  • Publisher: Prentice Hall
  • Publication date: 9/13/2007
  • Series: Exploring
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 1296
  • Product dimensions: 9.34 (w) x 10.82 (h) x 1.61 (d)

Meet the Author

Dr. Robert T. Grauer

Dr. Robert T. Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he has been honored with the Outstanding Teacher Award in the School of Business. He is the vision behind the Exploring Series, which is about to sell its 3 millionth copy.

Dr. Grauer has written more than 50 books on programming and information systems. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels.

Dr. Grauer also has been a consultant to several major corporations including IBM and American Express. He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.

Judith Scheeren

Judith Scheeren is a professor of computer technology at Westmoreland County Community College in Youngwood, Pennsylvania where she received the Outstanding Teacher award. She holds an M.S.I.S. She holds an M.S. from the University of Pittsburgh and an advanced certificate in online teaching and learning from the University of California at Hayward. She has several years of experience in the computer industry with Fortune 500 companies. She has developed and written training materials for custom applications in both the public and private sectors. She also has written books on desktop publishing.

Maurie Wigman Lockley

Maurie Wigman Lockley teaches desktop applications and management information systems classes at the University of North Carolina Greensboro. She has been an instructor there since 1990.

She lives in a tiny piedmont North Carolina town with her husband, daughter, and two preschool-aged grandsons. She spends her free time playing with the boys, reading, camping, playing computer games, and singing. She serves on several not-for-profit boards and is active at her church.

Michelle Hulett

Michelle Hulett received a B.S. degree in CIS from the University of Arkansas and a M.B.A. from Missouri State University. She has worked for various organizations as a programmer, network administrator, computer literacy coordinator, and educator. She currently teaches computer literacy and Web design classes at Missouri State University.

When not teaching or writing, she enjoys flower gardening, traveling (Alaska and Hawaii are favorites), hiking, canoeing, and camping with her husband, John, and dog, Dakota.

Cynthia Krebs

Cynthia Krebs is a professor in the Digital Media Department at Utah Valley State College, where she has taught since 1988. In addition to teaching classes in basic computer proficiency using Microsoft Office, she teaches classes in business presentations, business graphics, and an introduction to multimedia. She has received the Teacher-of-the-Year Award in the School of Business twice during her tenure at UVSC.

She has written chapters for many texts, co-authored a text on advanced word processing, and has presented locally and nationally. A graduate of Utah State University, Cynthia lives in Springville, Utah.

She has four children and one granddaughter. When she isn’t teaching or writing, she enjoys spending time with her children and spoiling her granddaughter.

Read More Show Less

Table of Contents

Exploring Microsoft Office Word 2007 Comprehensive

Chapter 5 - Advanced Features: Wizards, Templates, and Mail Merge

Section 1 Automated Features

Using shortcuts

Hands-On Exercise #1: Using a Wizard

Section 2 Mail Merge

Creating Form Letters

Hands-On Exercise #2: Using the Mail Merge Wizard

Section 3 Merge with External Source Data

Merging with Excel and Access Data

Hands-On Exercise #3: Merge with External Source Data

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 6 - Desktop Publishing: Creating a Newsletter and Other Documents

Section 1 Introduction to Desktop Publishing

The Newsletter

Columns

Hands-On Exercise #1: Newspaper columns

Section 2 Elements of Graphic Design

The Grid

The Drawing Toolbar

Hands-On Exercise #2: Complete the Newsletter

Section 3 Object Linking and Embedding

Inserting Objects from other Applications

Hands-On Exercise #3: Object Linking and Embeddings

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 7 - The Expert User: Forms, Document Protection, and Macros

Section 1 Forms

Creating an Electronic form

Hands-On Exercise #1: Forms

Section 2 Protection and Authentication

Adding Security

Create an Electronic Stamp of Authenticity

Hands-On Exercise #2: Secure a document and add a digital signature

Section 3 Automating Word

Introduction to Macros

Hands-On Exercise #3: Introduction to Macros

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 8 - Introduction to xHTML: Creating a Home Page and a Web Site

Section 1 Online Resources

Microsoft Word and the Internet

Hands-On Exercise #1: Microsoft Word and the World Wide Web

Section 2 Creating a Home Page

Using Word to Create a Web Page

Developing a Web Site

Hands-On Exercise #2: World Wide Travel Home Page

Section 3 Introduction to

Extensible Markup Language

Hands-On Exercise #3 Introduction to

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Exploring Microsoft Office Excel 2007 Comprehensive

Chapter 5 - Convert Data to Information

Section 1 Table Management

Exploring Table and Data Theory

Working with a Table Form

Importing Text

Hands-on Exercise 1: Import Data and Maintain a List

Section 2 Data Management

Defining Data and Information

Hands-on Exercise 2: Data Versus Information

Section 3 Data Analysis

Exploring Pivot Tables and Pivot Charts

Hands-on Exercise 3: Pivot Tables and Pivot Charts

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 6 - Consolidate Data and Link Files

Section 1 Data Consolidation

Consolidating Data from multiple Worksheets

Defining the Three-Dimensional Workbook

Hands-on Exercise 1: Copy Worksheets

Section 2 Worksheet 3-D References

Working with 3-D Refernces

Hands-on Exercise 2: Worksheet References

Section 3 Workbook Linking and Documentation

Linking Workbooks

Creating the Cover Sheet

Hands-on Exercise 3: Linking and Documentation

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 7 - What-IF Analysis—Forecasting and Amortization

Section 1 Financial Analysis

Defining Forecasting

Using Scenario Manager

Solving Problems with Goal Seek

Hands-on Exercise 1: The Financial Forecast

Section 2 Functions for Amortization Table

Working with Functions

Using Name Manager

Hands-on Exercise 2: The Amortization Schedule

Section 3 Workgroups and Auditing

Validating Data

Auditing Formulas

Setting up a Watch Window

Hands-on Exercise 3: Auditing

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 8 - Templates, Themes, and Web Pages

Section 1 Worksheet Automation

Working with Existing Templates, Themes, and Styles

Creating a Template

Using Styles for Advanced Formatting

Hands-on Exercise 1: Creating a Template

Section 2 Web Pages

Creating a Web page

Hands-on Exercise 2: Creating a Web Page

Section 3 Web Queries and Web Data

Creating Web Queries

Hands-on Exercise 3: Web Queries

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 9 - Collaboration and Macros

Section 1 Excel Collaboration

Sharing Data

Copying to Word

Copying to Power Point

Hands-on Exercise 1:

Section 2 Repetitive Tasks

Working with Macros

Hands-on Exercise 2:

Summary

Key Terms

Practice Exercises

Mid-Level Exercises

Capstone Project

Mini Cases

Chapter 10 - Data Analysis—A Capstone Chapter

Section 1 Drowning in Data

The Admissions Office

Hands-on Exercise 1: Case Relevant Scenario

Section 2 The Case Worksheet

Hands-on Exercise 2: Case Relevant Scenario

Section 3 The Case Worksheet

Hands-on Exercise 3: Case Relevant Scenario

Section 4 The Case Worksheet

Hands-on Exercise 4: Case Relevant Scenario

Exploring Microsoft Access 2007 Comprehensive

Chapter 5 — Sub-reports, More Query Types, Pivot Tables and Charts

Section 1 Pivot Tables

Creating Pivot Tables

Hands-on Exercise 1: Pivot Tables

Section 2 Pivot Charts

Recognizing Good Chart Design

Creating Pivot Charts

Editing Pivot Charts

Hands-on Exercise 2: Pivot Charts

Section 3 Interactive Pivots

Creating Multiple Pivots

Hands-on Exercise 3: Interactive Pivots

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 6 — Data Protection — Working with Data Integrity

Section 1 Protecting Table Data

Creating a table validation rule

Hands-on Exercise 1: Data Validation

Section 2 Understanding the need for forms

Planning the form

Selecting and modifying Controls

Hands-on Exercise 2: Form Creation

Section 3 - Advanced Forms

Creating a calculated control in a form

Adding a sub form

Hands-on Exercise 3: Advanced Forms

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 7 — Database Maintenance — Creating Advanced Queries

Section 1 Maintenance Query Types

Creating a Make Table Query

Creating an Append Query

Creating a Delete Query

Creating an Update Query

Hands-on Exercise 1: Creating Maintenance Queries

Section 2 Advanced Queries

Crosstab Queries

Using Table Field Indexes

Hands-On Exercise 2: Cross tabbing and Indexing

Section 3 Housekeeping

Setting the database to compact automatically

Converting a database to previous Access versions

Hands-on Exercise 3: Maintenance

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 8 — Integrating Access with the Internet

Section 1 Access and the Web

Creating a Hyperlinked Field

Inserting Hyperlinks to a File or Web Page

Linking to an E-mail Address

Hands-on Exercise 1: Getting Connected

Section 2 Access and the Web

Exporting database objects as an HTML document

Importing or Linking to an HTML File

Viewing a Data Access Page

Hands-on Exercise 2:

Section 3 Access and Excel

Creating Data for Excel Users

Hands-on Exercise 3:

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 9 — Bulletproofing the Database

Section 1 Data Protection

Analyzing Database performance

Managing and Securing the Data

Using Performance Analyzer

Using the Linked Table Manager

Creating a database Replica

Synchronizing the design and replica

Hands-on Exercise 1: Performance Measurements

Section 2 Helping Database Users

Creating a user interface

Creating a switchboard

Creating a dialog box

Adding command buttons

Viewing and testing a switchboard

Hands-on Exercise 2: Switchboards and Commands

Section 3 Splits and Security

Splitting a database

Encrypting the data

Establishing User-level security

Testing security levels

Normalizing a Database

Hands-on Exercise 3: Split Database and User Securities

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Chapter 10 - Customizing a database with programming languages

Section 1

Using SQL

Viewing SQU statements in a query

Modifying a SQL statement

Section 2

Using VBA

Introducing Events

Working with procedures

Creating Modules

Displaying an Event Procedure

Testing a procedure in an intermediate window

Creating Class modules

Summary

Key Terms

Multiple Choice

Practice Exercises

Mid-Level Exercises

Capstone Exercise

Mini Cases

Exploring Microsoft Office PowerPoint 2007 Comprehensive

Chapter 5 — Working with Charts and Graphs

Text-based Charts

Basic Statistical Charts and Graphs

Advanced Statistical Charts and Graphs

Hands-on Exercises 1-4

Capstone Exercise

Mini-Cases 1-3

(Content Application, Disaster Recovery, Research)

Chapter 6 — Customizing a Slideshow

Masters

Color Schemes

Custom Template

Custom Animation

Create a Custom Show

Hidden Slides

Macros

Hands-on Exercises 1-4

Capstone Exercise

Mini-Cases 1-3

(Content Application, Disaster Recovery, Research)

Chapter 7 — Saving a Web Page and Adding Interactivity

Hyperlinks

Buttons

Web Pages

Hands-on Exercises 1-4

Capstone Exercise

Mini-Cases 1-3

(Content Application, Disaster Recovery, Research)

Chapter 8 — Collaborating with Others

Comments

Merge and Compare

Package for CD

Broadcast

Hands-on Exercises 1-4

Capstone Exercise

Mini-Cases 1-3

(Content Application, Disaster Recovery, Research)

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)