VBA Macro Video Course - Innozant MIS & Data Analytics & Data Science

5.00(5)
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

Download Brochure

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

Student Feedback

5.0

Total 5 Ratings

5
5 ratings
4
0 rating
3
0 rating
2
0 rating
1
0 rating

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

2,999.00
  • Course level: Expert
  • Duration 24h 59m 59s