Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


Original Essays | June 20, 2014

Lisa Howorth: IMG So Many Books, So Many Writers



I'm not a bookseller, but I'm married to one, and Square Books is a family. And we all know about families and how hard it is to disassociate... Continue »
  1. $18.20 Sale Hardcover add to wish list

    Flying Shoes

    Lisa Howorth 9781620403013

spacer
Qualifying orders ship free.
$100.00
List price: $132.20
Used Spiral
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Partner Warehouse General- General

Exploring Microsoft Office Excel 2010 Comprehensive - With CD (11 Edition)

by

Exploring Microsoft Office Excel 2010 Comprehensive - With CD (11 Edition) Cover

ISBN13: 9780135098592
ISBN10: 0135098599
Condition: Student Owned
All Product Details

 

Synopses & Reviews

Please note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.

Publisher Comments:

The Exploring System: Moving You Beyond the Point and Click!

 

The goal of the Exploring Series is to teach more than just the steps to follow to accomplish a task. Exploring also teaches you the theoretical foundation you need to understand when and why to apply the skills you learnin this class. This way, you achieve a deeper understanding of each application and can apply this criticalthinking beyond Office and the classroom.

 

Student Textbook

Exploring is a book you can use as a tool to easily identify essential information, and learn it efficiently.

 

Objective Mapping enables you to easily find where each objective is in the chapter.

Key Terms are pulled out and defined in the margins, helping to ensure you learn terminology.

Hands-On Exercises throughout each chapter allow you to apply what you learned for immediate reinforcement.

 

Student CD

A media tool bound in your book to help you complete exercises from each chapter

 

Set-Up Videos provide an introduction to the Case Study and the skills you’ll learn in the Hands-On Exercises in each chapter.

Student Data Files needed to complete the projects in the book.

Compass is a searchable database of skills, providing videos and at-a-glance reminders of how to complete a skill.

 

Companion Website: www.pearsonhighered.com/exploring

An interactive website featuring self-study tools to help you succeed in this course

 

Online Study Guide enables you to practice what you’ve learned by answering auto-graded questions.

Glossary of key terms reinforces terminology as you learn the language of computing.

Chapter Objectives Review for a quick overview.

Web Resources include links to Microsoft® Office Online Help and How-To documents.

Student Data Files needed to complete the projects in the book.

Synopsis:

This package contains:

0132666537: myitlab — Access Card — for Exploring Office 2010 Vol. 1

0135098599: Exploring Microsoft Office Excel 2010 Comprehensive

Synopsis:

This package contains:

0135098254: Exploring Microsoft Office Access 2010 Comprehensive

0135098599: Exploring Microsoft Office Excel 2010 Comprehensive

About 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.

 

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

 

What Our Readers Are Saying

Add a comment for a chance to win!
Average customer rating based on 1 comment:

Filimon, March 9, 2012 (view all comments by Filimon)
This book and exercises are hard to comprehend. It takes a lot of time and patience to actually understand. If you make mistakes along the way, you will have to go back and start all over again. This needs to be easier for someone to understand. I hate it!!!
Was this comment helpful? | Yes | No

Product Details

ISBN:
9780135098592
Author:
Grauer, Robert T.
Publisher:
Prentice Hall
Author:
Pearson Education
Author:
Mulbery, Keith
Author:
Grauer, Robert
Author:
Pearson Education, -.
Author:
Hogan, Lynn
Author:
Poatsy, Mary Anne
Author:
- Pearson Education
Author:
Pearson Education
Author:
Poatsy, Mary Anne S.
Subject:
Spreadsheets - General
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Business Software - General
Copyright:
Edition Description:
Trade paper
Series:
Exploring
Publication Date:
20101112
Binding:
CD-ROM
Language:
English
Pages:
736
Dimensions:
10.9 x 9 x 1 in 1429 gr

Other books you might like

  1. Exploring Microsoft Office... Used Spiral $100.00

Related Subjects

Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
Textbooks » General

Exploring Microsoft Office Excel 2010 Comprehensive - With CD (11 Edition) Used Spiral
0 stars - 0 reviews
$100.00 In Stock
Product details 736 pages Prentice Hall - English 9780135098592 Reviews:
"Synopsis" by , This package contains:

0132666537: myitlab — Access Card — for Exploring Office 2010 Vol. 1

0135098599: Exploring Microsoft Office Excel 2010 Comprehensive

"Synopsis" by , This package contains:

0135098254: Exploring Microsoft Office Access 2010 Comprehensive

0135098599: Exploring Microsoft Office Excel 2010 Comprehensive

spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.