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




Excel 2007 Formulas
Excel 2007 Formulas (Mr. Spreadsheets Bookshelf)
ISBN: 0470044020
EAN: 2147483647
Year: 2007
Pages: 212

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net