New Perspectives on Microsoft Office Excel 2003, Comprehensive, Second Edition

by Parsons,June Jamrich

Edition:

2nd

ISBN13:

9780619268152

ISBN10:

0619268158

Format:

Paperback

Pub. Date:

2/15/2005

Publisher(s):

THOMSON LRNG COURSE TECHNOLOGY INC

Other versions by this Author

List Price: ~~$134.00~~

Rent Textbook

(Recommended)

Term

Due

Price

Short Term

Aug 2

$13.37

Semester

Sep 30

$67.00

Quarter

Aug 21

$60.30

$13.37

Buy Used Textbook

In Stock Usually Ships in 24 Hours.

$1.00

Buy New Textbook

Currently Available, Usually Ships in 24-48 Hours

$130.65

eTextbook

We're Sorry
Not Available

More New and Used
from Private Sellers

Starting at $0.37

Questions About This Book?

Why should I rent this book?

Renting is easy, fast, and cheap! Renting from eCampus.com can save you hundreds of dollars compared to the cost of new or used books each semester. At the end of the semester, simply ship the book back to us with a free UPS shipping label! No need to worry about selling it back.

How do rental returns work?

Returning books is as easy as possible. As your rental due date approaches, we will email you several courtesy reminders. When you are ready to return, you can print a free UPS shipping label from our website at any time. Then, just return the book to your UPS driver or any staffed UPS location. You can even use the same box we shipped it in!

What version or edition is this?

This is the 2nd edition with a publication date of 2/15/2005.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any CDs, lab manuals, study guides, etc.
The Used copy of this book is not guaranteed to inclue any supplemental materials. Typically, only the book itself is included.
The Rental copy of this book is not guaranteed to include any supplemental materials. You may receive a brand new copy, but typically, only the book itself.

Summary

Part of the New Perspectives series, this text offers a case-based, problem-solving approach and innovative technology for meaningful learning of Microsoft Excel 2003. This Second Edition has been updated to include a variety of new material and references to keep your course up-to-date and engaging.

Preface	p. v
File Management	p. 1
Read This Before You Begin	p. 2
Managing Your Files	p. 3
Creating and Working with Files and Folders in Windows XP	p. 3
Office	p. 1
Read This Before You Begin	p. 2
Using Common Features of Microsoft Office 2003	p. 3
Preparing Promotional Materials	p. 3
Excel: Level I Tutorials	p. 1
Read This Before You Begin	p. 2
Using Excel to Manage Data	p. 3
Creating a Sales Order Report	p. 3
Working with Formulas and Functions	p. 51
Developing a Family Budget	p. 51
Developing a Professional-Looking Worksheet	p. 95
Formatting a Sales Report	p. 95
Working with Charts and Graphics	p. 145
Charting Sales Data	p. 145
Excel: Level II Tutorials	p. 193
Read This Before You Begin	p. 194
Working with Excel Lists	p. 195
Tracking Vehicle Data	p. 195
Working with Multiple Worksheets and Workbooks	p. 253
Tracking Cash Flow	p. 253
Working with Excel's Editing and Web Tools	p. 301
Collaborating on a Workbook and Web Page	p. 301
Developing an Excel Application	p. 355
Creating a Stock Reporter	p. 355
Excel: Level III Tutorials	p. 409
Read This Before You Begin	p. 410
Data Tables and Scenario Management	p. 411
Performing a Cost-Volume-Profit Analysis	p. 411
Using Solver for Complex Problems	p. 459
Determining the Optimal Product Mix	p. 459
Importing Data into Excel	p. 497
Working with a Stock Portfolio	p. 497
Enhancing Excel with Visual Basic for Applications	p. 557
Creating a Quality Control Application	p. 557
Creating a Sales Invoice	p. 1
Reporting Quarterly Performance	p. 5
Negotiating Salaries	p. 8
Analyzing Product Mix	p. 10
Working with Logical Functions, Database Functions, and Advanced Filtering	p. 1
Reviewing Employee Data	p. 1
Working with Excel's Logical Functions	p. 2
Calculating Conditional Counts and Sums	p. 9
Advanced Filtering	p. 11
Using Database Functions to Summarize an Excel List	p. 14
Appendix Summary	p. 17
Key Terms	p. 17
Review Assignments	p. 17
Case Problems	p. 18
Integrating Excel with Other Windows Programs	p. 1
Creating Integrated Documents	p. 1
Methods of Integration	p. 2
Linking an Excel Worksheet to a Word Document	p. 3
Updating a Linked Object	p. 6
Embedding an Object	p. 7
Modifying an Embedded Object	p. 8
Appendix Summary	p. 9
Key Terms	p. 10
Review Assignments	p. 10
Case Problems	p. 11
Creating Custom Formats	p. 1
Formatting Stock Market Data	p. 1
Using Format Codes	p. 2
Using Conditional Formats	p. 8
Formatting Dates	p. 11
Appendix Summary	p. 12
Key Terms	p. 12
Review Assignments	p. 13
Case Problems	p. 13
Saving PivotTables in HTML Format	p. 1
Creating Interactive PivotTables for the Web	p. 1
Saving Workbooks as Web Pages	p. 2
Creating an Interactive PivotTable	p. 7
Working with an Interactive PivotTable	p. 10
Exporting a PivotTable to Excel	p. 15
Appendix Summary	p. 16
Key Terms	p. 17
Review Assignments	p. 17
Case Problems	p. 17
Glossary/Index	p. 1
Task Reference	p. 23
Microsoft Office Specialist Certification Grid	p. 36
Table of Contents provided by Ingram. All Rights Reserved.