|

Prentice Hall

Information Technology

My Instructor Resource Center :  Log in or request access

Exploring MS Office Excel 2003 Comprehensive Revised Edition and Student Resource CD Package
Robert T. GrauerUniversity of Miami
Maryann BarberUniversity of Miami

ISBN-10: 0131877429
ISBN-13:  9780131877429

Publisher:  Prentice Hall
Copyright:  2006
Format:  Paper; 832 pp
Published:  07/27/2005
  We're sorry, this product is no longer available and has been replaced withEXPLRG MICROSFT OFF XCL03 CMPLT REV& CD PKG.
Please contact your Pearson rep if you are using this product and need instructor resources.




For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications.

                      
Master the How and Why of Office 2003!  Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve business problems.

 

Chapter opening case studies—to preview the skills covered in each chapter and to set the stage of learning.

Three levels of chapter-ending exercises—Multiple Choice (study guide), Practice (hands-on), and Case Studies (open-ended).

º      Offers students plenty of opportunity for review and reinforcement.

All supplements for this series, including Instructor's Manual, Solutions Disk, PowerPoint, and Data Disks, as well as the Computerized Testing System, are available on one CD—InstructorResourceCenter.

Perfect pages - 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:

º      Perfect pages are unique to Grauer and ensure students always know where to begin and end assignments.

Accompanying website featuring MyPHLIP technology.

º      Provides students and instructors with additional resources and tools to facilitate the learning process.

MOS Certification through the Expert level for all individual applications and Office 2003.

º      Provides the necessary training to pass the MOS exam at the Expert level, preparing students to enter today's job market.

Quality, four-color, spiral bound—Exploring Office series covers Word, Access, Excel, and PowerPoint. There are four combined texts in the series—Exploring Microsoft Office Vol. I and II, Microsoft Office Brief, and Getting Started with Microsoft Office.

º      Gives students up-to-date information on current applications in an attractive easy-to-use format. (Perfect binding is also available).

Sequential Page Numbering throughout each text. Pages start with number 1 and move sequential. For example Page 1 to 1000.

º      This ensures instructors and students can find assigned material.

 

  • NEW! A thoroughly revised chapter (Chapter 6) on financial analysis that includes the IRR function and the development of an amortization schedule
  • NEW! A new chapter (Chapter 8) on data analysis that takes the reader through four independent hands-on exercises each with several hundred records
  • NEW! All new chapter-opening case studies

Chapter 1: Introduction to Excel: What Is a Spreadsheet?

Objectives

Case Study: Weddings by Molly

Introduction to Spreadsheets

The Professor’s Grade Book

Row and Column Headings

Formulas and Constants

Introduction to Microsoft Excel

Toolbars

The File Menu

HANDS-ON EXERCISE 1: INTRODUCTION TO MICROSOFT EXCEL

Modifying the Worksheet

The Page Setup Command

HANDS-ON EXERCISE 2: MODIFYING A WORKSHEET

A Better Grade Book

Cell Ranges

Copy Command

Move Operation

Learning by Doing

HANDS-ON EXERCISE 3: CREATING A WORKBOOK

Formatting

Format Cells Command

Alignment

Fonts

Borders, Patterns, and Shading

HANDS-ON EXERCISE 4: FORMATTING A WORKSHEET

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Chapter 2: Gaining Proficiency: The Web and Business Applications

Objectives

Case Study: The Reluctant Entrepreneur

Employee Payroll

Pointing

The Fill Handle

Comments

HANDS-ON EXERCISE 1: PAYROLL

Excel and the Internet

HANDS-ON EXERCISE 2: CREATING A WEB PAGE

Web Queries

The Time Format

HANDS-ON EXERCISE 3: WEB QUERIES

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Chapter 3: Graphs and Charts: Delivering a Message

Objectives

Case Study: The Changing Student Population

Chart Types

Pie Charts

Column and Bar Charts

Creating a Chart

The Chart Wizard

Modifying a Chart

HANDS-ON EXERCISE 1: THE CHART WIZARD

Multiple Data Series

Stacked Column Charts

HANDS-ON EXERCISE 2: MULTIPLE DATA SERIES

Object Linking and Embedding

HANDS-ON EXERCISE 3: OBJECT LINKING AND EMBEDDING

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Chapter 4: Using Spreadsheets in Decision Making: What If?

Objectives

Case Study: Bill's Autos

