Excel VBA Training

Creating, editing and coding VBA (Visual Basic for Applications) macros is an essential skill for anyone seeking to develop custom Excel spreadsheet applications and automate repetitive data management processes. With AcademyX's Excel VBA training class, you will be able to design feature-rich applications that control Excel's built-in components. For example, with VBA, you can create a financial report that updates automatically based on real-time data, and design custom forms that allow users to connect to spreadsheets, initiate complex calculations, perform compound sorts on rows and columns, and update reports at the click of a button. You can make your Excel applications more usable for novices and automate tedious tasks to improve the productivity of your team.

Visual Basic Editor

  • Visual Basic For Applications
  • Object Programming
  • The Object Browser

Programming Basics

  • Data Basics
  • Scope Of Variables
  • Scope Of Procedures

Control Structures

  • Decision Structures
  • Loop Structures

Custom Dialog Boxes

  • User Forms
  • Events

Debugging And Error Handling

  • Errors
  • Debugging
  • Error Handling

Prerequisites:

  • Working experience with Microsoft Excel.
  • Prior programming experience helpful but not required.

Excel VBA training offered at four locations: