9780619268152

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

by
  • ISBN13:

    9780619268152

  • ISBN10:

    0619268158

  • Edition: 2nd
  • Format: Paperback
  • Copyright: 2/15/2005
  • Publisher: THOMSON LRNG COURSE TECHNOLOGY INC
  • View Upgraded Edition

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

  • Get Rewarded for Ordering Your Textbooks! Enroll Now

Supplemental Materials

What is included with this book?

  • The Used and Rental copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

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.

Table of Contents

Prefacep. v
File Managementp. 1
Read This Before You Beginp. 2
Managing Your Filesp. 3
Creating and Working with Files and Folders in Windows XPp. 3
Officep. 1
Read This Before You Beginp. 2
Using Common Features of Microsoft Office 2003p. 3
Preparing Promotional Materialsp. 3
Excel: Level I Tutorialsp. 1
Read This Before You Beginp. 2
Using Excel to Manage Datap. 3
Creating a Sales Order Reportp. 3
Working with Formulas and Functionsp. 51
Developing a Family Budgetp. 51
Developing a Professional-Looking Worksheetp. 95
Formatting a Sales Reportp. 95
Working with Charts and Graphicsp. 145
Charting Sales Datap. 145
Excel: Level II Tutorialsp. 193
Read This Before You Beginp. 194
Working with Excel Listsp. 195
Tracking Vehicle Datap. 195
Working with Multiple Worksheets and Workbooksp. 253
Tracking Cash Flowp. 253
Working with Excel's Editing and Web Toolsp. 301
Collaborating on a Workbook and Web Pagep. 301
Developing an Excel Applicationp. 355
Creating a Stock Reporterp. 355
Excel: Level III Tutorialsp. 409
Read This Before You Beginp. 410
Data Tables and Scenario Managementp. 411
Performing a Cost-Volume-Profit Analysisp. 411
Using Solver for Complex Problemsp. 459
Determining the Optimal Product Mixp. 459
Importing Data into Excelp. 497
Working with a Stock Portfoliop. 497
Enhancing Excel with Visual Basic for Applicationsp. 557
Creating a Quality Control Applicationp. 557
Creating a Sales Invoicep. 1
Reporting Quarterly Performancep. 5
Negotiating Salariesp. 8
Analyzing Product Mixp. 10
Working with Logical Functions, Database Functions, and Advanced Filteringp. 1
Reviewing Employee Datap. 1
Working with Excel's Logical Functionsp. 2
Calculating Conditional Counts and Sumsp. 9
Advanced Filteringp. 11
Using Database Functions to Summarize an Excel Listp. 14
Appendix Summaryp. 17
Key Termsp. 17
Review Assignmentsp. 17
Case Problemsp. 18
Integrating Excel with Other Windows Programsp. 1
Creating Integrated Documentsp. 1
Methods of Integrationp. 2
Linking an Excel Worksheet to a Word Documentp. 3
Updating a Linked Objectp. 6
Embedding an Objectp. 7
Modifying an Embedded Objectp. 8
Appendix Summaryp. 9
Key Termsp. 10
Review Assignmentsp. 10
Case Problemsp. 11
Creating Custom Formatsp. 1
Formatting Stock Market Datap. 1
Using Format Codesp. 2
Using Conditional Formatsp. 8
Formatting Datesp. 11
Appendix Summaryp. 12
Key Termsp. 12
Review Assignmentsp. 13
Case Problemsp. 13
Saving PivotTables in HTML Formatp. 1
Creating Interactive PivotTables for the Webp. 1
Saving Workbooks as Web Pagesp. 2
Creating an Interactive PivotTablep. 7
Working with an Interactive PivotTablep. 10
Exporting a PivotTable to Excelp. 15
Appendix Summaryp. 16
Key Termsp. 17
Review Assignmentsp. 17
Case Problemsp. 17
Glossary/Indexp. 1
Task Referencep. 23
Microsoft Office Specialist Certification Gridp. 36
Table of Contents provided by Ingram. All Rights Reserved.

Rewards Program

Write a Review