Excel VBA 24-Hour Trainer, by Tom Urtis
This letter might not affect you to be smarter, however the book Excel VBA 24-Hour Trainer, By Tom Urtis that we provide will evoke you to be smarter. Yeah, at the very least you'll understand greater than others who do not. This is just what called as the quality life improvisation. Why needs to this Excel VBA 24-Hour Trainer, By Tom Urtis It's since this is your favourite motif to check out. If you such as this Excel VBA 24-Hour Trainer, By Tom Urtis theme around, why do not you check out guide Excel VBA 24-Hour Trainer, By Tom Urtis to improve your conversation?
Excel VBA 24-Hour Trainer, by Tom Urtis
PDF Ebook Online Excel VBA 24-Hour Trainer, by Tom Urtis
Master VBA automation quickly and easily to get more out of Excel
Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 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. Clear, concise, step-by-step instructions are combined with illustrations, code examples, and downloadable workbooks to give you a practical, in-depth learning experience and results that apply to real-world scenarios.
This is your comprehensive guide to becoming a true Excel power user, with multimedia instruction and plenty of hands-on practice.
- Program Excel's newest chart and pivot table object models
- Manipulate the user interface to customize the look and feel of a project
- Utilize message boxes, input boxes, and loops to yield customized logical results
- Interact with and manipulate Word, Access, PowerPoint, and Outlook from Excel
If you're ready to get more out of this incredibly functional program, Excel VBA 24-Hour Trainer, 2nd Edition provides the expert instruction and fast, hands-on learning you need.
Excel VBA 24-Hour Trainer, by Tom Urtis- Amazon Sales Rank: #65075 in Books
- Brand: Urtis, Tom
- Published on: 2015-03-30
- Original language: English
- Number of items: 1
- Dimensions: 9.30" h x .94" w x 7.42" l, .0 pounds
- Binding: Paperback
- 504 pages
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.
Where to Download Excel VBA 24-Hour Trainer, by Tom Urtis
Most helpful customer reviews
13 of 13 people found the following review helpful. A Great Book for MS Excel VBA, with Even Greater Videos By VitoshAcademy 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! :)
3 of 3 people found the following review helpful. Highly Recommended By James C Philips This is an excellent book. It covers all major topics and has clear text and understandable examples.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.
2 of 4 people found the following review helpful. Five Stars By Painting50 Great product and fast shipping thanks
See all 6 customer reviews... Excel VBA 24-Hour Trainer, by Tom UrtisExcel VBA 24-Hour Trainer, by Tom Urtis PDF
Excel VBA 24-Hour Trainer, by Tom Urtis iBooks
Excel VBA 24-Hour Trainer, by Tom Urtis ePub
Excel VBA 24-Hour Trainer, by Tom Urtis rtf
Excel VBA 24-Hour Trainer, by Tom Urtis AZW
Excel VBA 24-Hour Trainer, by Tom Urtis Kindle
