Microsoft Office Training – VBA Macros

Course Topics

  • What is Macro
  • Recording and running macro
  • Security Levels in Macro
  • Editing macros using VBA Editor
  • Understanding the project explorer
  • Exploring properties window
  • Modifying code in code window
  • Variables, data types and constants
  • Arrays
  • Designing Forms
  • Creating Subroutines
  • Advanced Programming Techniques
  • Introduction to UDF’s
  • Working with Pivot Tables & Charts
  • Creating and Using Addins