Microsoft Excel 2010 – Advanced VBA

Target audience

Experienced Excel 2010 users who work with data and need to create tools and solutions in Excel 2010 to manage and present information.

Delegates will learn how to

• Work with Excel 2010 components using VBA
• Manipulate and present data in Excel 2010 using VBA
• Work with files and folders in Excel 2010 using VBA

Delegates will learn how to

• Record and edit a Macro recorded within Excel/Word
• Use different techniques in order to run any macros available such as keyboard commands, the use of the Quick Access Toolbars or Buttons
• Use VBA and examine the Visual Basic Editor; change the properties of an object; add a module to a project; write the code for a procedure and then run it; and use the Object Browser to search procedures
• Manipulate data by declaring variables of different data types; combine data by using expressions; use functions to accept input and display output; and declare variables and procedures with the appropriate scope
• Use decision structures to create procedures that make decisions; and use loop structures to perform repetitive tasks
• Create an error handling routine in case things go wrong with VBA code