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

### Ken Bluttman

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

## 商品描述

Description

* 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

Introduction.

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 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.

Index.