Cancelled: Excel 2010 Power User : Programming using VBA (133140-12)
Description
Enhance your productivity and save time with Excel macros. This course
will teach you how to work effectively with the Visual Basic Programming
language and the Excel Visual Basic Editor to create macro code that
goes beyond the capabilities of the macro recorder. The material is
presented in an exceptionally easy-to-follow format with examples, clear
definitions of terms and useful take-home examples. (Format: hands-on
instructor-led training)
Learning Objectives
Complete the day having designed, created and tested many macro examples
in Excel Apply easy-to-follow in-class hands-on pertinent business
examples Receive a take-home library of useful macro code and examples
Major Topics
Understand Visual Basic for Applications (VBA) Run macros in a variety of ways Use the macro recorder Examine module design Edit code in the Visual Basic Editor Assign macros to objects Create decision-making code using the If Then Else decision structure Create code for looping structures Use a For Next statement Use a Do Loop statement Use Macro management rules Use the Personal Macro Workbook for generic macro code Assign sub procedures to run automatically Create code to interact with the user and gather information from the user Use the custom message box Use the custom input box Assign macros to worksheet buttons and keyboard shortcuts Test and debug macro code Protect and hide macro code
