BN.com Gift Guide

Exploring Microsoft Office Excel 2010 Comprehensive

Paperback (Print)
Rent
Rent from BN.com
$23.07
(Save 83%)
Est. Return Date: 02/23/2015
Buy Used
Buy Used from BN.com
$84.44
(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 $1.99
Usually ships in 1-2 business days
(Save 98%)
Other sellers (Paperback)
  • All (35) from $1.99   
  • New (13) from $32.41   
  • Used (22) from $1.99   
Close
Sort by
Page 1 of 4
Showing 1 – 10 of 35 (4 pages)
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since 2007

Feedback rating:

(10157)

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
Millions of satisfied customers and climbing. Thriftbooks is the name you can trust, guaranteed. Spend Less. Read More.

Ships from: Auburn, WA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$2.00
Seller since 2002

Feedback rating:

(11867)

Condition: Acceptable
All text is legible, may contain markings, cover wear, loose/torn pages or staining and much writing. SKU:9780135098592-5-0

Ships from: Salem, OR

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$4.40
Seller since 2014

Feedback rating:

(17)

Condition: Acceptable
SPIRAL-BOUND Fair 0135098599 Poor physical shape and/or moderate to heavy markings/highlight but still readable! A GREAT VALUE PRICED BOOK! Same or next day processing! Choose ... EXPEDITED for super fast delivery! May or may not include CD or other supplemental materials. Read more Show Less

Ships from: Miami, FL

Usually ships in 1-2 business days

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

Feedback rating:

(1841)

Condition: Good
2010 Spiral-bound Good Books have varying amounts of wear and highlighting. CD is included. 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)
$6.25
Seller since 2014

Feedback rating:

(17)

Condition: Very Good
SPIRAL-BOUND Very Good 0135098599 GREAT shape! May have some minor physical wear, light to NO markings/highlights! Same or next day processing! Choose EXPEDITED for super fast ... delivery! May or may not include CD or other supplemental materials. Has CD. Read more Show Less

Ships from: Miami, FL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$7.50
Seller since 2014

Feedback rating:

(17)

Condition: Good
SPIRAL-BOUND Good 0135098599 Good to VERY GOOD physical shape and/or light to moderate markings/highlight! A great value priced book! Same or next day processing! Choose ... EXPEDITED for super fast delivery! May or may not include CD or other supplemental materials. Has CD. Read more Show Less

Ships from: Miami, FL

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$10.00
Seller since 2014

Feedback rating:

(5)

Condition: Good
2010 Spiral-bound Good Connecting readers with great books since 1972. Used books may not include companion materials, some shelf wear, may contain highlighting/notes, and may ... not include cd-rom or access codes. Customer service is our top priority! Read more Show Less

Ships from: Greenfield, WI

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$10.00
Seller since 2014

Feedback rating:

(933)

Condition: Very Good
With CD! Excellent Condition. No wear/tear. Please contact us if you have any Questions.

Ships from: Downingtown, PA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$10.99
Seller since 2006

Feedback rating:

(1187)

Condition: Good
2010-11-22 Spiral-bound Good We ship everyday and offer PRIORITY SHIPPING.

Ships from: malone, NY

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$17.10
Seller since 2014

Feedback rating:

(0)

Condition: Acceptable
2010 Spiral-bound Fair Ships same or next business day. We ship to APO/FPO. Choose Expedited shipping and receive in 1-5 business days.

Ships from: Morgantown, WV

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 4
Showing 1 – 10 of 35 (4 pages)
Close
Sort by

Overview

For introductory computer courses on Microsoft Office 2010 or courses in computer concepts with a lab component for Microsoft Office 2010 applications.

The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill. The Exploring series for Office 2010 also enables students to extend the learning beyond the classroom.

Students go to college now with a different set of skills than they did five years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everybody needs to know. A lot of learning takes place outside of the classroom, and the Exploring series provides learning tools that students can access anytime, anywhere.

The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill.

Read More Show Less

Product Details

Meet the Author

Dr. Robert T. Grauer, Creator of the Exploring Series

Bob Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in operations research in 1972 from the Polytechnic Institute of Brooklyn.

Dr. Keith Mulbery, Consulting Series Editor and Excel Author

