Advantage Series for Computer Education Search for Software Tutorials

Topics

Windows/
  Internet

Office XP
Office 2000
Office 97
Office 95/4.3
Other Titles
Multimedia

Overview

Our Books
Our Approach
For Instructors
Get Password
Find Your Book Glen & Sarah

Resources

Quizzes
Exercises
Certification
Corrections
Send Us Email

Microsoft Excel 2000: II - Introductory w/ Appendix

Hutchinson and Coulthard

ISBN: 0-07-240503-1
Published: 1/01/2000
Pages: 380 with 7 Chapters
Binding: Spiral/Coil Bound

Microsoft Office User Specialist MOUS certification

Advantage Series for Computer Education

Online Resources

Student download files:
Student Data Files: Chapters 1-4 (151 KB)
Student Data Files: Chapters 5-7 (233 KB)
Online Learning Center: Online Learning Center
Student Online Learning Center: Student OLC: 97/2000 ()

Instructor download files:
There are no instructor download files.

Miscellaneous Web resources:
Check for MHHE Catalog Listing

Print Resources

Related tutorials for students:
Microsoft Excel 2000 Brief (ISBN: 0072337966)
Microsoft Excel 2000 Complete (ISBN: 0072348089)
Microsoft Excel 2000 Introductory (ISBN: 007234802X)

Other resource materials:
IRK Microsoft Office 2000 Intro Package (ISBN: 0072384425)

Table of Contents

Chapter 1: Creating a Worksheet

1.1  Getting Started With Excel
1.2  Creating Your First Worksheet
1.3  Editing Your Work
1.4  Managing Files
1.5  Chapter Review
1.6  Review Questions
1.7  Hands-on Projects
1.8  Case Problems

Chapter 2: Modifying a Worksheet

2.1  Entering and Reviewing Data
2.2  Copying and Monving Data
2.3  Modifying Rows and Columns
2.4  Chapter Review
2.5  Review Questions
2.6  Hands-on Projects
2.7  Case Problems

Chapter 3: Formatting and Printing

3.1  Enhancing a Worksheet's Appearance
3.2  Applying and Removing Formatting
3.3  Printing and Web Publishing
3.4  Customizing Print Options
3.5  Chapter Review
3.6  Review Questions
3.7  Hands-on Projects
3.8  Case Problems

Chapter 4:  Analyzing Your Data

4.1  Working with Named Ranges
4.2  Using Built-In Functions
4.3  Creating an Embedded Chart
4.4  Chapter Review
4.5  Review Questions
4.6  Hands-on Projects
4.7  Case Problems

Chapter 5: Presenting Your Data

5.1  Formatting Cells
5.2  Using Number Formats and Styles
5.3  Working with Draw Objects
5.4  Working with Other Media
5.5  Creating a Chart Sheet
5.6  Customizing Charts
5.7  Chapter Review
5.8  Review Questions
5.9  Hands-on Projects
5.10 Case Problems

Chapter 6: Performing Calculations

6.1  Working with Formulas and Functions
6.2  Using Date and Time Functions
6.3  Using Mathematical and Statistical Functions
6.4  Using Text Manipulation Functions
6.5  Using Financial and Logical Functions
6.6  Chapter Review
6.7  Review Questions
6.8  Hands-on Projects
6.9  Case Problems

Chapter 7: Managing Worksheets and Workbooks

7.1  Using Large Worksheets
7.2  Manipulating Data in Large Worksheets
7.3  Working with Multiple-Sheet Workbooks
7.4  Consolidating Your Data
7.5  Chapter Review
7.6  Review Questions
7.7  Hands-on Projects
7.8  Case Problems
For Practice
Office 2000 OLC

Sorry, there are no quizzes yet available for this title.

Corrections
Submit a Correction

Page 000: See errata for Brief Edition
Page 296: Missing step to press ENTER
Page 302: Term "logical operators"
Page 311: Press ENTER should be TAB

List All Corrections

Purchasing
Please visit the campus bookstore or contact your McGraw-Hill sales representative at 1-800-338-3987.

To request an instructor copy:
In the U.S.
Outside the U.S.

To purchase this title online, go to:
Amazon.com
Barnes and Noble

ISBN 0072405031

Last updated on April 10, 2003
Send comments or questions to Glen Coulthard
Copyright (c) 2001 by Current Communications Inc.