VBA Macro Video Course - Innozant MIS & Data Analytics

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

 

Coming Soon…

Topics for this course

62 Lessons24h 59m 59s

LECTURE: 1- VBA INTRODUCTION

VBA INTRODUCTION57:08
Resources-VBA INTRODUCTION

LECTURE: 2- MACRO RECORDING

LECTURE: 3- RUN MACRO – VBA LIBRARIES

LECTURE: 4- EXCEL VBA OBJECT MODEL

LECTURE: 5- VBA REFERENCING

LECTURE: 6- VARIABLE DATA TYPES

LECTURE: 7- VARIABLES

LECTURE: 8- VBA DECISIONS

LECTURE: 9- VBA LOOPS

LECTURE: 10 – VBA FOR EACH LOOP

LECTURE: 11- VBA DO WHILE LOOP

LECTURE: 12- LOOP RECAP

LECTURE: 13- VBA ARRAY 1

LECTURE: 14- VBA ARRAY 2

LECTURE: 15- ARRAY MORE

LECTURE: 16- VBA COMPARE

LECTURE: 17- VBA FUNCTION 1

LECTURE: 18- VBA FUNCTION 2

LECTURE: 19- VBA FUNCTION 3

LECTURE: 20- ERROR HANDLING 1

LECTURE: 21- ERROR HANDLING 2

LECTURE: 22- FILE FOLDER HANDLING 1

LECTURE: 23- FILE FOLDER HANDLING 2

LECTURE: 24- FILE FOLDER HANDLING 3

LECTURE-25-USER FORM 1

LECTURE-26-USER FORM 2

LECTURE-27-USER FORM 3

LECTURE-28-USER FORM 4

LECTURE-29-EVENT HANDLING 1

LECTURE-30-EVENT HANDLING 2

LECTURE-31-EVENT HANDLING 3

More Videos Uploading Soon

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