Dr. Keith Mulbery is the Department Chair and an Associate Professor in the Information Systems and

Technology Department at Utah Valley University (UVU), where he teaches computer applications, C#

programming, systems analysis and design, and MIS classes. Keith also served as Interim Associate Dean,

School of Computing, in the College of Technology and Computing at UVU.

Keith received the Utah Valley State College Board of Trustees Award of Excellence in 2001, School of

Technology and Computing Scholar Award in 2007, and School of Technology and Computing Teaching

Award in 2008. He has authored more than 15 textbooks, served as Series Editor for the Exploring Office

2007 series, and served as developmental editor on two textbooks.

Keith received his B.S. and M.Ed. in Business Education from Southwestern Oklahoma State University

and earned his Ph.D. in Education with an emphasis in Business Information Systems at Utah State

University. His dissertation topic was computer-assisted instruction using Prentice Hall’s Train and Assess IT program to supplement traditional instruction in basic computer proficiency courses.

Mary Anne Poatsy, Series Editor

Mary Anne is a senior faculty member at Montgomery County Community College, teaching various

computer application and concepts courses in face-to-face and online environments. She holds a B.A.

in psychology and education from Mount Holyoke College and an M.B.A. in finance from Northwestern

University’s Kellogg Graduate School of Management.

Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at

Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks

County Community College and Muhlenberg College, as well as conducted professional training. Before

teaching, she was vice president at Shearson Lehman in the Municipal Bond Investment Banking

Department.

Dr. Lynn Hogan, Office Fundamentals and File Management and

Windows 7 Author

Lynn Hogan has taught in the Computer Information Systems area at Calhoun Community College for

29 years. She is the author of Practical Computing and has contributed chapters for several computer

applications textbooks. Primarily teaching in the areas of computer literacy and computer applications,

she was named Calhoun’s outstanding instructor in 2006. She received an M.B.A. from the University of

North Alabama and a Ph.D. from the University of Alabama. Lynn resides in Alabama with her husband

and two daughters.

Read More Show Less

Table of Contents

OFFICE FUNDAMENTALS AND FILE MANAGEMENT

CHAPTER ONE ¿ Office Fundamentals and File Management

CASE STUDY: RAILS AND TRAILS

OBJECTIVES

FILES AND FOLDERS

Using Windows Explorer

Working with Folders and Files

Selecting, Copying, and Moving Multiple Files and Folders

HANDS-ON EXERCISE 1: Files and Folders

MICROSOFT OFFICE SOFTWARE

Identifying Common Interface Components

Getting Office Help

HANDS-ON EXERCISE 2: Microsoft Office Software

BACKSTAGE VIEW TASKS

Opening a File

Printing a File

Closing a File and Application

HANDS-ON EXERCISE 3: Backstage View Tasks

HOME TAB TASKS

Selecting and Editing Text

Using the Clipboard Group Tasks

Using the Editing Group Tasks

HANDS-ON EXERCISE 4: Home Tab Tasks

INSERT TAB TASKS

Inserting Objects

REVIEW TAB TASKS

Reviewing a File

PAGE LAYOUT TAB TASKS

Changing Page Settings

HANDS-ON EXERCISE 5: Tasks on the Insert Tab, Page Layout Tab, and Review Tab

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

MICROSOFT OFFICE EXCEL 2010

CHAPTER ONE ¿ Introduction to Excel

CASE STUDY: OK OFFICE SYSTEMS

OBJECTIVES

INTRODUCTION TO SPREADSHEETS

Planning for Effective Workbook and Worksheet Design

Exploring the Excel Window

Entering and Editing Cell Data

HANDS-ON EXERCISE 1: Introduction to Spreadsheets

MATHEMATICS AND FORMULAS

Using Symbols and the Order of Precedence

Using Auto Fill

Displaying Cell Formulas

HANDS-ON EXERCISE 2: Mathematics and Formulas

WORKBOOK AND WORKSHEET MANAGEMENT

Managing Worksheets

Managing Columns and Rows

Selecting, Moving, Copying, and Pasting

HANDS-ON EXERCISE 3: Workbook and Worksheet Management

FORMATTING

Applying Alignment and Font Options

