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. In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel's power accessible to you.
Maybe helpful for a beginner, but this book is not as helpful a reference as Microsoft for an advanced user. Any time I need help, Microsoft has a video on any function. I'm also learning a lot from Excel webinars.
Having had to lookup and manipulate text strings for the past 3 years, I can hardly say there were any surprises in that section of the book, although it did provide a good summary.
Fianncial modelling, forecasting and statistics formulae, however, were a different kettle of fish and I will be sure to revisit if I ever find myself in need of creating analysis on the basis of those.
Wish I'd read this years ago. Would've saved me so much time and so many headaches. Very hand how-to to keep around your desk in case you need a reminder.