VBA Macro Feature Courses Video Courses

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

A
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

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