Excelrocker has designed a two days’ workshop not only to empower the participants with the basics of macro but also to train in designing and customising the macro program with simplified logic as much as possible so that it's easy to learn VBA.
WHAT WILL I LEARN
If you are performing repeated actions on workbooks or sheets, it may be possible to automate that work. Importing data, cleaning that data, archiving existing information and similar activities are good candidates for automation in Excel. VBA provides extra options for developers looking to automate Excel.
WHO IS THIS FOR:
Users familiar with recording and editing basic macros in Excel who want to go further in automating and customising Excel using VBA – Visual Basic for Applications. No previous programming experience is required but an expert level of Excel use is assumed.
The course provides a solid foundation in Excel VBA. Using Excel VBA will extend your knowledge of recorded Macros and provide you powerful skills to automate Excel. This course explains how and where Macros can be useful in Excel and how to use Excel for as much of the “heavy lifting” as possible.
CONTENTS IN BRIEF:
MS Excel Overview.
Recording a Macro. Reviewing the macro code,
Overview of VBA & Office
Objects , methods and Properties,
Form Designing and Control
Loops and Creating reusable VBA Code
Creating User Defined Functions ( UDF)
Error handling, Debugging.
Security and many more.