Books & Videos

Table of Contents

  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

      1. Controlling Your View
      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
      4. Trigonometry and Advanced Math
      5. Advanced Statistics
    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
      2. Advanced Lookups
      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
      2. Basic Tasks with Charts
      3. Practical Charting
      4. Chart Types
    2. Chapter 17 Formatting and Perfecting Charts

      1. Formatting Chart Elements
      2. Improving Your Charts
      3. Advanced Charting
    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
  5. Advanced Data Analysis

    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
      3. Advanced Pivot Tables
  6. Sharing Data with the Rest of the World

    1. Chapter 21 Worksheet Collaboration

      1. Your Excel Identity
      2. Using Comments
      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
      2. Embedding and Linking Objects
      3. Transferring Data
      4. Excel and Databases
    3. Chapter 23 XML

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

      1. Putting Worksheets on the Web
      2. Performing Web Queries
      3. Using Hyperlinks
  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

      1. Asking Questions
      2. The Office Assistant
      3. Other Help Menu Options
    2. Appendix B Customizing Excel

      1. The Customize Dialog Box
    3. Appendix C Quick Menu Reference

      1. File Menu
      2. Edit Menu
      3. View Menu
      4. Insert Menu
      5. Format Menu
      6. Tools Menu
      7. Data Menu
      8. Chart Menu
      9. Window Menu
      10. Help Menu
  1. Colophon