VBA and Macros for Microsoft Excel

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 worlds #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 2007s 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 dont have time to read a book on the subject. Thats 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 Excels simple built-in macro recorder, explaining what it can and cant do, and walking through the code it produces. Next, he introduces Microsoft Excels powerful VBA editor and debugging tools, and shows how to write the crucial code that cant 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.