I-Series: Microsoft Excel 2002, Complete

by ;
Format: Paperback
Pub. Date: 2002-04-22
Publisher(s): McGraw-Hill/Irwin
List Price: $65.35

Rent Textbook

Select for Price
There was a problem. Please try again later.

New Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

The I-Series Applications textbooks strongly emphasize that students learn and master applications skills by being actively engaged- by doing. These texts have been written with clear, error-free, and unambiguous steps to accomplish tasks that lead to a finished document, worksheet or database table. The authors made the decision that teaching "how" to accomplish some task is not enough for complete understanding and mastery. Prior to introducing steps, the authors discuss why the steps students are about to experience are important and what role the steps play in the overall plan for creating a document, workbook or database.

Table of Contents

Chapter 1 Decision-Making with Worksheets

Case: Rugby Fundraising with Scrip

Session 1.1 Introduction to Excel

Session 1.2 Essentials

Chapter 2 Planning and Creating a Worksheet

Case: Loan Analysis

Session 2.1 Writing Formulas and Copying Cell Contents

Session 2.2 Formatting Cells, Print Setup, and Printing

Chapter 3 Formatting a Worksheet

Case: TBA

Session 3.1 Editing Cells, Adding and Deleting Rows and Columns

Session 3.2 Formatting Cells

Chapter 4 Creating Charts

Case: Tracking Real Estate Sales

Session 4.1Creating a Chart

Session 4.2 Enhancing a Chart

Chapter 5 Exploring Excel’s List Features

Case: Acme Company Employee Data

Session 5.1 Creating and Sorting a Data List

Session 5.2 Creating Filters and Subtotals

Session 5.3 Pivot Tables

Chapter 6 Common Worksheet Functions

Case: Managing Accounts Receivable Lists

Session 6.1 Using Popular Statistical Functions

Session 6.2 Using Data Functions and Paste Special

Session 6.3 Using Financial Functions and Index Functions

Chapter 7 Integrating Excel, Office Objects, and the Web

Case: TBA

Session 7.1 Linking

Session 7.2 Embedding

Session 7.3 Mining the Web

Chapter 8 Developing Multiple Worksheet and Workbook Applications

Case: TBA

Session 8.1 Working with Multiple Worksheets

Session 8.2 Working with Multiple Workbooks

Chapter 9 Using Data Tables and Scenarios

Case: TBA

Session 9.1 Data Tables

Session 9.2 Scenarios

Chapter 10 Using the Solver

Case: TBA

Session 10.1 Solving Problems

Session 10.2 Solving More Complex Problems

Chapter 11 Importing Data

Case: TBA

Session 11.1 Importing Text and Database Files

Session 11.2 Using Queries to Import Data from External Sources

Session 11.3 Querying the Web

Chapter 12 Automating Applications with Visual Basic

Case: TBA

Session 12.1 Building Data Management Macro Instructions

Session 12.2 Custom Functions

Session 12.3 Introducing Visual Basic

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.