New Perspectives on Microsoft Excel 2002

by Parsons, June Jamrich; Parsons, June Jamrich; Oja, Dan; Carey, Patrick; Ageloff, Roy

• ISBN13: 9780619020927
• ISBN10: 061902092X
• Format: Spiral Bound
• Copyright: 2001-12-28
• Publisher: Cengage Learning

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

Table of Contents

Preface	v
Microsoft Windows 2000 Professional	1	(1)
Exploring the Basics	3
Investigating the Windows 2000 Operating System
Working with Files	1	(1)
Creating, Saving, and Managing Files
Microsoft Office XP	1	(1)
Introducing Microsoft Office XP	3
Preparing Promotional Material for Delmar Office Supplies
Microsoft Excel 2002---Level I Tutorials	1	(1)
Using Excel to Manage Financial Data	3
Creating an Income Statement
Working with Formulas and Functions	1	(1)
Analyzing a Mortgage
Developing a Professional-Looking Worksheet	1	(1)
Formatting a Sales Report
Working with Charts and Graphics	1	(1)
Charting Sales Data for Vega Telescopes
Microsoft Excel 2002---Level II Tutorials	1	(1)
Working with Excel Lists	3
Tracking Vehicle Data
Working with Multiple Worksheets and Workbooks	1	(1)
Tracking Cash Flow for the Lakeland Boychoir
Working with Excel's Editing and Web Tools	1	(1)
Collaborating on a Workbook and Web Page
Developing an Excel Application	1	(1)
Creating a Stock Reporter for Harris & Burton
Microsoft Excel 2002---Level III Tutorials	1	(1)
Data Tables and Scenario Management	3
Performing a Cost-Volume-Profit Analysis for Front Range Rafting
Using Solver for Complex Problems	1	(1)
Determining the Optimal Product Mix for Grill Rite Grills
Importing Data into Excel	1	(1)
Working with a Stock Portfolio for Davis & Larson
Enhancing Excel with Visual Basic for Applications	1	(1)
Creating a Quality Control Application for Datalia Inc.
Additional Case 1 Sales Invoicing for Island Dreamz Shoppe	1	(1)
Additional Case 2 Performance Reporting for Biodeck, Inc.	1	(1)
Additional Case 3 Negotiating Salaries for the National Basketball Association	1	(1)
Additional Case 4 Analyzing Product Mix for Stardust Telescopes	1	(1)
Appendix 1 Working with Logical Functions	1	(1)
Recording Employee Financial Data
Appendix 2 Integrating Excel with Other Windows Programs	1	(1)
Creating Integrated Documents for the Lighthouse
Appendix 3 Creating Custom Formats	1	(1)
Formatting Stock Market Data
Appendix 4 Saving Pivot Tables in HTML Format	1	(1)
Creating Interactive Pivot Tables for the Web
Index	1	(14)
Task Reference	15	(14)
MOUS Certification Grid	29	(6)
File Finder	35