Professional Excel Development
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
 Trade In this Item for up to £7.55
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA (Addison-Wesley Microsoft Technology) for an Amazon.co.uk gift card of up to £7.55, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
|
There is a newer edition of this item:
|
Frequently Bought Together
Product details
|
Product Description
Product Description
Microsoft Excel can be much more than just a spreadsheet. It has become a
development platform in it own right. Applications written using Excel are part
of many corporations' core suites of business-critical applications. In spite of
this, Excel is too often thought of as a hobbyist's platform. While there are
numerous titles on Excel and VBA, until now there have been none that
provide an overall explanation of how to develop professional-quality Excelbased
applications. All three authors are profesional Excel developers who run
their own companies developing Excel-based apps for clients ranging from
individuals to the largest multinational corporations. In this book they show
how anyone from power users to professional developers can increase the
speed and usefulness of their Excel-based apps.
From the Inside Flap
Unfortunately, Excel is still all too often thought of as a hobbyist platform; that people develop spreadsheet-based applications in their spare time to help out with their day job. A brief look at the shelves of any bookstore seems to confirm that opinion. While there are myriad titles explaining how to use Excel and numerous titles about Excel and VBA, there are none that provide an overall explanation of how to develop professional-quality Excel-based applications. This is that book.
While all the other major languages seem to have a de-facto standard text that explains the commonly-agreed best practices for architecting, designing and developing applications in that language, Excel does not. This book aims to fill that gap.
All three authors are professional Excel developers who run our own companies developing Excel-based applications for clients ranging from individuals to the largest multinational corporations. This book details the approaches we use when designing, developing, distributing and supporting the applications we write for our clients.
This is not a beginner-level book. We assume that the reader will have read and (mostly) understood our Excel 2000/2002 VBA Programmer's Reference, John Walkenbach's Excel N Power Programming or similar titles.
Inside This Book
(Learn More)
First Sentence
Microsoft Excel is much, much more than just a spreadsheet. Read the first page Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Microsoft Excel is much, much more than just a spreadsheet. Read the first page Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
21 of 21 people found the following review helpful
Format:Paperback
I ordered this book as soon as I'd read the sample chapters at www.oaltd.co.uk - I finally understood about the Windows API and wanted more!
It's totally different to any other Excel/VBA book available, so comparisons are hard. It doesn't have chapters about the Range or Worksheet objects - the authors seem to expect us to know that already - but instead has topics like choosing architectures, development best practices, optimising performance and rock-solid error handling.
It's a big book so it's hard to pick any bits out
for special mention. Every chapter seems to contain something I'd never seen before, with even the most complex topics (such as custom interfaces, creating XLLs and using XML and web services) explained in a way that made them all easy to understand.
The best bits for me though have to be the practical examples that end most of the chapters. By seeing how the concepts have been applied to their sample application, I can readily see how to apply them to mine, and have already begun to do so.
This is a serious book, not for beginners, and to me it seems to be in a different league to the rest.
It's totally different to any other Excel/VBA book available, so comparisons are hard. It doesn't have chapters about the Range or Worksheet objects - the authors seem to expect us to know that already - but instead has topics like choosing architectures, development best practices, optimising performance and rock-solid error handling.
It's a big book so it's hard to pick any bits out
for special mention. Every chapter seems to contain something I'd never seen before, with even the most complex topics (such as custom interfaces, creating XLLs and using XML and web services) explained in a way that made them all easy to understand.
The best bits for me though have to be the practical examples that end most of the chapters. By seeing how the concepts have been applied to their sample application, I can readily see how to apply them to mine, and have already begun to do so.
This is a serious book, not for beginners, and to me it seems to be in a different league to the rest.
20 of 20 people found the following review helpful
Format:Paperback
Knowing a little of the reputation of the authors I expected this book to include the depth of content as advertised. It does, exceeding my expectations. What I am particularly impressed with is how well it is written. Taking the dry edges off a strictly technical manual makes such a difference to even wanting to get to grips with what may be new and complex topics.
Even where a particular topic is familiar to the reader it is bound to include some new tips, any one of which could repay an investment in the book.
It's not for beginners but a must have for anyone who uses Excel extensively. If that's you, and you are wondering if you need it, my best advice is stop thinking about it and get it!
13 of 13 people found the following review helpful
Format:Paperback
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.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
Profesional Excel Development
This book is very useful if you have a reasonable working knowledge of VBA, that is, more than just recording macros for later editing. Read more
Published on 16 Feb 2009 by A. V. Hunt
Fantastic Book! BUY IT!!
Have just finished reading this book, and it is absolutely superb! Fair enough, it was printed before the days of the 2007 Office/Excel version, however, as I've just discovered,... Read more
Published on 9 Feb 2009 by Belial
Excellent book but not for beginners
Great book.Learnt a lot about how to develop applications in Excel.Would not recommend it to beginners though.
Published on 9 Oct 2008 by S. Kamineni
The standard text
Brilliant, just don't buy it until you are reasonably confident with the same authors Excel reference or similar - this is not an entry level text. Read more
Published on 26 Jun 2008 by Neal G. O'nions
Excellent
If you are an Excel developer/advanced user and wanting to further your knowledge then this is the book for you. Read more
Published on 24 May 2008 by Whitespaces
The best book for serious VBA applications
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. Read more
Published on 17 Feb 2008 by AMK
Unbeatable
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! Read more
Published on 6 Feb 2007 by Mr. S. Holmes
The one to get if you are developing serious applications
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. Read more
Published on 3 Aug 2006 by Bobby
Takes you from Novice to Nerd.
Stephen enthusiastically takes you through very easy stages of developing a professional, sophisticated application. Read more
Published on 17 Jun 2006 by G. C. Hannah
The Bible for Excel Development
There have been books like C Programming Language by Kernighan & Ritchie which are considered the de facto standard that every developer using that language must read. Read more
Published on 10 Mar 2006 by "rajx"
Listmania!
Look for similar items by category
- Books > Business, Finance & Law
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Advanced & Intermediate
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Programming
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets > Microsoft Excel
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
