VBA Macro Video Course - Innozant MIS & Data Analytics & Data Science
Administrator
Expert
Description
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
Topics for this course
79 Lessons24h 59m 59s
CLASS 1- VBA INTRODUCTION
VBA INTRODUCTION00:57:08
Resources-VBA INTRODUCTION
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
CV FORMAT
Project part is missing which is part of Brochure. Also, video not uploaded for Edge connectivity
Good Course for excel vba
It was wonderful video course. Dilip Sir teach via this video in simple language.
Best place to learn technical skill.
Best teacher in the world 🌎🌍🌎🌍🌎
Unique content and amazing teaching style