Microsoft excel 2000 Bible / John Walkenbach.

Table of Content

PART I: GETTING STARTED

Chapter 1: What's New in Excel 2000?
Installation Improvements
New Internet Features
New File Dialog Boxes
Pivot-Table Enhancements
Automatic Formula Adjustment
Etc.

Chapter 2: Getting Acquainted with Excel
Starting Excel
Excel's Parts
Parts of a Work books Window
A Hands- on Excel Session

Chapter 3: Navigating Through Excel
Working with Excel's Window
Moving a round a Worksheet
Giving Commands to Excel
Using Excels Menus
Using Shortcut Menus
Etc.

Chapter 4: Working with Files and Workbooks
Some Background on Files
How Excel Uses Files
Essential Workbook File Operations
Using Template Files
Protecting Your Work

PART II: WORKING WITH EXCEL

Chapter 5: Entering and Editing Worksheet Data
Types of Worksheet Data
Entering Values
Entering Text
Dates and Times
Changing or Erasing Values and Text
Etc.

Chapter 6: Essential Spreadsheet Operation
Working with Worksheets
Views, Split-sheets, and Frozen Panes
Working with Rows and Columns

Chapter 7: Working with Cell Ranges
Cells and Ranges
Annotating a Cell
Deleting Cell Contents
Copying a Range
Copying a Range to Other Sheets
Etc.

Chapter 8: Creating and Using Formulas
Introducing Formulas
Entering Formulas
Referencing Cells Outside the Worksheet
Absolute Versus Relative References
When a Formula Returns An Error
Etc.

Chapter 9: Using Worksheet Functions
What is a Function?
Function Arguments
Ways to Enter a Function
Function Examples
Creating Mega-formulas
Etc.

Chapter 10: Manipulating Text
A Few Words About Text
Text Functions
Advanced Text Formulas
Custom VBA Text Functions

Chapter 11: Working with Dates and Times
How Excel Handles Dates and Times
Date-Related Functions
Tim-Related Functions

Chapter 12: Counting and Summing Formulas
Counting and Summing Worksheet Cells
Counting or Summing Records in Databases and Pivot Tables
Basic Counting Formulas
Advanced Counting Formulas
Summing Formulas
Etc.

Chapter 13: Lookup Formulas
What is Lookup Formula?
Functions Relevant to Lookups
Basic Lookup Formulas
Specialized Lookup Formulas

Chapter 14: Printing Your Work
One-Step Printing
Adjusting Your Print Settings
Settings in the Print Dialog Box
Using Print Preview
Dealing with Page Breaks
Etc.

Chapter 15: Customizing Toolbars and Menus
Menu Bar = Tool Bar
Customizing Tool Bars
Moving Tool Bars
Using the Customized Dialog Box
Adding or Removing Toolbar Buttons
Etc.

Chapter 16: Using and Creating Templates
An Overview of Templates
The Default Worksheet Template
Custom Workbook Template
Creating Custom Templates
Ideas for Creating Templates

PART III: ADDING VISUAL ELEMENTS

Chapter 17: Worksheet Formatting
Overview of Stylistic Formatting
Working with Fonts
Changing Cell Alignment
Colors and Shading
Borders and Lines
Etc.

Chapter 18:Chart-Making Basics
Overview of Charts
How Excel Handles Charts
Creating Charts
Creating a Chart with a Chart Wizard
Basic Chart Modifications
Etc.

Chapter 19: Advanced Charting
Chart Customization: An Overview
Chart Background Elements
Working with Data Series
Creating Combination Charts
Chart-Making Tricks
Etc.

Chapter 20: Enhancing Your Work with Pictures and Drawings
Importing Graphics Files
Using Excel's Drawing Tools
Using WardArt
Drawing Tips
A Gallery of Drawing Examples
Etc.

Chapter 21: Creating Maps with Microsoft Maps
Mapping an Overview
Creating a Map
Customizing Maps
Converting a Map to a Picture
Etc.

Chapter 22: Putting it all together
The Audience for Spreadsheets
Characteristics of a Successful Spreadsheet
Uses of Spreadsheets
Steps in Creating a Spreadsheet
A Workbook that's Easy to Maintain

PART IV: ADVANCED EXCEL FEATURES

Chapter 23: Creating and Using Worksheet Outlines
Introducing Worksheet Outlines
Creating an Outline
Using Outlines

Chapter 24: Linking and Consolidating Worksheets
Linking Workbooks
Consolidating Worksheets

Chapter 25:Introducing Arrays
Array Formulas
Dimensions of an Array
Naming Array Constants
Working with Array Formulas
Multi-cell Array Formulas
Etc.

Chapter 26: Performing Magic with Array Formulas
More Single-Cell Array Formulas
More Multi-Cell Array Formulas
Returning an Array from a Custom VBA Function

Chapter 27: Using Excel in a Work-group
Using Excel on a Network
File Reservations
Shared Workbooks
Mailing and Routing Workbooks

Chapter 28: Sharing Data with Other Applications
Sharing Data with Other Windows Applications
Using the Windows or Office Clipboards
Linking Data
Copying Excel Data to Word
Embedding Objects
Etc.

Chapter 29: Excel and the Internet
What is Internet?
Excel's Internet

Chapter 30: Making Your Worksheets Error-Free
Types of Worksheet Problems
Formula Auto-Correct
Tracing Cell Relationships
Other Auditing Tools
Spellings and Word-Related Options
Etc.

Chapter 31: Fun Staff
Games
Power Utility Pak Games
Animated Shapes
Symmetrical Pattern Drawing
For Guitar Players
Etc.

PART V: ANALYZING DATA WITH EXCEL
Chapter 32: Importing Data From Other Sources
Chapter 33: Working with Lists
Chapter 34: Using External Database Files
Chapter 35:Analyzing Data with Pivot Tables
Chapter 36: Performing Spreadsheet with What-if Analysis
Etc.

PART VI: PROGRAMMING EXCEL 2000 WITH VBA
Chapter 39: Essentials of Spreadsheet Application Development
Chapter 40: Introducing Visual Basic for Application
Chapter 41: VBA Programming Fundamentals
Chapter 42: Working with VBA Sub Procedures
Chapter 43: Creating Custom Worksheet Functions
Etc.

includes index : p.1341-1381