Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA |
 |
 click here for more details, find new or used items |
Stephen Bullen, Rob Bovey, John Green
|
|
Pages: 936 (Paperback)
ISBN: 0321262506
Pub: Addison Wesley
Pub date: 2005-02-10
Amazon.co.uk Sales Rank: 3198
Reader Reviews:
Excellent (0/0 people found this helpful)
If you are an Excel developer/advanced user and wanting to further your knowledge then this is the book for you. This is an excellent book overall but where it 'excels' (sorry) is in it's constant hammering home of best practise - and these skills can be transfered to other applications/languages. As many others have said - I thought I was an advanced Excel developer and that I knew it all, not so after looking at this book. I just hope they'll do an update for Excel 2007.
The best book for serious VBA applications (1/1 people found this helpful)
I have been building Excel models and using VBA for almost 10 years, and this is by far the best book that I have read about how to build robust VBA applications. Other books deal mainly with technical aspects of VBA, but this book also shows how to structure applications and how to put into practice the more advanced features of Excel and VBA.
If you know the basics this book will take you a new level (8/8 people found this helpful)
I have been writing Excel macros for sometime and when people wanted me to write macros for them I found this book invaluable. Before reading this my `applications' where merely taking the standard Excel interface and using the Active X functions it provides to maniple data as required. Now my applications have very specific interfaces and functions, most people who have seen them have said things like `I did not know Excel could do that'. If you are new to programming, Excel or Macro writing then this book is not for you (yet), the book is written assuming that the user knows a bit more then the basics. This book is all about creating an application, I.E using the readers existing knowledge to create that application. That said there is considerable coding included with practical examples showing how to implement the functions presented. Nearly everything is included in the accompanying CD and that is my only bug with this book, not all the code fragments are included with the result that some of the functions must be entered by the reader.
Unbeatable (7/7 people found this helpful)
After identifying a requirement at work to automate a number of tasks with Excel I decided to buy Professional Excel Development. I couldn't have made a better choice! This is not a 'hold your hand' book by any means, but the information contained within is priceless.
The rate at which I learned useful techniques and became aware of "i'd never have found that out myself" gotchas was so rapid I found myself re-reading sections tying to spot the catch. There was none. It really is that easy to learn from this book.
We do not have an official Excel developer employed at my place of work. I have already saved a good deal of man-hours through educating people on the use of Excel. There's scope for much more, now that I'm armed with this book. My pay-rise will be exceptionally healthy!
The one to get if you are developing serious applications (8/9 people found this helpful)
If you want to use excel as a development platform to produce a sophisticated windows program with no sign that excel is powering it this is the book for you. The table based menus code alone allowed me to have sophisticated dropdowns, toolbars, right click menus after 1 days work.
You will learn to write code that makes it easier to have a sophisticated program than a clunky one.
Highly recommended to anyone with a reasonable working knowledge of VBA, or any general programming knowledge and some determination. My knowledge is growing exponentially.
Similar Products
Excel VBA Programming for Dummies (For Dummies)
Excel Hacks: 100 Industrial Strength Tips and Tools (Hacks)
Excel 2003 Power Programming with VBA
VBA and Macros for Microsoft Excel (Business Solutions)
Categories
Amazon.co.uk places this book into the following categories:
Books -> Subjects -> Computers & Internet -> Software & Graphics -> Business & Home Office -> Spreadsheets -> Microsoft Excel
Books -> Subjects -> Computers & Internet -> Programming -> Microsoft Windows -> Excel
Books -> Subjects -> Computers & Internet -> Microsoft Windows -> Applications -> Excel -> Advanced & Intermediate
Books -> Subjects -> Computers & Internet -> Microsoft Windows -> Applications -> Excel -> Programming
Books -> Subjects -> Computers & Internet -> Digital Lifestyle -> Online Shopping -> Amazon
Books -> Subjects -> Business, Finance & Law -> General
Books -> Special Features -> Regular Stores -> Paperback Deals
Books -> Refinements -> Language (feature_browse-bin) -> English
Books -> Refinements -> Age (feature_two_browse-bin)
Books -> Refinements -> Format (binding_browse-bin) -> Paperback
Books -> Refinements -> Condition (condition-type)