Applying Number Formats

HANDS-ON EXERCISE 4: Formatting

PAGE SETUP AND PRINTING

Selecting Page Setup Options

Printing a Worksheet

HANDS-ON EXERCISE 5: Page Setup and Printing

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER TWO ¿ Formulas and Functions

CASE STUDY: DENVER MORTGAGE COMPANY

OBJECTIVES

FORMULA BASICS

Using Semi-Selection to Create a Formula

Using Relative, Absolute, and Mixed Cell References in Formulas

Avoiding Circular References

HANDS-ON EXERCISE 1: Formula Basics

FUNCTION BASICS

Inserting a Function

Totaling Values with the SUM Function

Inserting Basic Statistical Functions

Using Date Functions

HANDS-ON EXERCISE 2: Function Basics

LOGICAL, LOOKUP, AND FINANCIAL FUNCTIONS

Determining Results with the IF Function

Using Lookup Functions

Calculating Payments with the PMT Function

HANDS-ON EXERCISE 3: Logical, Lookup, and Financial Functions

RANGE NAMES

Creating and Maintaining Range Names

Using Range Names in Formulas

HANDS-ON EXERCISE 4: Range Names

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER THREE ¿ Charts

CASE STUDY: HORT UNIVERSITY MAJORS

OBJECTIVES

CHART BASICS

Deciding Which Chart Type to Create

Creating a Chart

HANDS-ON EXERCISE 1: Chart Basics

CHART DESIGN

Changing the Chart Type

Changing the Data Source and Structure

Applying a Chart Layout and a Chart Style

Moving a Chart

Printing Charts

Inserting and Customizing a Sparkline

HANDS-ON EXERCISE 2: Chart Design

CHART LAYOUT

Selecting and Formatting Chart Elements

Customizing Chart Labels

Formatting the Axes and Gridlines

Adding a Trendline

HANDS-ON EXERCISE 3: Chart Layout

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER FOUR ¿ Datasets and Tables

CASE STUDY: THE SPA EXPERTS

OBJECTIVES

LARGE DATASETS

Freezing Rows and Columns

Printing Large Datasets

HANDS-ON EXERCISE 1: Large Datasets

EXCEL TABLES

Understanding Table Design

Creating a Table

Applying a Table Style

HANDS-ON EXERCISE 2: Excel Tables

TABLE MANIPULATION AND AGGREGATION

Sorting Data

Filtering Data

Using Structured References and a Total Row

HANDS-ON EXERCISE 3: Table Manipulation and Aggregation

CONDITIONAL FORMATTING

Applying Conditional Formatting

Creating a New Rule

Sorting and Filtering Using Conditional Formatting

HANDS-ON EXERCISE 3: Conditional Formatting

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER FIVE ¿ Subtotals, PivotTables, and PivotCharts

CASE STUDY: IVORY HALLS PUBLISHING COMPANY

OBJECTIVES

OUTLINES AND SUBTOTALS

Grouping and Ungrouping Data

Subtotaling Data

HANDS-ON EXERCISE 1: Outlines and Subtotals

PIVOTTABLE BASICS

Creating a PivotTable

Changing the Values Field

Modifying a PivotTable

HANDS-ON EXERCISE 2: PivotTable Basics

PIVOTTABLE OPTIONS

Sorting, Filtering, and Slicing a PivotTable

Creating a Calculated Field

HANDS-ON EXERCISE 3: PivotTable Options

PIVOTTABLE DESIGN AND PIVOTCHARTS

Formatting a PivotTable

Creating a PivotChart

HANDS-ON EXERCISE 4: PivotTable Design and PivotCharts

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER SIX ¿ What-If Analysis

CASE STUDY: PERSONAL FINANCE: BUYING A CAR

OBJECTIVES

ONE- AND TWO-VARIABLE DATA TABLES

Creating a One-Variable Data Table

Creating a Two-Variable Data Table

HANDS-ON EXERCISE 1: One- and Two-Variable Data Tables

GOAL SEEK AND SCENARIO MANAGER

Identifying an Input Value with Goal Seek

Using Scenario Manager

Generating Scenario Summary Reports

