Contents at a Glance -- Table of Contents -- Introduction -- About This Kit -- Foolish Assumptions -- Icons Used in This Kit -- Beyond the Book -- Where to Go from Here -- Lesson 1: Creating Basic Worksheets -- Understanding the Excel Interface -- Typing and Editing Cell Content -- Changing the Worksheet Structure -- Working with Worksheets -- Summing Up -- Lesson 2: Creating Formulas and Functions -- Introducing Formulas -- Moving and Copying Formulas -- Introducing Functions -- Working with Named Ranges -- Using Quick Analysis -- Summing Up -- Lesson 3: Formatting and Printing Worksheets -- Adjusting Rows and Columns -- Formatting an Entire Worksheet -- Using Theme Formatting -- Printing Worksheets -- Summing Up -- Lesson 4: Formatting Data -- Formatting Cells -- Formatting Cell Content -- Formatting Numbers -- Using Conditional Formatting -- Summing Up -- Lesson 5: Storing and Managing Tables and Lists -- Understanding Databases -- Working with Tables in Excel -- Merging and Splitting Data -- Summing Up -- Lesson 6: Exploring Financial Functions and Scenarios -- Exploring Financial Functions -- Analyzing Data -- Creating Scenarios -- Working with Named Ranges -- Summing Up -- Lesson 7: Working with Math, Statistical, and Text Functions -- Using Math Functions -- Using Statistical Functions -- Formatting Data with Text Functions -- Summing Up -- Lesson 8: Creating and Formatting Charts -- Creating a Basic Chart -- Changing a Chart -- Adding and Positioning Chart Elements -- Formatting a Chart -- Summing Up -- Lesson 9: Working with PivotTables and PivotCharts -- Creating a PivotTable -- Sorting and Filtering PivotTable Data -- Modifying a PivotTable -- Creating a PivotChart -- Summing Up -- Lesson 10: Correcting and Validating Data -- Finding and Fixing Errors in Formulas -- Validating Data -- Summing Up.

Lesson 11: Protecting and Sharing Data -- Protecting Ranges -- Securing Workbooks -- Tracking Changes in a Shared Workbook -- Summing Up -- Appendix: About the CD -- Contents of This CD -- System Requirements -- Accessing the Excel eCourse -- Using the CD -- Customer Care -- About the Author.