Sikhiya Institute

VBA ( Macros) enables the professionals to gain proficiency in handling basic Programming command and tools. This certification training helps the users to enhance their understanding of the basic to Advanced level of macro program for organizing, visualizing, calculating and Segregation/ Consolidation of  data in MS Excel 2013. It is ideal for those who are looking to improve their job prospects by adopting Advanced Macros fundamental skills and knowledge.

During this course you will build a foundation of working with  VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.

Course Details

• Introduction to Macros
• Introduction to Object Model
• Declaration of Variables
• Loop Statements
• Decision Making Statements
• Go To Command
• Loops
• Data Segregation
• VBA & WorkSheetfunction
• User Defined Functions
• Recording of Macros
• User Forms
• Activities