What do you think?
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
Microsoft Excel can be much more than just a spreadsheet. It has become adevelopment platform in it own right. Applications written using Excel are partof many corporations' core suites of business-critical applications. In spite ofthis, Excel is too often thought of as a hobbyist's platform. While there arenumerous titles on Excel and VBA, until now there have been none thatprovide an overall explanation of how to develop professional-quality Excel-basedapplications. All three authors are professional Excel developers who runtheir own companies developing Excel-based apps for clients ranging fromindividuals to the largest multinational corporations. In this book they showhow anyone from power users to professional developers can increase thespeed and usefulness of their Excel-based apps.
936 pages, Paperback
First published February 1, 2005
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 4 of 4 reviews
February 4, 2010
A bit overwhelming with all the information in this book but definitely worth the read. I'll be going back into when I implement a lot of his ideas.
February 28, 2013
Very complete. I was able to find some answers to punctual questions; but I have to confess that I decided to go on with less heavy reading for the rest of the time.
***
Editing after comment from Mike: yes, this book is mote useful when interested in building VBA enhancements to excel workbooks. My three-star rating -which I am standing by comes from the fact that I do not regard Excel as a reliable tool for developers. I think that it would be cool to have some level of knowledge on coding "tricks", but if the start point is a platform so unreliable and unstable as MICROSOFT Excel, then we are not prone to good things. All that said, it is not the book's fault that I don't like Excel, so an additional argument for the low rating ought to exist; and here it is: what I really disliked was the solipsistic air of superiority that emanated from the writing. A message in the direction of "Excel is the best tool if only you knew to take better advantage of it". My personal experience is this: Excel is nice and useful, and you can do cool things with VBA, but it is also unstable, and things get broken for no reason (example: tables and pivot fields) and if you want to use programming techniques to enhance your work, you better move on to more elaborated and robust tools.
***
Editing after comment from Mike: yes, this book is mote useful when interested in building VBA enhancements to excel workbooks. My three-star rating -which I am standing by comes from the fact that I do not regard Excel as a reliable tool for developers. I think that it would be cool to have some level of knowledge on coding "tricks", but if the start point is a platform so unreliable and unstable as MICROSOFT Excel, then we are not prone to good things. All that said, it is not the book's fault that I don't like Excel, so an additional argument for the low rating ought to exist; and here it is: what I really disliked was the solipsistic air of superiority that emanated from the writing. A message in the direction of "Excel is the best tool if only you knew to take better advantage of it". My personal experience is this: Excel is nice and useful, and you can do cool things with VBA, but it is also unstable, and things get broken for no reason (example: tables and pivot fields) and if you want to use programming techniques to enhance your work, you better move on to more elaborated and robust tools.
July 15, 2013
If you're serious about becoming a professional Excel developer then this book is a must have!
April 5, 2014
Libro interessante e ricco di spunti, ma da leggere solo da utenti avanzati perché dà molte cose non banali per assodate
Displaying 1 - 4 of 4 reviews