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
Excel Formulas and Functions For Dummies, 3rd Edition (1118460847) cover image

Excel Formulas and Functions For Dummies, 3rd Edition

ISBN: 978-1-118-46084-9
Paperback
408 pages
February 2013
US $24.99 Add to Cart

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

Introduction 1

Part I: Putting the Fun in Functions 5

Chapter 1: Tapping into Formula and Function Fundamentals 7

Chapter 2: Saving Time with Function Tools 39

Chapter 3: Saying “Array!” for Formulas and Functions 57

Chapter 4: Fixing Formula Boo-Boos 69

Part II: Doing the Math 87

Chapter 5: Calculating Loan Payments and Interest Rates 89

Chapter 6: Appreciating What You’ll Get, Depreciating What You’ve Got 109

Chapter 7: Using Basic Math Functions 125

Chapter 8: Advancing Your Math 143

Part III: Solving with Statistics 165

Chapter 9: Throwing Statistics a Curve 167

Chapter 10: Using Signifi cance Tests 205

Chapter 11: Rolling the Dice on Predictions and Probability 215

Part IV: Working with Data 233

Chapter 12: Dressing Up for Date Functions 235

Chapter 13: Keeping Well-Timed Functions 255

Chapter 14: Using Lookup, Logical, and Reference Functions 265

Chapter 15: Digging Up the Facts 297

Chapter 16: Writing Home about Text Functions 311

Chapter 17: Playing Records with Database Functions 337

Part V: The Part of Tens 351

Chapter 18: Ten Tips for Working with Formulas 353

Chapter 19: Ten Functions You Really Should Know 365

Chapter 20: Some Really Cool Functions 371

Index 377

  • Print
  • Share