VBA Macro : Video Course

Administrator Expert

About Course

This Video Course is a Project Based Course on Excel VBA (Visual Basic for Applications) and Excel Macros.

Visual Basic for Applications is a computer programming language developed and owned by Microsoft. With VBA you can create macros to automate repetitive word- and data-processing functions, and generate custom forms, graphs, and reports.

What you will learn:

  • Learn how to automate daily routine tasks within Excel
  • Learn best practices when creating macros and streamline your VBA code
  • Determine when it’s best to use the Macro Recorder versus VBA
  • Learn how to write custom VBA Macros to create more robust automation
  • Learn VBA programming concepts to create dynamic, re-usable code
  • Complete real world Macro/VBA projects from beginning to end

Benefits:

  • Life time accessibility
  • Flexibility to learn at your own time and pace with no interruptions.
  • 30+ pre-recorded video lectures
  • Topics covered in sequential manner in full depth.
  • Assignments and other resources.
  • Doubt sessions: Once or twice a month
  • Certificate on completion
Show More

Course Content

CLASS-1-VBA INTRODUCTION

  • VBA INTRODUCTION
    00:00

CLASS-2-MACRO RECORDING

CLASS-3-RUN MACRO – VBA LIBRARIES

CLASS-4-EXCEL VBA OBJECT MODEL

CLASS-5-VBA REFERENCING

CLASS-6-VARIABLE DATA TYPES

CLASS-7-VARIABLES

CLASS-8-VBA DECISIONS

CLASS-9-VBA LOOPS

CLASS-10–VBA FOR EACH LOOP

CLASS-11-VBA DO WHILE LOOP

CLASS-12- LOOP RECAP

CLASS-13- VBA ARRAY 1

CLASS-14- VBA ARRAY 2

CLASS-15- ARRAY MORE

CLASS-16- VBA COMPARE

CLASS-17- VBA FUNCTION 1

CLASS-18- VBA FUNCTION 2

CLASS-19- VBA FUNCTION 3

CLASS-20- ERROR HANDLING 1

CLASS-21- ERROR HANDLING 2

CLASS-22- FILE FOLDER HANDLING 1

CLASS-23- FILE FOLDER HANDLING 2

CLASS-24- FILE FOLDER HANDLING 3

CLASS-25-USER FORM 1

CLASS-26-USER FORM 2

CLASS-27-USER FORM 3

CLASS-28-USER FORM 4

CLASS-29-EVENT HANDLING 1

CLASS-30-EVENT HANDLING 2

CLASS-31-EVENT HANDLING 3

CLASS-32-CONNECTING TO MS POWERPOINT-1

CLASS-33-CONNECTING TO MS POWERPOINT-2

CLASS-34-CONNECTING TO MS ACCESS

CLASS-35-CONNECTING TO OUTLOOK

CLASS-36-CONNECTING TO OUTLOOK

CLASS-37-VBA PIVOTS

CLASS-38-VBA CHARTS

CLASS-39-VBA CHARTS

₹5,999.00
  • Course level: Expert
₹5,999.00
whatsapp whatsapp