Visual Basic for Applications – Excel VBA – for user application
Learn how to do macros in EXCEL VBA and applications to automate Microsoft Excel with Visual Basic for applications
The course will guide you to navigate on VBA Macros tools to create the Excel reporting structure and manage the business processes. There will be workshops and assignments of real business process examples to be used.
At the end of this course, the participants are expected to:
-Learn from the basic concepts to the principles to build your own applications in Excel using VBA.
-Understand and digest the concept of object oriented programming and remove barriers from being scared to see programming code.
-Be able to retrieve data from databases or other files and present them in Excel files.
-Create automated procedure to format data, display information and create complex reports and graphs.
Who Should Participate
Any Professional with an advanced understanding of Excel adheres to create dashboards which will add face value to their spreadsheets Displaying with simplicity and interactively