3 Review(s)

Microsoft Excel 2010 Formulas, authored by John Walkenbach, is an excellent reference book for all those who use Microsoft Excel. It has been estimated by experts that only ten percent of Excel users have an understanding of utilising worksheet formulas to its optimum. This book thus provides elaborate details on all the methods that can be used to enhance the power of Excel with the help of formulas keeping in mind all new features incorporated in Excel 2010. First, the author explains the meaning of formula, how can you create one, and what it can do. Secondly, he talks about using functions in the formulas and then exploring specific types of formulas, such as financial and array formulas. Lastly, he construes how to apply the formulas to pivot tables and charts, how to troubleshoot them, build custom functions, and more. This extraordinary book helps its readers master the formulas to gain greater excel functionality. Although the book has been written for Excel 2010, most of the material also applies to Excel 2007 but cannot be used for any other version. John Walkenbach is an important figure in spreadsheet software. He works as a Principal at J-Walk and Associates Inc., which is a  single person consulting firm based in South Arizona. John is the creator of Power Utility Pak and his other books include 101 Ready-To-Use Excel Macros, Excel 2010 Bible, and Excel 2010 Power Programming with VBA. He has received a Microsoft MVP award each year since 2000 and has authored more than fifty spreadsheet books along with three hundred reviews and articles for a variety of publications. He also maintains a popular website at spreadsheetpage.com.