Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones ∑ Scott/Jones

Home | Textbook Catalog | Order Book | Syllabi

Web Site for Excel 2002 for Office XP

Sample Pages
Business Math Workshop and

File Management

 

Save 12% over most
bookstore prices by ordering
directly from Scott/Jones!

 

Comprehensive Excel 2002 for Office XP, 4th Edition
and
Introductory Excel 2002 for Office XP, 4th Edition

by Karen J. Jolly
Portland Community College
 


Comprehensive Excel 2002 for Office XP


Comprehensive Excel 2002 for Office XP
 


Introductory Excel 2002 for Office XP


Introductory Excel 2002 for Office XP

Some Excel texts are "nothing but a series of steps" . . . which students forget as soon as they close the book. Other Excel texts are fantastic references . . . but poor pedagogical tools.

Then there's Comprehensive Excel 2002 for Office XP, 4th Edition, and Introductory Excel for Office XP, 4th Edition, both by Karen J. Jolly. The best of both worlds,
because . . .
  • Numerous Try It Now short reinforcement exercises appear throughout Jolly's books
  • On The Job exercises conclude each chapter providing practice in preparing spreadsheets for business.
  • Jolly includes a one-page handy, tear out, reference sheet of math and Excel basics that would help to facilitate weak areas. (Students could then use this sheet for a bookmark in their texts.)
  • Immediate Reinforcement. Text clearly shows how to complete a task which is immediately reinforced with a hands-on exercise.
  • Comprehensive Problems. Work with the same business to complete sample documents for that business.
  • Provides both a reference and a learning guide.
  • Tips on file management appear throughout Jolly:
    * Features of Folder windows
    * Naming and searching for files and folders
    * Some basic operations
    * Creating shortcuts
    * Organizing your files and folders
    * Property sheets and System files
    * File types and associations
  • Basic Arithmetic Modules appear throughout Jolly: ("How do you figure interest? Why do you care about the payment?" "What are principal, payment, and interest functions?" "What is depreciation and how is it figured?" "What is a markup?")
  • Jolly pays more attention to planning and organizing students' work throughout the text ("Planning the Worksheet" listed as an index item. Is it in your current text's index?)
Want to make a change from cookbook-style books?
Examine Karen J. Jolly's Excel 2002 books. She makes it easy for you!

Tables of Contents

Comprehensive Excel 2002 for Office XP, 4th Edition
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

1016 pages
ISBN 1-57676-102-9

Introductory Excel 2002 for Office XP, 4th Edition
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

Keyboard Shortcuts for Power Users
Index

527 pages
ISBN 1-57676-111-8

Instructor Materials
Instructors' PowerPoint slides, test bank that includes both objective and hands-on testing, full instructional key including answers for all student work.

Home | Textbook Catalog | Order Book | Syllabi


Scott/Jones Inc., El Granada CA
Website maintenance & updating by
Jane Scott/Jones.
Updated
January 16, 2004