Overview

Put the power of Excel formulas and functions to work for you! Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work. You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier. See how to use 150 of Excel's most useful functions, with real-world examples showing how each function is used within a formula Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well Includes essential coverage of an additional 85 functions In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel's power accessible to you.

Full Product Details

Author:   Ken Bluttman ,  Peter G. Aitken
Publisher:   John Wiley and Sons Ltd
Imprint:   John Wiley & Sons Ltd
Edition:   2nd Revised edition
Dimensions:   Width: 19.00cm , Height: 2.10cm , Length: 23.50cm
Weight:   0.588kg
ISBN:  

9780470568163

ISBN 10:   047056816
Pages:   384
Publication Date:   11 May 2010
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Out of Print
Availability:   Awaiting stock  

Table of Contents

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: Doing the Math. Chapter 5: Calculating Loan Payments and Interest Rates. Chapter 6: Appreciating What You'll Get, Depreciating What You've Got. Chapter 7: Using Basic Math Functions. Chapter 8: Advancing Your Math. Part III: Solving with Statistics. Chapter 9: Throwing Statistics a Curve. Chapter 10: Using Signifi cance Tests. Chapter 11: Rolling the Dice on Predictions and Probability. Part IV: Working with Data. 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. Chapter 16: Writing Home about Text Functions. Chapter 17: Playing Records with Database Functions. Part V: The Part of Tens. Chapter 18: Ten Tips for Working with Formulas. Chapter 19: Ten Functions You Really Should Know. Chapter 20: Some Really Cool Functions. Index.

Reviews

Author Information

Ken Bluttman has been a software developer for 20 years. He is the author of several books, including Excel Charts For Dummies . Peter Aitken has written about computers and programming for over 10 years and has written more than 35 books, including Excel Programming Weekend Crash Course .

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions