Table of Contents

		Excel 2007 Formulas byJohn Walkenbach John Wiley & Sons 2007 (836 pages) ISBN:9780470044025 If you already know your way around Excel 2007 and want to use formulas to extend its capabilities even further, this go-to guide shows how to create financial formulas, use array formulas, develop custom worksheet functions with VBA, and more.

Table of Contents
	Excel 2007 Formulas
	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
	List of Figures
	List of Tables
	List of Sidebars
	CD Content