Spreadsheets in Decision Making

Analysis of a Car Loan

PMT Function

FV Function

Inserting a Function

The Goal Seeking Command

HANDS-ON EXERCISE 1: BASIC FINANCIAL FUNCTIONS

Home Mortgages

Relative versus Absolute Addresses

Mixed References

HANDS-ON EXERCISE 2: ADVANCED FINANCIAL FUNCTIONS

The Grade Book Revisited

Statistical Functions

Arithmetic Expressions versus Functions

IF Function

VLOOKUP Function

Working with Large Spreadsheets

Freezing Panes

Hiding Rows and Columns

Printing a Large Worksheet

AutoFilter Command

HANDS-ON EXERCISE 3: THE EXPANDED GRADE BOOK

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Chapter 5: Consolidating Data: Worksheet References and File Linking

Objectives

Case Study: Tasty Treats

Consolidating Data

The Three-Dimensional Workbook

Copying Worksheets

Multiple Workbooks

HANDS-ON EXERCISE 1: COPYING WORKSHEETS

Worksheet References

3-D Reference

Grouping Worksheets

The AutoFormat Command

HANDS-ON EXERCISE 2: 3-D REFERENCES

The Documentation Worksheet

HANDS-ON EXERCISE 3: THE DOCUMENTATION WORKSHEET

Linking Workbooks

HANDS-ON EXERCISE 4: LINKING WORKBOOKS

Summary

Key Terms

Multiple Choice

Practice with Excel

Mini Cases

 

Chapter 6: Financial Analysis: Forecasting, Rate of Return, and Amortization

Objectives

Case Study: Whispering Woods Golf Club

A Financial Forecast

Advanced Formatting

Scenario Manager

HANDS-ON EXERCISE 1: A FINANCIAL FORECAST

Workgroups and Auditing

Data Validation

HANDS-ON EXERCISE 2: AUDITING AND WORKGROUPS

The Internal Rate of Return

Creating a Template

HANDS-ON EXERCISE 3: CREATING A TEMPLATE

The Amortization Schedule

The Year, Month, and Day Functions

The MATCH and INDEX functions

HANDS-ON EXERCISE 4: CREATING AN AMORTIZATION SCHEDULE

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Chapter 7: List and Data Management: Converting Data to Information

Objectives

Case Study: Alice Barr Realty

List and Data Management

Implementation in Excel

Data Form Command

Sort Command

The Text Import Wizard

Excel and XML

HANDS-ON EXERCISE 1: IMPORTING, CREATING, AND MAINTAINING A LIST

Data versus Information

AutoFilter Command

Advanced Filter Command

Criteria Range

Database Functions

Insert Name Command

Subtotals

HANDS-ON EXERCISE 2: DATA VERSUS INFORMATION

Pivot Tables and Pivot Charts

HANDS-ON EXERCISE 3: PIVOT TABLES AND PIVOT CHARTS

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Chapter 8: Data Analysis: A Capstone Chapter

Objectives

Case Study: The Personal Computer Store

Drowning in Data

The Admissions Office

Implementation in Excel

HANDS-ON EXERCISE 1: THE ADMISSIONS OFFICE

The Graduating Class

Implementation in Excel

HANDS-ON EXERCISE 2: THE GRADUATING CLASS

The Men's Store

HANDS-ON EXERCISE 3: THE MEN'S STORE

The Restaurant

Implementation in Excel

HANDS-ON EXERCISE 4: THE RESTAURANT

Summary

Key Words and Concepts

Multiple Choice

Practice Exercises

Additional Mini Cases

Medical Specialties

The Corporate Take Over

Drowning in Data

 

Chapter 9: Automating Repetitive Tasks: Macros and Visual Basic for Applications

Objectives

Case Study: Universal Health Services

Introduction to Macros

HANDS-ON EXERCISE 1: INTRODUCTION TO MACROS

Relative versus Absolute References

The Personal Macro Workbook

HANDS-ON EXERCISE 2: THE PERSONAL MACRO WORKBOOK

Data Management Macros

HANDS-ON EXERCISE 3: DATA MANAGEMENT MACROS

Visual Basic for Applications

HANDS-ON EXERCISE 4: CREATING ADDITIONAL MACROS

Loops and Decision Making

If Statement

Do Statement

HANDS-ON EXERCISE 5: LOOPS AND DECISION MAKING

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Chapter 10: A Professional Application: An Enhanced Schedule

Objectives

Case Study: Retirement Planning

Application Development

The Enhanced Amortization Schedule

Date Functions

HANDS-ON EXERCISE 1: THE ENHANCED AMORTIZATION SCHEDULE WORKBOOK

Exploring VBA Syntax

Three Simple Procedures

HANDS-ON EXERCISE 2: EXPLORING VBA SYNTAX

Event Procedures

User Forms

HANDS-ON EXERCISE 3: EVENT PROCEDURES

More Complex Procedures

HANDS-ON EXERCISE 4: PERIODIC OPTIONAL PAYMENTS

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Chapter 11: Extending VBA: Processing Worksheets and Workbooks

Objectives

Case Study: Bon Voyage Travel

The Expense Summary Application

A Quick Review

The Dir Function

HANDS-ON EXERCISE 1: CREATE THE SUMMARY WORKBOOK

Displaying a Specific Worksheet

Error Trapping

HANDS-ON EXERCISE 2: ERROR TRAPPING

Processing Worksheets in a Workbook

Adding Employees to the Summary Worksheet

HANDS-ON EXERCISE 3: CREATE THE SUMMARY WORKSHEET

A Better Summary Workbook

HANDS-ON EXERCISE 4: A BETTER SUMMARY WORKBOOK

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Appendix A: Toolbars for Microsoft Office Excel 2003

 

Appendix B: Solver: A Tool for Optimization

 

Appendix C: Using XML with Microsoft Excel 2003

Introduction to XML

HANDS-ON EXERCISE 1: INTRODUCTION TO XML

Microsoft Excel and XML

HANDS-ON EXERCISE 2: EXCEL AND XML

Summary

Key Terms

 

Getting Started with VBA: Extending Microsoft Office 2003

Objectives

Case Study: On-the-Job Training

Introduction to VBA

The MsgBox Statement

The InputBox Function

Declaring Variables

The VBA Editor

HANDS-ON EXERCISE 1: INTRODUCTION TO VBA

If . . . Then . . . Else Statement

Case Statement

Custom Toolbars

HANDS-ON EXERCISE 2: DECISION MAKING

For . . . Next Statement

Do Loops

Debugging

HANDS-ON EXERCISE 3: LOOPS AND DEBUGGING

Putting VBA to Work (Microsoft Excel)

HANDS-ON EXERCISE 4: EVENT-DRIVEN PROGRAMMING (MICROSOFT EXCEL)

Putting VBA to Work (Microsoft Access)

HANDS-ON EXERCISE 5: EVENT-DRIVEN PROGRAMMING (MICROSOFT ACCESS)

Summary

Key Terms

Multiple Choice

 

Getting Started with Microsoft Windows XP

Objectives

Case Study: Unforeseen Circumstances

Welcome to Windows XP

The Desktop

Moving and Sizing a Window

Anatomy of a Window

Pull-down Menus

Dialog Boxes

Help and Support Center

HANDS-ON EXERCISE 1: WELCOME TO WINDOWS XP

Files and Folders

The Exploring Office Practice Files

Connecting to the Internet

HANDS-ON EXERCISE 2: DOWNLOAD THE PRACTICE FILES

Windows Explorer

Personal Folders

Moving and Copying a File

Deleting a File

Backup

HANDS-ON EXERCISE 3: WINDOWS EXPLORER

Increasing Productivity

The Control Panel

Shortcuts

The Search Companion

HANDS-ON EXERCISE 4: INCREASING PRODUCTIVITY

Fun with Windows XP

Windows Media Player

Digital Photography

Windows Messenger

HANDS-ON EXERCISE 5: FUN WITH WINDOWS XP

Summary

Key Terms

Multiple Choice

Practice Exercises

Mini Cases

 

Dr. Robert T. Grauer       

Dr. Robert T. Grauer is an Associate Professor in the Department of Computer Information Systems at the University of Mniami where he has been honored with the Outstanding Teacher Award in the School of Business.

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

Dr. Grauer has also 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.

Maryann M. Barber

Maryann M. Barber is a lecturer in the Department of Computer Information Systems at the University of Miami. She has been honored with several teaching awards, including the Excellence in Teaching Awards for the School of Business, the Freshman Teaching Award, the Apple Polishing Award, the Student Government Professor of the Year Award, the Interfraternity Council Professor of the Year Award, and the University of Miami Excellence in Teaching Award.

