Microsoft Excel 2000

Sarah Hutchinson has taught microcomputer applications through her company, Sarah Hutchinson & Associates. She has a BA from the University of California, Santa Barbara.

Chapter 1: Creating A Worksheet 1.1 Getting Started with Excel 1.2 Getting 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: Rain Coast Air Chapter 2: Modifying A Worksheet 2.1 Entering and Reviewing Data 2.2 Copying and Moving Data 2.3 Modifying Rows and Columns 2.4 Chapter Review 2.5 Review Questions 2.6 Hands-On Projects 2.7 Case Problems: Granby Insurance Agency 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: Marvin's Music Chapter 4: Analizing 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: Interior Hockey Association 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 Separate Chart Sheet 5.6 Customizing Charts 5.7 Chapter Review 5.8 Review Questions 5.9 Hands-On Projects 5.10 Case Problems: Ponderosa Canyon 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: Synergy Computer Supplies Ltd. 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: Home Stretch Hardware Chapter 8: Managing Lists 8.1 Working with Lists 8.2 Manipulating Lists 8.3 Analyzing Lists 8.4 Using Subtotals and Outlines 8.5 Chapter Review 8.6 Review Questions 8.7 Hands-On Projects 8.8 Case Problems Chapter 9: Analyzing Alternatives 9.1 Performing What-If Analysis 9.2 Working with Data Tables 9.3 Working with PivotTables & Pivot Charts 9.4 Managing and Reporting Results 9.5 Chapter Review 9.6 Review Questions 9.7 Hands-On Projects 9.8 Case Problems Chapter 10: Working Smarter 10.1 Using Lookup Tables 10.2 Documenting Your Work 10.3 Protecting Your Work 10.4 Working with Templates 10.5 Importing and Exporting Data 10.6 Chapter Review 10.7 Review Questions 10.8 Hands-On Projects 10.9 Case Problems Chapter 11: Developing Workbook Applications 11.1 Planning a Workbook Application 11.2 Validating Data 11.3 Auditing a Worksheet 11.4 Automating a Workbook 11.5 Customizing Menus & Toolbars 11.6 Chapter Review 11.7 Review Questions 11.8 Hands-On Projects 11.9 Case Problems Chapter 12: Working with Visual Basic for Applications 12.1 Introducing the VBA Environment 12.2 Understanding the VBA Language 12.3 Controlling Your Procedures 12.4 Interacting with the User 12.5 Working with Controls 12.6 Chapter Review 12.7 Review Questions 12.8 Hands-On Projects 12.9 Case Problems