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