Thank you for visiting us. We are currently updating our shopping cart and regret to advise that it will be unavailable until September 1, 2014. We apologise for any inconvenience and look forward to serving you again.

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