AKME Analytics

Get In Touch

+ =

Join Advanced Excel Course in Gurgaon. Weekend Classes for Working Professionals!

VBA is a very supportive tool with MS Excel with excellent features.

Advance VBA Macro Training Syllabus

  • Introduction of VBA Macros
  • Recordings Macro
  • Working with VBA Editor
  • VBA Programming Concept
  • VBA Syntax and Semantics
  • Variable Type and Declaration
  • Decisions Making with Operators
  • Repeating Actions with a Loops
  • Procedures and Events
  • Functions
  • User Forms and GUI
  • Sort and Filter, PivotTables and Pivot charts with VBA Macros
  • ODBC Connectivity to SQL Database and Query Handling
  • File Handling