Basic Practice of Macro VBA Excel for non Programmer

If you are working on Microsoft Excel on your daily job, even more you are doing on repetition tasks such as always download and copy paste the data on the same template, compiling data from some of excel files, reconciling two or more raws of data, repetitively updating and refreshing a pivot table, creating a standad report, generating a certain standard form and many more repetitive job. You can make Microsoft Excel working for you through the powerful Macro Excel. With a little bit Visual Basic for application (VBA) programming basic concept understanding you are ready to explore how powerful this tools to simplify any job in excel even more has the high complexity process.

After completion of this program, participants will be able to:

• Understanding what the Macro is about
• Understanding the Macro correlation with the Visual Basic for Application (VBA)
• Understanding Objects, Methods, Properties and Events on the Microsoft Excel Application
• Understanding basic of Algorithm
• Open and access the Macro on Excel
• Record a Macro
• Simplify recorded Macro
• Edit a Macro and create a simple algorithm
• Create the own Macro