- Take an Extra 30% Off Any Book: Use promo code HOLIDAY30 at checkout to get an extra 30% off any book for a limited time. Excludes Kindle eBooks and Audible Audiobooks. Restrictions apply. Learn more.
Learn to use Visual Basic for Applications (VBA), and you can expand the already awesome power of Excel 2010. John Walkenbach, aka Mr. Spreadsheet, shows you how to do it in this easy-to-follow guide.
If you're already an experienced Excel user, this book will make you an Excel master. You'll learn a new approach to Excel and the steps involved in developing a new spreadsheet application. You'll also discover how to develop VBA subroutines and functions, use advanced programming techniques, and more. And if you're switching to Excel 2010 from an earlier version, there's a section to get you up to speed on the new features.
No one can teach you more about Excel than Mr. Spreadsheet.
Let Mr. Spreadsheet show you how to:
Create powerful Excel apps with VBA
Develop user-friendly dialog boxes
Enhance Excel with custom worksheet functions
Write event-driven VBA code
More than 300 files used as examples in the book
Searchable PDF of the book
See Appendix D for complete system requirements
If a book is opened almost everyday to advance 10-20 pages and if the examples are easily put into practise, then that is a sign of well structured and easy-to-read textbook. Read morePublished 16 days ago by Dirk Muller
A tome of information. In areas it provides good detail of how to use Excel and VBA. But there were areas which I found lacking. Read morePublished 1 month ago by Obesessive Reader
Covers everything you need at the intermediate level.
It would be good if it had another volume to cover the more advanced aspects.
The book is not bad but I didn't read the fine print until after I bought the Kindle edition. The Kindle edition doesn't have the examples which are the most important part of the... Read morePublished 3 months ago by bikedc