Courseware Description Course Objectives Course Design Conventions and Graphics Lesson 1: Working with Workbooks Lesson Objectives What is an Electronic Spreadsheet? Looking at the Excel Screen Ribbon User Interface Creating a New Blank Workbook Entering Data in a Worksheet Selecting Cells Lesson Summary Review Questions Lesson 2: Manipulating Items Lesson Objectives Copying and Moving Data Adjusting the Columns and Rows Inserting and Deleting Rows and Columns Managing Worksheets Renaming Worksheets Inserting or Deleting Worksheets Moving or Copying Worksheets Lesson Summary Review Questions Lesson 3: Using Formulas Lesson Objectives Creating and Editing Simple Formulas Using Common Functions with Cell Ranges Using Absolute and Relative Cell References Displaying and Printing Formulas Lesson Summary Review Questions

Lesson 4: Formatting the Worksheet Lesson Objectives Formatting a Cell Clearing Cell Contents and Formatting Formatting Worksheets Lesson Summary Review Questions Lesson 5: Preparing to Print Lesson Objectives Changing the Views Print Previewing Worksheets Adding and Previewing Page Breaks Customizing the Printout Printing the Worksheet Lesson Summary Review Questions Lesson 6: Working with Charts Lesson Objectives Creating a Basic Chart Changing Chart Types Working with Pie Charts Changing the Chart Layout Moving and Resizing Charts Printing Charts Lesson Summary Review Questions Appendices Appendix A: A Quick Review of Basics Appendix B: Answers to Review Questions Appendix C: Microsoft Office Excel 2007 Exam Objectives Appendix D: Glossary Terms Appendix E: Index