1. ### Worksheet Basics

1. #### Chapter 1 Creating and Navigating Worksheets

1. Creating a Basic Worksheet
2. Editing Data
3. Navigating in Excel
4. Saving Files
5. Opening Files
2. #### Chapter 2 Adding Information to Worksheets

1. Adding Different Types of Data
2. Quick Ways to Add Data
3. #### Chapter 3 Moving Data Around a Worksheet

1. Selecting Cells
2. Moving Cells Around
3. Adding and Moving Columns or Rows
4. #### Chapter 4 Formatting Worksheets

1. Formatting Cell Values
2. Formatting Cell Appearance
3. Smart Ways to Apply Formatting
5. #### Chapter 5 Managing Worksheets and Workbooks

1. Worksheets and Workbooks
2. Find and Replace
3. Spell Check
6. #### Chapter 6 Viewing and Printing Worksheets

2. Printing
2. ### Formulas and Functions

1. #### Chapter 7 Building Basic Formulas

1. Creating a Basic Formula
2. Formula Shortcuts
3. Copying Formulas
2. #### Chapter 8 Math and Statistical Functions

1. Rounding Numbers
2. Groups of Numbers
3. General Math Functions
3. #### Chapter 9 Financial Functions

1. The World of Finance
2. Financial Functions
3. Depreciation
4. Other Financial Functions
4. #### Chapter 10 Manipulating Dates, Times, and Text

1. Manipulating Text
2. Manipulating Dates and Times
3. Math with Dates and Times
4. Date and Time Functions
5. Analysis ToolPak Date Functions
5. #### Chapter 11 Lookup, Reference, and Information Functions

1. The Basic Lookup
3. Information Functions
4. Tutorial: Quickly Generating Invoices from a Product Catalog
6. #### Chapter 12 Advanced Formula Writing

1. Conditions in Formulas
2. Descriptive Names for Cell References
3. Variable Data Tables
4. Controlling Recalculation
5. Solving Formula Errors
3. ### Organizing Worksheets

1. #### Chapter 13 Data Lists

1. The Basics of Data Lists
2. The Data Form
3. Sorting and Filtering a List
4. Performing List Calculations
2. #### Chapter 14 Grouping and Outlining Data

1. Basic Data Grouping
2. Grouping Timesavers
3. #### Chapter 15 Templates

1. Understanding Templates
2. Starting from a Template
3. Creating Templates
4. Fine-Tuning Templates
4. ### Charts and Graphics

1. #### Chapter 16 Creating Basic Charts

1. Charting 101
3. Practical Charting
4. Chart Types
2. #### Chapter 17 Formatting and Perfecting Charts

1. Formatting Chart Elements
3. #### Chapter 18 Inserting Graphics

1. Adding Pictures to a Worksheet
2. Excel's Clip Art Library
3. Drawing Shapes
4. Drawing Graphic Objects in Charts

1. #### Chapter 19 Scenarios and Goal Seeking

1. Using Scenarios
2. Using Goal Seek
3. Solver
2. #### Chapter 20 Pivot Tables

1. Summary Tables Revisited
2. Building Pivot Tables
6. ### Sharing Data with the Rest of the World

1. #### Chapter 21 Worksheet Collaboration

3. Using Change Tracking
4. Setting Up a Review Chain
5. Workbook Sharing
2. #### Chapter 22 Exchanging Data with Other Programs

1. Sharing Information in Windows
3. Transferring Data
4. Excel and Databases
3. #### Chapter 23 XML

1. XML 101
2. The Excel XML Story
4. #### Chapter 24 Connecting Worksheets to the Web

1. Putting Worksheets on the Web
2. Performing Web Queries
7. ### Programming Excel

1. #### Chapter 25 Automating Tasks with Macros

1. Macros 101
2. The Macro Recorder
3. Creating Practical Macros
2. #### Chapter 26 Programming Spreadsheets with VBA

1. The Visual Basic Editor
2. Understanding Macro Code
3. Exploring the VBA Language
8. ### Appendixes

1. #### Appendix A Getting Help in Excel

2. The Office Assistant
2. #### Appendix B Customizing Excel

1. The Customize Dialog Box