Books & Videos

Table of Contents

  1. Excel 2000 Overview

    1. Chapter 1 Excel Basics

      1. Installing Excel 2000
      2. Opening Excel
      3. Excel Menus and Shortcuts
    2. Chapter 2 Excel Anatomy

      1. The Excel Window
      2. The External Side of Excel
      3. Using Styles
      4. Customizing in Excel
  2. Menu Reference

    1. Chapter 3 File

      1. Microsoft Excel Files
    2. Chapter 4 Edit

      1. Windows Clipboard Versus Office Clipboard
    3. Chapter 5 View

    4. Chapter 6 Insert

      1. Insert → Cells
      2. Insert → Rows
      3. Insert → Columns
      4. Insert → Worksheet
      5. Insert → Chart
      6. Insert → Page Break
      7. Insert → Function
      8. Insert → Name
      9. Insert → Comment
      10. Insert → Picture
      11. Insert → Object
      12. Insert → Hyperlink
      13. Some Hyperlink Tips
    5. Chapter 7 Format

    6. Chapter 8 Tools

    7. Chapter 9 Data

    8. Chapter 10 Chart

      1. Column Charts
  3. Function Reference

    1. Chapter 11 Working with Functions

      1. Function or Formula?
      2. Function Categories
      3. Function Arguments
      4. Inserting a Function
    2. Chapter 12 Financial Functions

      1. Understanding the Financial Jargon
      2. The Financial Functions
    3. Chapter 13 Date and Time Functions

      1. How Excel Stores Dates and Times
    4. Chapter 14 Mathematics and Trigonometry Functions

      1. Understanding Math Lingo
    5. Chapter 15 Statistical Functions

      1. Common Statistical Terminology
      2. The Statistical Functions
    6. Chapter 16 Lookup and Reference Functions

      1. The Lookup and Reference Functions
    7. Chapter 17 Database Functions

      1. The Database Functions
    8. Chapter 18 Text Functions

      1. The Text Functions
    9. Chapter 19 Logical Functions

      1. The Logical Functions
    10. Chapter 20 Information Functions

      1. The Information Functions
  4. Appendices

    1. Appendix Keyboard Shortcuts

    2. Appendix Tip Reference

  1. Colophon