Excel VBA Programming

software programming language to automate and customise repetitive and complex Data Analysis and Visualisation tasks in Microsoft Excel and other office applications.

Description

VBA (Visual Basic For Applications) is a software programming language to automate and customise repetitive and complex Data Analysis and Visualisation tasks in Microsoft Excel and other office applications. It also helps to create custom forms and dialog boxes to provide interface to interact with user.

This course will teach coding or programming in VBA from scratch with real life scenarios and examples


Key takeaways

  • Excel Macros
  • Object
  • Intrinsic Functions
  • Loops
  • User Forms
  • Pivot Table Report
  • VBA
  • Code Debugging and Error Handling
Targeted Audience

People who want to do automation of their repetitive and complex excel tasks

Duration

3 Days (21 Hours)

Mode of delivery

Virtual

Course Content

This course will equip trainees with VBA programming skills like:

1. Working with Excel Macros and Its connection with VBA

2. Working with Object

3. Variables and Intrinsic Functions

4. Decision Making and Loops

5. Working with User Forms

6. Creating Pivot Table Report using VBA Code

7. Code Debugging and Error Handling