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.
Chapter 1 Introduction
Chapter 2 Application architectures
Chapter 3 Excel and VBA development best practices
Chapter 4 Worksheet design
Chapter 5 Function, general and application-specific add-ins
Chapter 6 Dictator applications
Chapter 7 Using class modules to create objects
Chapter 8 Advanced command bar handling
Chapter 9 Understanding and using Windows API calls
Chapter 10 Userform design and best practices
etc.