• Print

Excel Formulas and Functions For Dummies, 3rd Edition

ISBN: 978-1-118-46084-9
Paperback
408 pages
February 2013
This title is out-of-print and not currently available for purchase from this site.

• Author Information

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

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
 About us More From Dummies Topics A-Z