List of Sidebars

Chapter 1: Excel in a Nutshell

How Big Is a Worksheet?

What's New in Excel 2007?

Data-Entry Tips

Chapter 2: Basic Facts about Formulas

Using the Formula Bar as a Calculator

Don't Hard-Code Values

A1 versus R1C1 Notation

When to Use AutoFill Rather Than Formulas

Chapter 3: Working with Names

Rules for Naming Names

Hidden Names

Naming Objects

Chapter 4: Introducing Worksheet Functions

Accommodating Former Lotus 1-2-3 Users

Let Excel Insert Functions for You

Volatile Functions

Chapter 5: Manipulating Text

When a Number Isn't Treated as a Number

How to Find Special Characters

Transforming Data with Formulas

Splitting Text Strings without Using Formulas

Chapter 6: Working with Dates and Times

Choose Your Date System: 1900 or 1904

Searching for Dates

Where's the DATEDIF Function?

Calculating Easter

Chapter 7: Counting and Summing Techniques

Getting a Quick Count or Sum

About This Chapter's Examples

Creating Bins for a Frequency Distribution

Is the Analysis ToolPak Installed?

Let a Wizard Create Your Formula

Chapter 8: Using Lookup Functions

When a Blank Is Not a Zero

Chapter 9: Tables and Worksheet Databases

Designing a Worksheet Database or Table

Table Limitations

Excel Remembers

Using a Data Form

About the SUBTOTAL Function

Filling in the Gaps

Chapter 10: Miscellaneous Calculations

Need to Convert Other Units?

Chapter 11: Borrowing and Investing Formulas

Financial Function Arguments

Rounding of Financial Formulas

Chapter 14: Introducing Arrays

Array Formulas: The Downside

Worksheet Functions That Return an Array

TRUE and FALSE in Array Formulas

Chapter 15: Performing Magic with Array Formulas

About the Examples in This Chapter

Illogical Behavior from Logical Functions

Using Excel's Formula Evaluator

Chapter 16: Intentional Circular References

About Circular References

More about Circular References

Chapter 17: Charting Techniques

Chart-Making Tips

Handling Missing Data

Chapter 18: Pivot Tables

Pivot Table Terminology

Pivot Table Calculations

Copying a Pivot Table

Chapter 19: Conditional Formatting and Data Validation

Excel 2007 Improvements

Using Custom Worksheet Functions in Data Validation Formulas

Chapter 20: Creating Megaformulas

Copying Text from a Formula

Chapter 21: Tools and Methods for Debugging Formulas

Research on Spreadsheet Errors

Using Formula AutoCorrect

Tracing Error Values

Pay Attention to the Colors

Third-Party Auditing Tools

Chapter 23: Function Procedure Basics

What Custom Worksheet Functions Can't Do

Using the Immediate Window

A Few Words about Passwords

Chapter 24: VBA Programming Concepts

Forcing Yourself to Declare All Variables

Chapter 25: VBA Custom Function Examples

Using the Functions in This Chapter

Understanding Object Parents

Worksheet Function Data Types

Controlling Function Recalculation

Appendix B: Using Custom Number Formats

Pre-formatting Cells

Where Did Those Number Formats Come From?

Testing Custom Number Formats

Formatting Numbers Using the TEXT Function

Displaying a Number Format String in a Cell

Appendix C: Additional Excel Resources

A Dozen Tips for Posting to a Newsgroup