Microsoft^® Office Excel^® 2007 Formulas & Functions For Dummies^®

by Ken Bluttman; Peter G. Aitken (PGA Consulting, Chapel Hill, NC)

• ISBN13: 9780470377390
• ISBN10: 0470377399
• Format: eBook
• Copyright: 2008-02-01
• Publisher: For Dummies

Summary

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

Putting the Fun in Functions.

Tapping into Formula and Function Fundamentals

Saving Time with Function Tools

Saying ôArray!ö for Formulas and Functions

Fixing Formula Boo-Boos

Counting on Your Money.

Calculating Loan Payments and Interest Rates

Appreciating What YouÆll Get, Depreciating What You Got

Using Basic Math Functions

Advancing Your Math

Throwing Statistics a Curve

Using Significance Tests

Doing the Math.

Rolling the Dice on Predictions and Probability

Dressing Up for Date Functions

Keeping Well-Timed Functions

Using Lookup, Logical, and Reference Functions

Digging Up the Facts

Working with Data.

Writing Home about Text Functions

Playing Records with Database Functions

The Part of Tens.

Ten-Plus Tips for Working with Formulas

Ten-Plus Functions You Really Should Know

Index.

Table of Contents provided by Publisher. All Rights Reserved.