Books & Videos

Table of Contents

  1. Chapter 1 Understanding Excel

    1. What's New in Excel 2007

    2. The Excel 2007 Interface

    3. The Anatomy of an Excel File

    4. Formatting

    5. Shortcut Menus and the Mini Toolbar

    6. How Excel Tries to Help

  2. Chapter 2 Excel Tasks

    1. Working with Files

    2. Printing

    3. Moving Around in a Workbook or Worksheet

    4. Manipulating Workbooks and Worksheets

    5. Manipulating Rows, Columns, and Cells

    6. Entering and Editing Data

    7. Formatting

    8. Working with Hyperlinks

    9. Working with Headers and Footers

    10. Summarizing Data

    11. Using Named Ranges

    12. Defining Alternative Data Sets

    13. Controlling How Data Is Displayed

    14. Protecting All or Part of a Workbook

    15. Spelling and Other Tools

    16. Customizing Excel

    17. Collaborating

    18. Working with the Web

    19. Summarizing Data with Charts

    20. Analyzing Data with PivotTables and PivotCharts

  3. Chapter 3 Formula Reference

    1. New Formulas in Excel 2007

    2. Math Formulas

    3. Date and Time Formulas

    4. Financial Formulas

    5. Lookup and Reference Formulas

    6. Logical Formulas

    7. Text Formulas

    8. Statistical Formulas

  4. Chapter 4 Excel Reference

    1. Command Reference

    2. Native Formats

    3. Startup Switches

    4. Wildcards in Filters and Searches

    5. Default File Locations

    6. Keyboard Shortcuts

  5. Chapter 5 Excel Resources

    1. Internet Sites

    2. Books

    3. Excel Utilities