1. Home
  2. Education
  3. Mathematics

Excel Formulas

About.com Rating 5

By Deb Russell, About.com

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.
Compare Prices

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, and maintains the popular Spreadsheet Page at this site.

Compare Prices
User Reviews Write Review

Explore Mathematics

About.com Special Features

A Smarter Future

Tips that will help finance your education, excel in the classroom, and advance your career. More >

How to Ace the GRE

Being well prepared is the first step; here are more essential suggestions. More >

  1. Home
  2. Education
  3. Mathematics
  4. Books, Resources, DVDs
  5. Reference, Software, Orgs.
  6. Software
  7. Excel
  8. Excel Formulas>

©2009 About.com, a part of The New York Times Company.

All rights reserved.