Amazon no longer offers textbook rentals. We do!

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

by: Parsons,June Jamrich

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

by: Parsons,June Jamrich

ISBN 13:
9780619268152
ISBN 10:
0619268158
Edition: 2nd
Format: Paperback
Copyright: 02/15/2005
Publisher: THOMSON LRNG COURSE TECHNOLOGY INC
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

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.

Amazon no longer offers textbook rentals. We do!

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

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

9780619268152

0619268158

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

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

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

9780619268152

0619268158

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products