Develop a practical knowledge of VBA (Visual Basic for Applications) with Microsoft Excel. This course is for 3-days workshop is excellent for those who use Excel 2003 through Excel 2013. The participant will learn how to build programs from scratch. This is a hands-on course and trainer will incorporates VBA codes using practical business problems.
This course will help you to gain confidence on VBA Excel concept of processing data in you workbook. Some of the things you should learn in VBA are:
- How to work in the Visual Basic Editor
- How to add code to a macro
- Declaring and using variables
- Managing variable scope
- How to Create, export, and delete the code modules
- Understanding arrays
- Working with workbooks and worksheets with VBA
- Repeating tasks with loops
- How to Debug a VBA code
- Cutting, copying, and pasting cell data
- Running and triggering event procedures