EVERYDAY FREE SHIPPING on $25 & up  Excludes Marketplace items
EVERYDAY FREE SHIPPING
on $25 & up
 Excludes Marketplace
Comprehensive Excel 2002 for Office XP-Text Only

Comprehensive Excel 2002 for Office XP-Text Only - 4th edition

Cover of Comprehensive Excel 2002 for Office XP-Text Only 4TH 03 (ISBN -)
Cover type:
Edition: 4TH 03
Copyright: 2003
Publisher: Scott/Jones Publisher, Inc.
Published: 2003
International: No

More Shipping Options

Comprehensive Excel 2002 for Office XP-Text Only - 4TH 03 edition

ISBN13: -

Karen J. Jolly

Cover type:
Edition: 4TH 03
Copyright: 2003
Publisher: Scott/Jones Publisher, Inc.
Published: 2003
International: No

Author Bio

Jolly, Karen J. : Portland Community College

Table of Contents

Preface
File Management
Business Math Workshop: Convert Decimals to Percents

PART I--Basic Excel

PREPARING TO EXCEL
Business Math Workshop: Calculate Percentages
Chapter 1: Creating a Worksheet
Business Math Workshop: Sales Tax
Business Math Workshop: Commissions and Bonuses
Business Math Workshop: About a Sales Invoice
Chapter 2: Entering Basic Formulas
Business Math Workshop: Payroll Calculations
Chapter 3: Moving and Copying Information
Business Math Workshop: Determine an Average
Business Math Workshop: Markup and Markdown
Chapter 4: Working with Formulas
Chapter 5: Multiple-Sheet Workbooks and Other Time Savers
Chapter 6: Additional Formatting Techniques
Chapter 7: Working with Large Worksheets, Page Setup, and Printing

PART II--Intermediate Excel

Business Math Workshop: Determine Depreciation
Chapter 8: Creating Charts
Business Math Workshop: Determine Interest
Chapter 9: Using Functions
Chapter 10: Using Excel to Manage Lists
Chapter 11: Using Macros and Visual Basic
Chapter 12: Integrating Excel with Other Applications
Chapter 13: Using Templates
Chapter 14: Exploring Additional Format, Audit, and Protection Topics
Business Math Workshop: Stocks, Bonds, and Portfolio Values
Chapter 15: Using Excel with the Internet
Chapter 16: Creating and Enhancing Charts
Business Math Workshop: Present Value
Business Math Workshop: Future Value and Compound Interest
Chapter 17: Working with Advanced Functions

PART III--Advanced Excel

Chapter 18: Nesting Functions and Advanced Lookup Tables
Chapter 19: Advanced Features of List Management
Chapter 20: Using Outline, Subtotal, Conditional Formatting, and Text to Speech Features
Chapter 21: Using Named Cells
Chapter 22: Creating PivotTables and PivotCharts, and Consolidating Workbooks
Chapter 23: Using Data Analysis Tools of Data Tales, Goal Seek, Solver, and Scenarios
Chapter 24: Working with Styles, Forms and Validation, and Sharing Workbooks

Glossary
Quick Reference: How To
Keyboard Shortcuts for Power Users
Index

More Shipping Options