FREE Delivery in the UK.
Only 2 left in stock.
Dispatched from and sold by Amazon. Gift-wrap available.
Quantity:1
Professional Excel Develo... has been added to your Basket
+ £2.80 UK delivery
Used: Very Good | Details
Condition: Used: Very Good
Comment: Expedited shipping available on this book. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged.
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA (Addison-Wesley Microsoft Technology) Paperback – 1 Feb 2005

4.9 out of 5 stars 20 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Paperback
"Please retry"
£43.99
£28.46 £3.15
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
click to open popover

Special Offers and Product Promotions


Frequently Bought Together

  • Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA (Addison-Wesley Microsoft Technology)
  • +
  • Writing Excel Macros with VBA
Total price: £70.41
Buy the selected items together

Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.




Product details

  • Paperback: 936 pages
  • Publisher: Addison Wesley; 1 edition (1 Feb. 2005)
  • Language: English
  • ISBN-10: 0321262506
  • ISBN-13: 978-0321262509
  • Product Dimensions: 17.8 x 4.6 x 23.1 cm
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (20 customer reviews)
  • Amazon Bestsellers Rank: 87,534 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

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.

From the Back Cover

Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications.

This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge they've acquired building Excel applications for many of the world's largest companies―including Microsoft. Professional Excel Development demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform design, charting, debugging, error handling and optimizing performance. Along the way, the authors offer best practices for every type of Excel development, from building add-ins through interacting with XML Web services. Coverage includes

  • Building add-ins to provide new Excel functions

  • Designing effective worksheets, userforms and other user interface elements

  • Leveraging Excel's powerful data analysis features

  • Creating sophisticated custom charts

  • Handling errors, debugging applications and optimizing performance

  • Using class modules and interfaces to create custom objects

  • Understanding Windows API calls: when to use them, and how to modify them

  • Adding worksheet functions with

  • C-based XLLs

  • Programming with databases

  • Controlling external applications from Excel

  • Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office

  • Using XML to import and export data and communicate with Web services

  • Providing help, securing, packaging and distributing

The accompanying CD-ROM contains the book's sample timesheet application at every stage of construction, with detailed code comments. It also includes many examples of the concepts introduced in each chapter and a collection of the authors' Excel development utilities.


© Copyright Pearson Education. All rights reserved.

See all Product Description

Customer Reviews

4.9 out of 5 stars
5 star
17
4 star
3
3 star
0
2 star
0
1 star
0
See all 20 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
I ordered this book as soon as I'd read the sample chapters at [...] - 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.
Comment 23 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
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!
Comment 20 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Customer on 28 July 2005
Format: Paperback
Well this is the book us self-taught developers have been waiting for; for those puzzled as to what makes an intermediate, advanced or guru-like developer, right off the bat you are told in no uncertain terms how good you are, or how much more there is to learn.
If you arrogantly thought you knew it all in terms of excel's front-end functionality, charting capability, and presentational tools, then this book will bring you back down to earth.
If you are looking for an all-in-one book on the intricacies of API programming, xll, xml and web serivces, a refresher on ADO and SQL, this is it
If you aren't in an environment that fosters best development practice, but craved that discpline to produce effective and efficient code, short of working for Microsoft, this is the book for you.
look no further; this is the book to quench that thirst/hunger you have about Microsoft Excel's immense capabilities, and inject some fun into learning process.
Comment 21 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
I have developed quite a few automated Excel applications over a number of years but mostly on my own. To do this, I'd picked up quite a lot of bits and pieces knowledge on the whole Excel VBA subject from various books and newsgroups. However, I'd not had the coaching to do complete development projects from design to distribution.
This book has proved to be the perfect manual for someone like me, who just didn't quite have the professional knowledge of how to build a well-designed, robust application from start to finish. After reading just the first few chapters, I'm already much more advanced in understanding the thinking behind the design, why to take which approaches and why not to take other approaches. It really is similar to having an expert sitting beside me and leading me through the steps. Many thanks to the authors for filling this hole in the knowledge market.
Comment 21 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
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.
Comment 13 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
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!
Comment 10 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews



Feedback