| Summary: | "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."--Resource description page
|
|---|