1. Education

Discuss in my forum

Excel Formulas

About.com Rating 5 Star Rating
Be the first to write a review

By , About.com Guide

The Bottom Line

Author John Walkenbach is the guru of Excel and it shows again with this title. This text concentrates on Excel’s vast formula tools and covers the various categories so a reader can spend time on the formulas that will be of most use to them.
<!--#echo encoding="none" var="lcp" -->

Pros

  • Meets the needs of all level of users - something for everyone.
  • Outsanding resource for Excel users.
  • Wonderful examples of handing complex calculation techniques.

Cons

  • Could have stood more pages and ideas for pure Mathematics applications.
  • Back cover claims coverage of XML data and mapping ideas yet it is not identified in the book.

Description

  • Walkenbach provides the why of how certain things work and why they don't. Great for math formulas.
  • What I really liked about this book is the way something complex becomes something simple!
  • The accompanying CD is chalk full of goodies. Far superior than Microsoft's version.
  • Maximizes your use of Excel's most powerful tool - the formulas.
  • This book reveals the many hidden secrets of Excel. Well worth the investment - time saved!
  • Very user friendly - get your highlighter ready as you'll be wanting to use these tricks often.
  • Any review I've read on this book has been positive and results in 5 star ratings.
  • A must have for the Excel user!

Guide Review - Excel Formulas

Walkenbach's insightful ideas for 'megaformulas' and tips on tackling complex calculations using simple answers is the reason to buy this book.. His insight into the use of Array formulas may be the one and only explanation that has available in print and comments on the use of VBA hit home for the power user who has experienced the speed constraints of this feature.

A solid attempt at the ‘ Ultimate Excel resource’; it provides detail in introduction and detail in the use of Visual Basic for Application in the same book.

Product Description: A comprehensive text composed of: 1. Introduction to Excel. 2. Using Functions and Functions by Category. 3. Comprehensive look at Financial and Array Functions. 4 Using other Excel tools- Charting and Pivot Tables. 5. Developing Custom Functions using VBA.

CD-ROM included – contains 90 sample spreadsheet files, electronic version of the book and a trial version of Power Utility Pak.

About the Author:

John Walkenbach, principal of JWalk and Associates, Inc., is a leading authority on spreadsheet software and creator of the award winning Power Utility Pak. He has written more than 30 spreadsheet books and over 300 articles and reviews for publications including PCWorld, InfoWorld, and Windows.

<!--#echo encoding="none" var="lcp" -->

©2012 About.com. All rights reserved.

A part of The New York Times Company.