"I thoroughly enjoyed this book and recommend it to anyone who finds themselves using Excel to do numerical computations beyond the basic spreadsheet operations. The CD provides a wealth of custom functions that extend the usefulness of Excel plus virtually all of the spreadsheets, charts, and VBA code needed to perform the example problems given in the text. This paperback edition and CD are a real bargain." (
Technometrics, May 2008)
"This is a wonderful book for power users of Excel or those wanting to learn VBA and could also be useful as a course book in numerical methods…"" (
IEEE Electrical Insulation Magazine, July/August 2008)
"I am wiser now, and you should be, too! This book is strongly recommended for all engineers, scientists, undergraduate and graduate students that have ever used EXCEL." (
Materials and Manufacturing Processes, Volume 22, Issue 7 2007)
"An excellent volume for practicing scientists or engineers encountering numerical methods." (
CHOICE, October 2007)
Customer Reviews & Comments
My library holds many books on using Excel and programming in Excel VBA. Billo's book has brought valuable hints and techniques that have enhanced my VBA programming skills. The book offers a well balanced coverage of numerical analysis and statistical regression topics. While the examples are more geared for the chemists, they should not be a turn off for readers who are in other scientific and engineering disciplines.
Billo offers an interesting approach to using VBA code and shows you, throughout the book, how to write functions (in modules) that you can use as "custom functions" in your spreadsheets. Excel invokes these functions automatically whenever you alter a cell value and trigger automatic recalculations. This technique frees you from having to repeatedly invoke VBA macros to recalculate values in a spreadsheet. The "custom functions" you learn to build become a custom extension to the Excel library of built-in functions.
I highly recommend this fine book and congratulate the author on his clever work. Billo's book stands out among other Excel VBA books.
