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.
Even if you’re already pretty fancy when it comes to spreadsheets, you’ll want to have this book handy so you can find that one function you’re always forgetting.
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?
What do you need to calculate? Manufacturing output? A curve for test scores? Sports stats? You and Excel can do it, and this non-intimidating guide shows you how.
The book covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries.
This book shows you how to access and use the features and techniques for organizing, manipulating, and summarizing just about anything that resides in a worksheet.
Describes the basics of formulas and fuctions of Microsoft Excel with information on such topics as calculating loan payments, using prediction and probability functions, using time functions, and working with text functions.
Most businesses are drowning in data, and making sense of it all is critical. Excel is a powerful data analysis tool, and this book shows you how to use it and become a data deciphering expert.
The bestselling Excel book on the market — now in a new edition covering the latest version of Excel!
If you’ve got this book and a working version of Microsoft Excel, you’ve got all the tools you need to build sophisticated and useful financial models in no time!
Excel Formulas & Functions For Dummies Excel Formulas & Functions For Dummies. case, text, 320–321 CASE function, 373 cash flow, 86 CEILING function, 126, 127–129 CELL function, 289–294 cells about, 13–17 address, 14 entering as ...