Course

Visual Basic for Applications (VBA) in Excel: Level 01

Excel might be a versatile tool for quick reporting. But it is very error prone and a lot of manual effort is required to generate reports or dashboards. Visual Basic for Applications (VBA) in Excel is a programming language which can help reduce loads of effort and errors. This course explains in brief everything you need to know about getting started with using VBA in Excel.

7 Lessons

Outcomes

By the end of the course, learners would be able to:

  • Apply the following key concepts in their daily tasks:
    • Use the correct data type for a particular variable
    • Declare variables based on their scope and lifetime
    • Use modules and procedures as and when necessary
    • Be able to debug runtime and complilation errors
    • Follow industry VBA naming and coding conventions
  • Reduce time and manual effort and improve efficiency by automating through VBA
  • Draw contrasts again using conventional excel (pivot table, ranges etc.)
 Level: Level 01
Duration: 7 hours
Pre-requisites: Excel: Level 0
Dashboarding 101
What’s next: TBD