What do you think?
Rate this book
Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .Net
This is the eBook version of the printed book. If the print book includes a CD-ROM, this content is not included within the eBook version. The Start-to-Finish Guide to Building State-of-the-Art Solutions with Excel 2007 In this book, four world-class Microsoft(R) Excel developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors--three of whom have been honored by Microsoft as Excel Most Valuable Professionals (MVPs)--show how to consistently make the right design decisions and make the most of Excel's most powerful new features. Using their techniques, you can reduce development costs, time to market, and hassle--and "build more effective, successful solutions." Fully updated for Excel 2007, this book starts where other books on Excel programming leave off. Through a hands-on case study project, you'll discover best practices for planning, architecting, and building Excel applications that are robust, secure, easy to maintain, and highly usable. If you're a working developer, no other book on Excel programming offers you this much depth, insight, or value. - Design worksheets that will be more useful and reliable - Leverage built-in and application-specific add-ins - Construct applications that behave like independent Windows programs - Make the most of the new Ribbon user interface - Create cross-version applications that work with legacy versions of Excel - Utilize XML within Excel applications - Understand and use Windows API calls - Master VBA error handling, debugging, and performance optimization - Develop applications based on data stored in Access, SQL Server, and other databases - Build powerful visualization solutions with Excel charting engine - Learn how to work with VB.NET and leverage its IDE - Automate Microsoft Excel with VB.NET - Create managed COM add-ins for Microsoft Excel with VB.NET - Develop Excel solutions with Visual Studio Tools for Office (VSTO) - Integrate Excel with Web Services - Deploy applications more securely and efficiently
1172 pages, ebook
First published February 1, 2005
27 people are currently reading
179 people want to read
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 25, 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.
November 6, 2014
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 16, 2013
If you're serious about becoming a professional Excel developer then this book is a must have!
May 22, 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