Excel VBA and Macros with MrExcel LiveLessons (Video Training)

This is the third 'livelessons' DVD that I have bought and they are all very good.Excel VBA and Macros with MrExcel is already available in two books (one for Excel 2003 and the other for Excel 2007) - this DVD is presented using Excel 2007. However, Excel VBA is basically the same regardless of version but of course there will be differences when accessing and using the new features of the later version.The DVD comes with a 125 page booklet describing the lessons and giving code examples together with supporting workbooks for the lessons. Although created in Excel 2007, it should be possible to open the files in earlier versions by installing the Office 2007 Compatibility Pack (check this out on Microsoft's web site - kb924074).For anyone wanting to learn VBA this is going to be great. It is easier to learn by watching a DVD and following the examples than trying to learn from a book, although I would suggest that buying the book also would be a bonus - you can pick that up to browse anytime and anywhere.Highly recommended.

Video teaching is perfect for those who learn by watching. I've only watched a couple of lessons but that was enough to make me want to continue to watch more as the concepts are explained so well! I would say if you are an intermediate excel user, then this product is perfect for you as you do need to understand how excel works. If you are an excel beginner, then forget it, the examples will be too advanced for you to follow. Nonetheless, once new excel users become more familiar with excel and want to advance to macros, then this is the perfect introductory course to it. I highly recommend buying this product either for learning purposes or quick reference.

I live in London,Product delivered in 2 daysThe course is extremely week laid out and very well presentvery easy to use the learning dashboardRecommend if you are a VBA newbie like me.I only knew how create recorded macros, now Im writing basic, but effective code, and thats only after 2 weeks and half way through the course.Great value for money,

This is very useful to get a feel for macros and scratching the surface of what VBA can do. As other reviewer said, I find it easier to watch then mimic, rather than just read from a book. Only slight irritation is the cheesy "thanks for watching" that BJ says at the end of each clip - when you watch more than 5 in a row you start scrabbling for the mouse to click on "next video" before he says it!

Good but needs material updating with office 2007/ 2010 or even better 2013 tips

Excellent videos and learning format, I've been using Macro's for some time now but within the first few lessons I've learnt things I never knew existed. Great product, which starts off where I should have done!

Indeed within a few minutes, you are able to write up macros and experience their power. Great lectures and well structured. Thank you

This is a great alternative to reading from a book. Watching and then practicing the steps after each lesson enables you to quickly come to terms with the concepts being thought.One thing I was worried about initially is that the lessons are tought on excel 2007 while I use excel 2003. This has not been an issue though as in the few areas where there has been notable difference between excel versions the difference has been explained, and to be honest is intuitive for any regular user of excel.Only drawback to mention is that the video requires a screen resolution higher than 1280 x 960 for optimum display. My screen resolution is lower than this and has meant i cannot see the play control button to pause or ffwd as i choose. 1 Star dropped for this.

I have been struggling with VBA for many many years. I have bought a dozen books. . .What is good about this DVD, it is like real life tutoring 24/7. Easy, user friendly, step by step. I have a few of Bill 's DVD like "Slide Your way through Excel VBA". It is good but this is The Best. Bill managed to step into the shoes of a beginner and hold our hands along the way. He has a good clear voice, speak slowly and clearly. He gets us comfortable starting with Macro, slowly move us into the real power of VBA. This enable us to first build the foundation which is very important in order to Excel. I would recommend to anyone who is interested in learning VBA without pain. Cheers, Doris Choo -Ontario, Canada

It is very good and helpful. The lessons are based on 2007 Excel but its alright as 2013 is not yet released. I hope they should come out with supplement of additional versions of office mentioning the differences

Timely delivery and expected quality.

awesome

Its a good way to learn Excel VBA and macros. If you want to advance your knowledge in excel buy this book.

Excel VBA and Macros with Mr. Excel is just what I have been looking for for several years. I have been writing and working with macros for my job for some time. Editing previously written macros has been fairly easy, while creating macros from scratch has been time consuming. I have several Excel VBA references in print and have used the free online training courses from Microsoft. Those types of products work pretty well, but the part that was missing for me was a real course-type presentation of the material, where it starts out with some of the basics and progresses into organized application of the parts. This product logically presents the topic, and presents step-by-step examples of how to create "good" macros. The supporting Excel files for each lesson are very helpful as well. Bill Jelen is a dynamic presenter and the videos are extremely well done. Finding a knowledgeable person who can also be a captivating presenter and instructor is such a rare find.

This is a wonderful course. Very clear, step-by-step presentation. I have only three small quibbles:1. The image cannot be changed to a full screen.2. The introduction of errors in the code. To be sure, they are fixed later but they annoy me to the point where I pay less attention.3. I never want to hear, "Let's get started." again.Worth every penny....Bob

I love Bill Jelen's Live Lessons on VBA!!! I have some knowledge of VBA, but I still consider myself a beginner. For someone like me, the Live Lessons are ideal. I think that the lessons might be too difficult for someone with absolutely no knowledge of VBA. I also think that this is probably not very challenging for someone with intermediate to advanced skills.The lessons are clear. He explains how to use VBA simply and precisely, and provides very helpful hints throughout. Each less on is short and not too much to absorb. This definitely filled the gaps in my knowledge of VBA, and I believe this will help me boost productivity.I am a big Bill Jelen fan. I am also a big John Walkenbach fan too.

Lost the previous copy that I had. Bill Jelen produces excellent instructive videos--also used one to learn Access

He teaches in a exhilarated fashion, but the good part is you can play back to the parts you may need help with. his language is simple and easy to understand, all I can say is take notes.

Excellent Reference and teaching guide. Its easy to see why they call him Mr. Excel. The material is laid out in a straightforward and logical manner which is easy to understand. I became proficient doing some simple VBA solutions after finishing this course. The practice exercises really help you retain what you learn.

jelen is good

This video training is just great. Talk about short cutting the learning curve - wow! Bill Jelen has distilled the most salient constructs needed to quickly get up to speed with VBA, and presents them in a manner conducive to easy learning. This is an excellent training aid!

I'm a finance guy with advance level of excel but I just love continous improvement! This is great DVD, with clear concepts and very good diction fom Mr Excel. Remember this DVD is for intermedite-advance excel user to NEW to VBA.enjoy! Ed

I have been an Excel user for about two years now and have been writing Macros for the past year. I picked this software package up so I could learn how to make my Macros perform better. I decided to actually go through the entire program from Lesson 1 all the way to the last lesson even though I know the majority of the knowledge in the beginning. By lesson 6 I already picked up two very useful pieces of information that I used the following day at work.Definitely worth the price and I will be buying more Livelessons software.