Microsoft Excel 2002 Formulas free download online
Title: Microsoft Excel 2002 Formulas Author(s): John Walkenbach Pages: 760 Publisher: Wiley Publication date: 2001 Language: English Format: PDF ISBN-10: 076454800X ISBN-13: Description: 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.
CONTENTS
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
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
Microsoft Excel 2002 Formulas free download links:
Title: Microsoft Excel 2002 Formulas