Thursday 24 March 2011

Experts Exchange - VBA and Excel: Going Beyond the Formula (how to trigger macros and more)

Title:
Experts Exchange - VBA and Excel: Going Beyond the Formula (how to trigger macros and more)


Video:


Description:In this one-hour session, Experts Exchange Excel and VBA Guru Brad Yundt will teach you how to go beyond the formula with Visual Basic applications. You will learn: - How to trigger macros with buttons - Where macros are stored - How to use functions in worksheet formulas - How to write sample formulas - How to record and edit a macro for reuse - How to use the macro recorder to discover VBA bits that do what you need About the Presenter: Brad Yundt is a mechanical engineer at Applied Research Associates, Inc. who has been working with Excel since 1988 and Visual Basic for Applications (VBA) since 1995. In 2003, Yundt began participating on Experts Exchange where he has since answered over 9000 questions and currently serves as a Zone Advisor for Microsoft Office and Excel. For the past four years, Yundt has been the recipient of the prestigious Microsoft Most Valuable Professional award for Excel. ** HQ VERSION AVAILABLE HERE: rdsrc.us **

Published:
25/Mar/2011

No comments:

Post a Comment