HANDS-ON EXERCISE 2: Goal Seek and Scenario Manager

SOLVER

Loading the Solver Add-In

Optimizing Results with Solver

HANDS-ON EXERCISE 3: Solver

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER SEVEN ¿ Specialized Functions

CASE STUDY: STANWORTH, INC.

OBJECTIVES

MATH AND STATISTICAL FUNCTIONS

Using Conditional Math and Statistical Functions

Calculating Relative Standing with Statistical Functions

HANDS-ON EXERCISE 1: Math and Statistical Functions

LOGICAL AND LOOKUP FUNCTIONS

Creating a Nested Logical Function

Using MATCH and INDEX Lookup Functions

HANDS-ON EXERCISE 2: Logical and Lookup Functions

DATABASE FILTERING AND FUNCTIONS

Using Advanced Filtering

Manipulating Data with Database Functions

HANDS-ON EXERCISE 3: Database Filtering and Functions

FINANCIAL FUNCTIONS

Creating a Loan Amortization Table

Performing Other Financial Calculations

HANDS-ON EXERCISE 4: Financial Functions

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER EIGHT ¿ Multiple-Sheet Workbook Management

CASE STUDY: HEARTLAND DEPARTMENT STORE

OBJECTIVES

MULTIPLE WORKSHEETS

Working with Grouped Worksheets

Managing Windows and Workspaces

Inserting Hyperlinks

HANDS-ON EXERCISE 1: Multiple Worksheets

3-D FORMULAS AND LINKED WORKBOOKS

Inserting a 3-D Formula

Linking Workbooks

HANDS-ON EXERCISE 2: 3-D Formulas and Linked Workbooks

FORMULA AUDITS AND DATA VALIDATION

Auditing Formulas

Setting Up a Watch Window

Validating Data

HANDS-ON EXERCISE 3: Formula Audits and Data Validation

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER NINE ¿ Imports, Web Queries, and XML

CASE STUDY: STOCK ANALYSIS

OBJECTIVES

EXTERNAL DATA

Importing Data from External Sources

Creating a Web Query

Managing Connections

HANDS-ON EXERCISE 1: External Data

TEXT MANIPULATION

Converting Text to Columns

Manipulating Text with Functions

HANDS-ON EXERCISE 2: Text Manipulation

XML

Understanding XML Syntax

Importing XML Data into Excel

HANDS-ON EXERCISE 3: XML

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER TEN ¿ Collaboration and Workbook Distribution

CASE STUDY: CULINARY ARTS SCHOLARSHIP DINNER

OBJECTIVES

CUSTOMIZATION AND PERSONALIZATION

Customizing Excel

Changing Properties

HANDS-ON EXERCISE 1: Customization and Personalization

COLLABORATION

Sharing and Merging Workbooks

Inserting Comments

Tracking Changes

HANDS-ON EXERCISE 2: Collaboration

WORKBOOK INFORMATION

Checking for Issues

Protecting a Workbook

HANDS-ON EXERCISE 3: Workbook Information

WORKBOOK DISTRIBUTION

Saving a Workbook in Different Formats

Sending a Workbook to Others

HANDS-ON EXERCISE 3: Workbook Distribution

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

CHAPTER ELEVEN ¿ Templates, Styles, and Macros

CASE STUDY: PERSONAL FINANCIAL CONSULTANT

OBJECTIVES

TEMPLATES, THEMES, AND STYLES

Selecting a Template

Applying Themes and Backgrounds

Applying Cell Styles

HANDS-ON EXERCISE 1: Templates, Themes, and Styles

CUSTOM TEMPLATES AND WORKBOOK PROTECTION

Creating and Using a Template

Protecting a Cell, a Worksheet, and a Workbook

HANDS-ON EXERCISE 2: Custom Templates and Workbook Protection

MACROS

Creating a Macro

Creating Macro Buttons

Setting Macro Security

HANDS-ON EXERCISE 3: Macros

CHAPTER OBJECTIVES REVIEW

KEY TERMS

MULTIPLE CHOICE

PRACTICE EXERCISES

MID-LEVEL EXERCISES

CAPSTONE EXERCISE

BEYOND THE CLASSROOM

GLOSSARY

INDEX

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)