Excel 2002 Formulas covers every aspect of formulas, including some unusual uses -- such as chart series and conditional formatting specifications. This book answers virtually all formula-related questions posed in Excel newsgroups on the Internet. Plus, it contains a coupon for Walkenbach's Professional Power Utility Pak.
Auflage
Sprache
Verlagsort
Verlagsgruppe
Illustrationen
Maße
Höhe: 23.3 cm
Breite: 18.9 cm
Dicke: 45 mm
Gewicht
ISBN-13
978-0-7645-4800-0 (9780764548000)
Schweitzer Klassifikation
John Walkenbach is a principal of JWalk and Associates, Inc., a consulting firm that specializes in spreadsheet application development, and is the author of more than two dozen books, including, most recently, Excel 2002 Bible and Excel 2002 Power Programming with VBA. He maintains "The Spreadsheet Page," a popular Web resource at www.j-walk.com/ss.
Preface.
Acknowledgments.
PART I: Basic Information.
Chapter 1: Excel in a Nutshell.
Chapter 2: Basic Facts about Formulas.
Chapter 3: Working with 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 and Summing Techniques.
Chapter 8: Lookups.
Chapter 9: Databases and Lists.
Chapter 10: Miscellaneous Calculations.
PART III: Financial Formulas.
Chapter 11: Introducing Financial Formulas.
Chapter 12: Discounting and Depreciation Financial Functions.
Chapter 13: Advanced Uses of Financial Functions and Formulas.
PART IV: Array Formulas.
Chapter 14: Introducing Arrays.
Chapter 15: Performing Magic with Array Formulas.
PART V: Miscellaneous Formula Techniques.
Chapter 16: Intentional Circular References.
Chapter 17: Charting Techniques.
Chapter 18: Pivot Tables.
Chapter 19: Conditional Formatting and Data Validation.
Chapter 20: Creating Megaformulas.
Chapter 21: Tools and Methods for Debugging Formulas.
PART VI: Developing Custom Worksheet Functions.
Chapter 22: Introducing VBA.
Chapter 23: Function Procedure Basics.
Chapter 24: VBA Programming Concepts.
Chapter 25: VBA Custom Function Examples.
Appendixes.
Appendix A: Working with Imported 1-2-3 Files.
Appendix B: Excel Function Reference.
Appendix C: Using 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.
