Microsoft Excel 2007 VBA Programming

Course Aims
This intensive, hands-on one-day training course has been designed to teach delegates how to apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2007.
Who Should Attend?
Advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA). Note: delegates should have a solid knowledge of Microsoft Excel 2007, including how to create, edit, format, and print worksheets that contain charts, and how to sort and filter data.
Course Outline: Microsoft Excel 2007 VBA Programming
Developing Macros
· Create a Macro with the Macro Recorder · Edit a Macro · Debug a Macro · Customize the Quick Access Toolbar and Hotkeys · Work with Macro Security
Formatting Worksheets Using Macros
· Insert Text · Format Text · Sort Data · Duplicate Data · Generate a Report
Creating an Interactive Worksheet
· Determine the Dialog Box Type · Capture User Input
Working with Multiple Worksheets
· Insert, Copy, and Delete Worksheets · Rename Worksheets · Modify the Order of Worksheets · Print Worksheets
Performing Calculations
· Create User-Defined Functions · Automate SUM Functions