 |
|
|
|
|
|
 |
Have you read all the best Excel programming books? Do you know how the Excel object model works? Are you familiar with macros and worksheet design techniques? Do you still have difficulty translating your knowledge and experience into comprehensive Excel applications? If so, Professional Excel Development is the book for you.
Professional Excel Development doesn't waste time explaining what you already know about Excel. It starts where other Excel books leave off and builds on the techniques you already know to demonstrate how professional Excel programmers create commercial quality Excel applications.
Professional Excel Development is more than just a theoretical guide to the concepts and techniques employed by professional Excel developers. As the book progresses, we build a fully functional, professional-quality timesheet reporting and analysis system that illustrates the concepts and techniques introduced in each chapter.
- Chapters 1 to 3 provide an introduction to professional application development with Excel, explain the different styles of application we might choose to create for different circumstances, and identify some general best practices for working with Excel and VBA that will be followed throughout the book.
- Chapter 4 explains how to design and structure worksheet user interfaces for data entry and analysis.
- Chapters 5 and 6 introduce two specific types of application - the add-in and the dictator application, which will form the basis of our timesheet reporting and analysis application.
- Chapter 7 introduces the use of class modules in our Excel applications.
- Chapters 8 to 11 discuss XML, command bar and Ribbon user interfaces, and designing applications that must run in all current versions of Excel using a single code base.
- Chapters 12 to 17 discuss advanced techniques for a range of VBA topics, including UserForm design, interfaces, error handling, debugging and performance optimization.
- Chapters 18 and 19 cover database development for Excel developers.
- Chapters 20 and 21 explain how to efficiently use Excel’s built-in charting and data analysis features to analyze data and present results.
- Chapters 22 to 27 look outside of Excel, by explaining how to automate other applications and extend Excel with VB6, VB.NET and C.
- Chapter 28 focuses on how Excel applications can make use of Web Services.
- Chapter 29 completes the development by explaining how to provide help for, secure and deploy an Excel application.
For more information please visit the following link: Professional Excel Development
Together with the OzGrid Team the authors offer members in the OzGrid community a chance to participate in a lottery where three people will get a free copy of the second edition of PED. The submission deadline is: 14 days from the publishing date (19-Aug-2009) at 12:00 local time in Australia.
In order to participate all you have to do is the following:
- Send an e-mail to: [email protected]
- Add the following in the subject field: "OzGrid PED Lottery"
- In the body of the e-mail answer the following question: Which built-in tool in Excel do you use most frequently?
- Only one tool should be mentioned in the e-mail
- The e-mails must be submitted before the deadline 14 days from the publishing date at 12:00 local time in Australia
- Winners will be randomly selected.
- Winners will be notified by email, so please provide a valid email address and ensure @xldennis.com is part of any Whitelist.
- The copies will be shipped, postage paid, but taxes or other charges (if any) will be the responsibility of the recipient
The winners name’s be published at OzGrid Help Forum together with the result of the question. The outcome will also be published at the blog XL-Dennis blog.