Comprehensive VBA and Macros Training

This online course is to learn a very user friendly programming language known as Visual Basic for Applications (VBA). This basically helps in automating the routine tasks which can be easily carried out by the computer if programmed to do so. The tutorials are explained with the help of case studies and starts right from creating the first macro.

269

 10h 43m | 95 Videos | 77853 Views |   Beginner

Online VBA and Macros Training Course

Visual Basic for Applications (VBA) is a user-friendly programming language developed by Microsoft. With VBA we can design a very good interactive screen with all the label, text boxes and buttons; and by doing proper coding with Macros, we can make this work very simpler and systematic.

A macro consists of instructions that the user can record as per his/her need & associate with a shortcut key combination or a macro name. Then whenever that shortcut key is pressed or macro name is clicked, the computer automatically carries out those set of instructions.

Through this VBA Macros Training course, you grasp over the subject. These tutorials on VBA and Macros training uses non-coding approach to automate daily tasks like publishing report, email, forms, calculations, graphs etc. You will learn all these and many more tools using a case study approach.

The aim of this program is to make a beginner start learning VBA & Macros from scratch till advanced. When we have to make repetitive reports‚ dashboards or slides‚ when the work on excel sheet gets complex and repetitive‚ the most important solution would be to automate the worksheets and save a lot of time.

Target Audience for VBA and Macros Training Course

• Suitable for students pursuing Degree, Diploma, Engineering, commerce, and all general studies.
• MBA, BBA students from all specializations
• Charted Accountant (CA)
• Also suitable for working professionals.
• People who want to work as Finance Analyst, Market Analyst, Research Analyst, Investment Banker for them Excel is the language that they should speak.

Pre-requisites for VBA and Macros Training Course

• There is no prerequisite as everything in the course will begin from scratch.

VBA and Macros Training course highlights

• Introduction to VBA

Macros are meant for saving users time in order to avoid writing repeated tasks. Through this, we will understand what is VBA and macros and where and how they can be used.

• My First Macro

Through this module, we will learn about how to use macros to create your own shortcut in excel

• VBA Environment

This module will teach us about VBA environment project explorer in detail, we will learn about its properties, how do you run, break, reset and design, what is debug and how do you solve it

• Macros with IF Condition

Through this module, we will learn about how to use macros using if the condition

• Data Filter

Through this video, we will understand how to do data filter in excel using macro recording, dynamic update, command buttons etc.

• Charting using VBA

This module will teach us how do you create charts in excel using VBA and macros as this function will help us to save our lot of time.

• Userform

Through this module, we will learn about what is user form and how to create user form textbox printing using VBA and Macros in Excel.

• Case Study for Advanced VBA Introduction

This module will guide you what are the different things that we are going to learn through the advanced VBA.

• Case Study Milestone 1 User form

Through this module we will learn about what is userform, how to create userform, and how do you insert a combo box, radio button, list box, check box in a userform

• Case Study Milestone 2 Update Now

Through this, we will understand about looping in detail where we eill understand different concepts like Looping For Next Exit For and Step, Looping For Next Nested Loops, Looping Do Until Loops etc.

• Case Study Milestone 3

This module will teach us how do you write a formula in a row and column method in excel using VBA and macros, we will also learn to do EMI calculations in excel using VBA and Macros.

• Case Study Milestone 4 Sort EMI

This module will teach us how do you sort EMI in excel using VBA and macros. We will learn about basics of the array, how do one sort the numbers using arrays, how do one sort the strings using array etc.

• Case Study Milestone 5 Create Graph

Once done with EMI calculation charts and graphs are the best way to analyze the data easily. So through this module, we will learn about how to create dynamic charts in excel using VBA and Macros.

• Case Study Milestone 6 Print Report

Through this module, we will learn about how do you print dynamic range and print the entire report using VBA and macros

• Case Study Milestone 7 Email Report

This module which brief you how to email the report with PDF using VBA and macros.

Back to top ^