Rent 9780619268152 | New Perspectives on Microsoft Office Excel 2003, Comprehensive, Second Edition

Summary Table of Contents

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 basic to more advanced features of Excel, from creating professional-looking workbooks to using templates, creating multiple worksheets, and developing customized applications with macros and Visual Basic.

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 Tutorial... MOREs	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.

RENT TEXTBOOKS

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

Why Rent from Knetbooks?

Top 5 reasons to order all your textbooks from Knetbooks:

Related Products