Excel Formulas and Functions For DummiesLearn to use Excel for practical, day-to-day calculations Excel is a powerful program with more than 300 built-in functions that can be used to perform an almost infinite number of calculations. This friendly book shows you how to use the 150 most valuable ones in real-world situations: to compare the cost of buying vs. leasing a car, calculate classroom grades, or evaluate investment performance, for example. Another 85 specialized functions are also described. Detailed, step-by-step instructions help you understand how functions work within formulas and how you can use them to solve everyday problems.
Excel Formulas and Functions For Dummies, 3rd Edition helps you put the power of Excel to work in your daily life. |
What people are saying - Write a review
excel
I've gone through this book. its good and i need some additional formula and functions what we exactly use as rare functions. is there any option to get its soft copy anyways???? if so pl let me know.
Contents
Introduction | 1 |
Putting the Fun in Functions | 5 |
Tapping into Formula and Function Fundamentals | 7 |
Saving Time with Function Tools | 39 |
Saying Array for Formulas and Functions | 57 |
Fixing Formula BooBoos | 69 |
Doing the | 87 |
Calculating Loan Payments and Interest Rates | 89 |
Using Signiﬁcance Tests | 205 |
Rolling the Dice on Predictions and Probability | 215 |
Working with Data | 233 |
Dressing Up for Date Functions | 235 |
Keeping WellTimed Functions | 255 |
Using Lookup Logical and Reference Functions | 265 |
Digging Up the Facts | 297 |
Writing Home about Text Functions | 311 |
Appreciating What Youll Get Depreciating What Youve Got | 109 |
Using Basic Math Functions | 125 |
Advancing Your Math | 143 |
Solving with Statistics 765 | 165 |
Throwing Statistics a Curve | 167 |
Playing Records with Database Functions | 337 |
The Part of Tens | 353 |
Ten Functions You Really Should Know | 365 |
Some Really Cool Functions | 371 |
Other editions - View all
Microsoft Office Excel 2007 Formulas and Functions For Dummies Ken Bluttman,Peter G. Aitken Limited preview - 2008 |