VBA AND MACROS FOR MICROSOFT EXCEL (VIDEO TRAINING) (LIVELESSONS)

VBA and Macros for Microsoft Excel (Video Training) (LiveLessons)

by Bill Jelen

Editorial Reviews

Product Description

Excel VBA/macro visual training on demand! 60+ lessons on DVD: users can learn what they want when they want it!

• More than 6 hours of personal one-on-one video instruction from the world's #1 Excel trainer, Bill Jelen - "MrExcel"!
• Teaches how to automate virtually any routine task in Excel... can save regular Excel users dozens (or even hundreds) of hours per year
• Viewers simply watch and learn - everything from the absolute basics through advanced techniques using filters and PivotTables

Using Microsoft Excel 2007's built-in VBA scripting capabilities, serious Excel users can potentially save dozens - or even hundreds - of hours per year. But most Excel users have never truly mastered VBA scripting, and many don't have time to read a book on the subject. That's where VBA and Macros for Microsoft Excel (Video LiveLessons) comes in. In more than 60 bite-sized, self-contained video lessons, Bill Jelen ("MrExcel") helps Excel users master all the scripting techniques they need to automate virtually any repetitive Excel task - and gives them specific answers and solutions for their scripting problems immediately, whenever they need them. He begins by introducing Excel's simple built-in macro recorder, explaining what it can and can't do, and walking through the code it produces. Next, he introduces Microsoft Excel's powerful VBA editor and debugging tools, and shows how to write the crucial code that can't be created automatically by the macro recorder. One step at a time, viewers will discover how to use loops, variables, ranges, flow control, and more. Next, Jelen puts it all together with start-to-finish case study applications, and introduces advanced techniques that automate everything from filters to PivotTables, user input to error and event handling.