|
Excel 2000 Formulas
This one-of-a-kind reference delivers all the tips and techniques you need to maximize one of the most powerful spreadsheet tools: formulas. With clear explanations of operators, nesting, and functions plus hundreds of practical, real-world examples, spreadsheet expert John Walkenbach shares proven solutions for typical (and not-to-typical) Excel challenges.
From working with dates to performing table lookups to creating array formulas, this in-depth guide will help you supercharge your spreadsheets -- and make the most of Excel.
Preface.
Acknowledgments.
PART I: Basic Information.
Chapter 1: Excel in a Nutshell.
Chapter 2: Basic Facts About Formulas.
Chapter 3: Using Names.
PART II: Using Functions in Your Formulas.
Chapter 4: Introducing Worksheet Functions.
Chapter 5: Manipulating Text.
Chapter 6: Working with Dates and Times.
Chapter 7: Counting Techniques.
Chapter 8: Lookups.
Chapter 9: Databases and Lists.
Chapter 10: Financial Calculations.
Chapter 11: Miscellaneous Calculations.
PART III: Array Formulas.
Chapter 12: Introducing Arrays.
Chapter 13: Performing Magic with Array Formulas.
PART IV: Miscellaneous Formula Techniques.
Chapter 14: Intentional Circular References.
Chapter 15: Charting Techniques.
Chapter 16: Pivot Tables.
Chapter 17: Conditional Formatting and Data Validation.
Chapter 18: Creating Megaformulas.
Chapter 19: Tools and Methods for Debugging Formulas.
PART V: Developing Custom Worksheet Functions.
Chapter 20: Introducing VBA.
Chapter 21: Function Procedure Basics.
Chapter 22: VBA Programming Concepts.
Chapter 23: VBA Function Examples.
Appendix A: Working with Imported 1-2-3 Files.
Appendix B: Excel's Function Reference.
Appendix C: Custom Number Formats.
Appendix D: Additional Excel Resources.
Appendix E: What's on the CD-ROM?
Index.
End-User License Agreement.
CD-ROM Installation Instructions.
|
