- Paperback: 504 pages
- Publisher: Wrox; 2 edition (March 30, 2015)
- Language: English
- ISBN-10: 1118991370
- ISBN-13: 978-1118991374
- Product Dimensions: 7.4 x 0.9 x 9.3 inches
- Shipping Weight: 1.8 pounds (View shipping rates and policies)
- Average Customer Review: 9 customer reviews
- Amazon Best Sellers Rank: #428,096 in Books (See Top 100 in Books)
Enter your mobile number or email address 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.
To get the free app, enter your mobile phone number.
Excel VBA 24-Hour Trainer 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
All Books, All the Time
Read author interviews, book reviews, editors picks, and more at the Amazon Book Review. Read it now
Frequently bought together
Customers who bought this item also bought
From the Back Cover
Quickly get more out of Excel with VBA automation
Excel VBA 24-Hour Trainer, 2nd Edition is your quick-start guide to getting more out of Excel using Visual Basic for Applications. This unique book and video package has been updated with 15 new advanced video lessons, providing a total of 11 hours of video training and 48 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Meanwhile, concise, step-by-step instructions, illustrations, code examples, and downloadable workbooks give you a practical, in-depth learning experience.
Excel VBA 24-Hour Trainer, 2nd Edition:
- Offers a complete guide to becoming a true Excel power user
- Shows you how to program Excel's newest chart and pivot table object models
- Provides steps for manipulating the user interface with UserForms and embedded Form and ActiveX® controls to customize the look and feel of a project
- Helps you utilize message boxes, input boxes, and loops to yield customized, logical results
- Features steps for manipulating Word, Access®, PowerPoint®, and Outlook® from Excel
More than 11 hours of video training
Most lessons in this book is accompanied by an online instructional demonstration video to reinforce what you learn. Regardless of your learning style, you can now quickly master the basics and expand your skill set with this step-by-step multiplatform learning experience.
About the Author
Tom Urtis is an Excel Microsoft Excel MVP, developer, and programmer with 30 years of experience in business management and developing spreadsheet and database applications for companies of all sizes. He is an Excel instructor and frequent contributor to newsgroups in the Excel community.
Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved.
Top customer reviews
Some days ago, I have received the book Excel VBA 24-Hour Trainer for a review, upon a request from my site. After all, as far as it has all started with VBA for me, I am always interested in the latest trends on the subject. 'he book is a second edition, so I thought it would be useful to read it.
And I was not mistaken. The book is great! :)
First of all, it is not just a book - it is more like a whole package, learning you step by step to write useful code. The videos from the book and its code are available on line without any registration.
These are must-see resources! (Available at the wrox site, just make a quick search there). The videos are really valuable, due to the following 2 reasons - they are free and not boring! Indeed, the guy behind the camera is obviously having fun and enjoying what he is doing. Check it out by yourself, as I mentioned they are free :) Furthermore, after spending some time with them you can decide for yourself whether or not this is what you need!
The book consists of 33 lessons in 5 parts. Each lesson (without the starting 2-3) ends with a to-do task and the solution of this task is explained in the video. Furthermore, additional 15 advanced video lessons are available online, with their code. The advanced videos are really fun (as fun as coding in Excel can go) and a must see - e.g. the guy introduces cell blinking in video #5 and asks you to double think whether this is really needed. Anyhow, he comes with useful examples. Later in video #6 he tells a story of a picture, while putting it in a comment in Excel. Indeed, the videos are worthy!
Let's start with the review of the book:
The first two parts are quite normal and well-written. I liked the unique way of introducing the OOP in lesson 5. At first I thought that it was pretty early and it may be scary for a beginner, but when I read the lesson, it was OK.
In the first two parts, one can see the ability of the author to produce interesting information even for people with experience in VBA (like myself)! I saw that there is a difference of 100 years between "10/10/29" and "10/10/30" :), or that one may refer to ranges of cells this way – "Cells(2,"E").Value" (so far I only knew the other 2 ways of referring). I still remember how I was counting the alphabet for the column letter index some 2 years ago :)
Later, in part 3 one learns all the features a programmer should know to make use of VBA. I, personally liked the idea of comparing data in multiple cells together. E.g., imagine that you want to find a duplicate row in a given table. The algorithm in the book is to write a macro (or a sub, call it as you wish), which unites the data from the row into one cell and then checks whether there is similar data in the column. Clear and simple!
With part 4 the real power of VBA is revealed - User Forms and controls are well explained, the OOP is introduced and furthermore, it is explained why OOP is really a must for a VBA programmer. The case was that, if you need to write a functions and properties for 5 or 6 objects, you may easily maintain it by yourself, but when it comes to 100 it is not that easy. And when you want to make the number of objects a variable, then you cannot go without OOP. And classes. Thus, you have to learn them :)
The last part looks into interactions with other office applications. I liked that the author has explained late and early binding quite simply. If you are still wondering what is what, then with 2 words - late binding does not need to know the version of the application (e.g. Office 12 or 11 or 14), while early binding needs to know it and thus can make problems if the user changes versions. Early binding is faster.
Tiny minus: Let's be a little negative, too much sugar on this review would probably not look credible! (but the book really deserves all the sugar from my keyboard and even more for going one step further with the videos and the way of presentation skills of the author) :) Thus, there is a point for improvement - the provided code is not indented anywhere. Neither in the book, in the video or in the online files. It would be great, if you could spare 4-5 hours and fix the code in the online files. There are enough good tools to automate it and it looks better.
Pretty much that is it - last words - go for the book, if you are working with Excel, it will help you! Simple & understandable language, showing you the magic of VBA! :)
As said in the introduction, the book "assumes you have never programmed Excel before." But if you have "worked with VBA before, this book has examples of programming techniques you might not have seen." I read it all even though I have some years of experience with VBA. The videos are great, too.