Microsoft Office Excel 2007 Formulas & Functions For Dummies (Paperback)

Ken Bluttman

  • 出版商: Hungry Minds
  • 出版日期: 2007-02-01
  • 售價: $970
  • 貴賓價: 9.5$922
  • 語言: 英文
  • 頁數: 384
  • 裝訂: Paperback
  • ISBN: 0470046554
  • ISBN-13: 9780470046555
  • 相關分類: Excel
  • 已過版




* Readers discover how to exploit the power of Excel 2007 with detailed instructions that explore specialized Excel functions
* Explains how and why readers should use a particular function, then gives examples of how that function is used within a formula to solve real-world problems
* Examples of Excel formulas and functions show how to compare 15year vs. 30year mortgage terms, choose between leasing or buying a car, compute classroom grades, determine election results, evaluate investment performance, calculate the real cost of credit card purchases, design a database, forecast college expenses and savings, and much more
Table of Contents

Part I: Putting the Fun in Functions.

Chapter 1: Tapping into Formula and Function Fundamentals.

Chapter 2: Saving Time with Function Tools.

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

Chapter 4: Fixing Formula Boo-Boos.

Part II: Counting on Your Money.

Chapter 5: Calculating Loan Payments and Interest Rates.

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

Chapter 7: Using Basic Math Functions.

Chapter 8: Advancing Your Math.

Chapter 9: Throwing Statistics a Curve.

Chapter 10: Using Significance Tests.

Part III: Doing the Math.

Chapter 11: Rolling the Dice on Predictions and Probability.

Chapter 12: Dressing Up for Date Functions.

Chapter 13: Keeping Well-Timed Functions.

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

Chapter 15: Digging Up the Facts.

Part IV: Working with Data.

Chapter 16: Writing Home about Text Functions.

Chapter 17: Playing Records with Database Functions.

Part V: The Part of Tens.

Chapter 18: Ten-Plus Tips for Working with Formulas.

Chapter 19: Ten-Plus Functions You Really Should Know.