Dummies.com
  • Print
  • Share
  • Get technical support for this product
Excel 2003 Formulas (0764540734) cover image

Excel 2003 Formulas

ISBN: 978-0-7645-4073-8
Paperback
864 pages
October 2003
US $44.99 Add to Cart

This price is valid for United States. Change location to view local pricing and availability.

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: Using Lookup Functions.

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.

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.

Buy Both and Save 25%!

+ Buy Excel 2003 Formulas (List Price: US $44.99)
with Excel 2003 Power Programming with VBA (List Price = US $49.99)
Total List Price: US $94.98
Discounted Price: US $71.23
You Save: US $23.75 Add BOTH to Cart
Cannot be combined with any other offers. Learn more.
  • Print
  • Share
  • Get technical support for this product