MS Excel 2010 Formulas

Contents at a Glance

Introduction
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: Using Lookup Functions
Chapter 9: Tables and Worksheet Databases
Chapter 10: Miscellaneous Calculations

Part III: Financial Formulas
Chapter 11: Borrowing and Investing Formulas
Chapter 12: Discounting and Depreciation Formulas
Chapter 13: Financial Schedules

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

Part VII: Appendixes
Appendix A: Excel Function Reference
Appendix B: Using Custom Number Formats
Appendix C: Additional Excel Resources
Appendix D: What’s on the CD-ROM?
Index.
Please download here
Kindly Bookmark this Post using your favorite Bookmarking service: