A four-color visual approach to learning that is easy to follow and fun to use when learning about Microsoft Excel 2000. Learn about the most important features of this spreadsheet program, such as how to enter, edit, and format spreadsheets, how to incorporate formulas and functions into the spreadsheet, and how to create charts and manage workbooks. Easy Microsoft Excel 2000 provides all of the information a novice user needs to know to successfully use the software without overwhelming you with too much coverage.

Table of Contents:
I. GETTING STARTED. 1. Starting Excel. 2. Moving Around in a Workbook. 3. Understanding the Worksheet Area. 4. Entering Data. 5. Selecting Cells. 6. Working with Menus. 7. Working with Toolbars. 8. Using the Right Mouse Button. 9. Getting Help from the Office Assistant. 10. Looking Up Help from the Index. 11. Getting Help Using the Contents Tab. 12. Asking Excel Whats This? 13. Exiting Excel. II. MANAGING AND VIEWING WORKBOOKS. 1. Saving a Workbook. 2. Closing a Workbook. 3. Creating a New Workbook. 4. Opening a Workbook. 5. Viewing Multiple Workbooks. 6. Switching Between Workbooks. 7. Switching Between Worksheets. 8. Naming Worksheets. 9. Inserting a Worksheet. 10. Deleting a Worksheet. 11. Copying a Worksheet to Another Workbook. 12. Zooming a Worksheet. 13. Going to a Particular Cell. 14. Freezing Rows and Columns. 15. Splitting a Worksheet. III. EDITING WORKSHEETS. 1. Editing Data. 2. Overwriting and Deleting Data. 3. Undoing and Redoing Changes. 4. Inserting Cells. 5. Deleting Cells. 6. Inserting Rows and Columns. 7. Deleting Rows and Columns. 8. Flipping Rows and Columns. 9. Cutting, Copying, and Pasting Data. 10. Moving Data. 11. Finding Data. 12. Replacing Data. 13. Adding Cell Comments. 14. Editing and Deleting Cell Comments. 15. Protecting and Sharing Workbooks. 16. Tracking Changes. 17. Accepting or Rejecting Tracked Changes. 18. Checking Spelling. IV. FORMATTING WORKSHEET DATA. 1. Applying Styles to Numeric Data. 2. Using a General Format. 3. Using a Number Format. 4. Using a Currency Format. 5. Using a Date Format. 6. Using a Text Format. 7. Applying Bold, Italic, and Underline. 8. Changing Alignment. 9. Wrapping Text in a Cell. 10. Using Merge and Center on a Cell. 11. Changing Borders. 12. Choosing Font Settings. 13. Filling Cell Color. 14. Changing Cell Orientation. 15. Changing Row Height. 16. Changing Column Width. 17. Indenting Entries in a Cell. 18. Hiding Rows and Columns. 19. Unhiding Rows and Columns. 20. Using AutoFormat. 21. Using Conditional Formatting. 22. Copying Formatting. 23. Clearing Formatting. V. WORKING WITH FORMULAS AND FUNCTIONS. 1. Using AutoSum. 2. Entering a Formula. 3. Editing a Formula. 4. Copying a Formula. 5. Naming a Cell or Range. 6. Using a Name in a Formula. 7. Finding a Cell Average. 8. Finding the Largest Cell Amount. 9. Counting the Number of Cells That Meet a Requirement. 10. Finding the Smallest Cell Amount. 11. Using AutoCalculate. 12. Filling a Complete Series. 13. Fixing Errors. 14. Fixing DIV/0! Errors. 15. Fixing Name? Errors. 16. Fixing Value! Errors. 17. Recognizing the REF! Error. 18. Recognizing Circular Reference Errors. 19. Checking for Formula References. 20. Checking for Cell References. VI. WORKING WITH CHARTS AND GRAPHICS. 1. Creating a Chart. 2. Changing the Chart Type. 3. Altering Source Data Range. 4. Altering Chart Options. 5. Formatting the Plot Area. 6. Formatting the Chart Area. 7. Formatting an Axis Scale. 8. Altering the Original Data. 9. Using Drawing Tools. 10. Inserting Clip Art. 11. Selecting Objects. 12. Resizing Objects. 13. Moving Objects. 14. Deleting Objects. VII. WORKING WITH DATA LISTS. 1. Setting Up a Data List and Form. 2. Entering Data with a Form. 3. Adding Data Validation. 4. Finding a Record. 5. Modifying a Record. 6. Deleting Data Records. 7. Sorting a Data List. 8. Filtering a Data List. 9. Removing an AutoFilter. 10. Adding Record Subtotals. VIII. PRINTING WORKBOOKS. 1. Using Print Preview. 2. Setting the Print Area. 3. Setting Margins. 4. Setting Page Orientation. 5. Inserting a Page Break. 6. Creating Repeating Titles. 7. Altering the Page Scale. 8. Creating Headers and Footers. 9. Printing Workbooks and Worksheets. IX. ADVANCED EXCEL AND WEB FEATURES. 1. Copying and Linking to Office Documents. 2. Creating and Running Macros. 3. Exporting Data. 4. Importing Data. 5. Saving a Worksheet As a Web Page. 6. Using Web Page Preview. 7. Typing a URL into a Worksheet. 8. Clicking a URL in a Worksheet. 9. Inserting Web Hyperlinks. 10. Inserting Office Document Hyperlinks. 11. Editing a Hyperlink. 12. Removing a Hyperlink. 13. Sending a Workbook As an Email. 14. Sending a Workbook As a Fax.