Maryann is also the Faculty Master at Stanford Residential College. She is a member of numerous leadership honor societies at the University of Miami, including Iron Arrow, Mortar Board, and Omicron Delta Kappa.

Exploring Office 2003 Vol 1 2/e and Office Plus IRC on CD, 2/E
Grauer
©2006 | Prentice Hall | CD-ROM Only | Instock
ISBN-10: 0131744364 | ISBN-13: 9780131744363
  View Downloadable Files



Instructors Resource Center
Grauer
©2006 | Prentice Hall | On-line Supplement | Estimated Availability : 04/14/2006
ISBN-10: 013172889X | ISBN-13: 9780131728899
  View Downloadable Files



Exploring MS Office 2003 Word Comprehensive Student Resource CD-ROM
Grauer & Barber
©2006 | Prentice Hall | Paper | Instock
ISBN-10: 0131729063 | ISBN-13: 9780131729063
Buy from myPearsonStore


Exploring Microsoft Office 2003 Excel Comprehensive Student Resource CD-ROM
Grauer & Barber
©2006 | Prentice Hall | CD-ROM Only | Instock
ISBN-10: 0131729071 | ISBN-13: 9780131729070


Exploring Microsoft Office 2003 PowerPoint Comprehensive Student Resource CD-ROM
Grauer
©2006 | Prentice Hall | CD-ROM Only | Instock
ISBN-10: 0131729101 | ISBN-13: 9780131729100
Buy from myPearsonStore


PHIT TIPS Microsoft Access 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0131588346 | ISBN-13: 9780131588349
Buy from myPearsonStore


PHIT Tips: File Management
PrenticeHall
©2008 | Prentice Hall | Study Card; 2 pp | Instock
ISBN-10: 0131588354 | ISBN-13: 9780131588356
Buy from myPearsonStore


PHIT Tips: Microsoft Office 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132332221 | ISBN-13: 9780132332224
Buy from myPearsonStore


PHIT Tips: Microsoft Outlook 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132050625 | ISBN-13: 9780132050623
Buy from myPearsonStore


PHIT Tips: Microsoft PowerPoint 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132332558 | ISBN-13: 9780132332552
Buy from myPearsonStore


PHIT Tips: Microsoft Word 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132050617 | ISBN-13: 9780132050616
Buy from myPearsonStore


PHIT Tips: WinZip for Microsoft Office 2007
PrenticeHall
©2008 | Prentice Hall | Study Card | Instock
ISBN-10: 0131588311 | ISBN-13: 9780131588318
Buy from myPearsonStore


Phit TIPS: Microsoft Excel 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0136128017 | ISBN-13: 9780136128014
Buy from myPearsonStore


Shortcut Key Card: Microsoft Access 2007
PrenticeHall
©2008 | Prentice Hall | Study Card | Out of Stock
ISBN-10: 0132050609 | ISBN-13: 9780132050609


Shortcut Key Card: Microsoft Excel 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0132332531 | ISBN-13: 9780132332538
Buy from myPearsonStore


Shortcut Key Card: Microsoft Office 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 2 pp | Instock
ISBN-10: 0131588400 | ISBN-13: 9780131588400
Buy from myPearsonStore


Shortcut Key Card: Microsoft PowerPoint 2007
PrenticeHall
©2008 | Prentice Hall | Study Card | Out of Stock
ISBN-10: 013158832X | ISBN-13: 9780131588325


Shortcut Key Card: Microsoft Word 2007
PrenticeHall
©2008 | Prentice Hall | Study Card; 2 pp | Instock
ISBN-10: 0136128009 | ISBN-13: 9780136128007
Buy from myPearsonStore


Windows Vista PHIT Tip
CIS Prentice Hall
©2008 | Prentice Hall | Study Card; 4 pp | Instock
ISBN-10: 0136128025 | ISBN-13: 9780136128021
Buy from myPearsonStore


Give your students a choice! PearsonChoices products are designed to give your students more value and flexibility by letting them choose from a variety of text and media formats to best match their learning style and their budget.

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, see the Packages Tab.

  • 9780135075500
    Custom PHIT 2003
    Pearson Custom Publishing
    ©2009 | Prentice Hall | On-line Supplement | Out of Stock
    ISBN-10: 0135075505 | ISBN-13: 9780135075500

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.