Microsoft Office Excel 2007 Formulas Functions For Dummies For Dummies Computer Tech 1st Edition by Ken Bluttman, Peter G Aitken ISBN 0470377399 9780470377390

Microsoft Office Excel 2007 Formulas Functions For Dummies For Dummies Computer Tech 1st Edition by Ken Bluttman, Peter G. Aitken – Ebook PDF Instant Download/Delivery: 0470377399, 9780470377390

Full download Microsoft Office Excel 2007 Formulas Functions For Dummies For Dummies Computer Tech 1st Edition after payment

Product details:

ISBN 10: 0470377399

ISBN 13: 9780470377390 

Author: Ken Bluttman, Peter G. Aitken

Make Excel do the math and make sense of your data

Use the Insert Function dialog box, array formulas and functions, and more

Excel 2007 has more than 500 built-in functions. This book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing? Here’s the fun and easy way!

Discover how to
* Create worksheets to track costs and revenue
* Tell the difference among average, median, and mode
* Work with statistical functions
* Develop forecasts and track trends
* Manipulate strings and work with database functions

Table of contents:

Introduction.
Part 1: 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.
Index..

People also search for:

microsoft office excel 2007 formulas functions
    
microsoft excel functions and formulas list
    
excel 2007 functions
    
microsoft excel 2016 formulas and functions
    
excel 2007 functions and formulas pdf

Tags: Ken Bluttman, Peter G Aitken, Microsoft Office, Excel 2007, Formulas, Functions, Dummies