Introduction
  • Introduction of Visual Basic for Applications
  • Start with the Macro Recorder - Create your first Macro
  • Assigning the Macro to a button
  • Placing a Macro on the Quick Access Toolbar
  • Assignment - Macro Recording
Looping through Collections – Part 1
  • With & End with Statement for easy execution of codes
  • Learn about For Next Loop
  • Apply V-lookup formula with For Next loop
  • For Each to Loop through collections
  • Assignment - Hide unwanted columns
  • Congratulations!!