Online Excel VBA Training Videos

(Become a professional in VBA with our self paced online course)

Excel VBA Online Training


Excel VBA Training Videos

Course Details
Name: Excel VBA Training Videos
Total Videos: 44
Language: English
Skill Level: All Level Advanced Excel Online
Price: Rs.2500

Includes:
  • Free life time access to the videos
  • 7 days money back guarantee
Rating: 4.5 stars, based on 67 reviews
Short Description of Course
An online training program for Excel VBA. It is covered in nearly 4 hours of videos and covers exhaustive list of topics. This course will help you to learn Excel VBA from very scratch. This course is helpful for beginners as well as advanced users.

About Excel Visual Basic of Application (VBA)

Excel VBA (Visual Basic for Applications) is the name of the programming language of Excel.

Excel has so many limitations which we can overcome with the help of Macro. Macro is program written using VBA.

Using VBA, one can create own shortcuts and functions in Excel.

List of VBA Videos included in this Course

Recording and Basics of Macro VBA
1. How to Record Basic Excel Work and Assign Shortcut 6Mins 24Secs
2. How to Enter Data In Same Worksheet - First Macro 7Mins 22Secs
3. How to Enter Data In Different Worksheet - Second Macro 3Mins 40Secs
4. How to Insert Title or Comment to Macro 2Mins 20Secs
5. How to save a Macro File 1Mins 31Secs
6. Dealing with Macro Security 1Mins 29Secs
7. Use of Input Box and Formula Command 8Mins 10Secs
8. Use of Inputbox, Msgbox, Formula in different way 7Mins 09Secs
9. Inserting Command Button And Assigning Short Cut Key 5Mins 28Secs
10. How to Create Personal Macro 3Mins 8Secs
11. How to delete a Personal macro and Personal Macro Workbook 3Mins 15Secs

Usefull VBA Commands
1. How to write value to a cell using VBA 3Mins 15Secs
2. How to affect all cells in a worksheet using VBA 1Mins 50Secs
3. How to cut and paste data from one sheet to another sheet using macro VBA 5Mins 50Secs
4. Break Points And Call Command in VBA 5Mins 48Secs
5. Select, Add, Rename and Delete Worksheet using VBA 7Mins 16Secs
6. How to add data in another sheet using macro VBA 7Mins 52Secs
7. How to handle the error in macro - Part 1 10Mins 24Secs
8. How to handle the error in macro - Part 2 5Mins 52Secs
9. Use of WITH Command with example 2Mins 56Secs

Use of Excel Formulas and Functions in VBA
1. How to use Offset Function to put variables in excel dynamically 7Mins 27Secs
2. Assign Result based on marks using IF, Offset and For Next Command 6Mins 46Secs
3. Assign Grades based on marks using IF, Offset and For Next Command 5Mins 35Secs
4. Select Case 8Mins 57Secs
5. Use of Do While and Do Until 7Mins 12Secs
6. Use of Vbyesno on Msgbxo to provide flexibility in running macro 5Mins 32Secs
7. Use of Formula Command with For Next command 5Mins 41Secs
8. Use of Do While and For Next command 13Mins 23Secs
9. Recording macros with Relative References 2Mins 47Secs
10. Transpose the Data with Do While Loop - Part 1 9Mins 10Secs
11. Transpose the Data with Do While Loop - Part 2 4Mins 27Secs
12. How to create User Defined Function 8Mins 55Secs

Work Sheet and Wook Book Events
1. Introduction to Events - Activate & Deactivate Events 3Mins 40Secs
2. Autofit Column Width with Change Event 4Mins 10Secs
3. Workbook Opening and Closing Events 2Mins 25Secs

User Form in Excel
1. Understanding first basic Userform 1Mins 13Secs
2. Basic example on how to create Userform - Part 1 5Mins 40Secs
3. Basic example on how to create Userform - Part 2 3Mins 20Secs
4. Use of Userform without defining Variables 1Mins 43Secs
5. Use of Combobox to provide defined list 3Mins 45Secs

Case Studies on VBA
1. How to transfer data to another work book automatically with VBA 11Mins 05Secs
2. How to transfer data to another work book based on criterias with VBA 12Mins 09Secs


Free Financial Modelling Videos
Name:
Mobile:
E-mail:
Course:

Links of videos will be sent to your email

Live Weekend Courses

16 Sessions
4 hrs/session
Rs. 22,500
4.6 Stars

12 Sessions
4 hrs/session
Rs. 12,000
4 Stars

24 Sessions
4 hrs/session
Rs. 25,000
4 Stars
Online Courses - Our Packages

250 Videos
19 hrs
Rs. 6000
4.4 Stars
(3 in 1)
180 Videos
13.5 hrs
Rs. 4000
4 Stars
Individual Online Courses

117 Videos
6.5 hrs
Rs. 2200
4.4 Stars

44 Videos
4 hrs
Rs. 2500
4.5 Stars

20 Videos
2.5 hrs
Rs. 2000
4.2 Stars

18 Videos
1hr 45mins
Rs. 2000
4.1 Stars

24 Videos
1hr 40mins
Rs. 2000
4.4 Stars

16 Videos
1hr 20mins
Rs. 2000
4.2 Stars

12 Videos
1hr
Rs. 2000
3.9 Stars
Corporate Training
At Investment Banking Institute, we understand that different Individuals have their own set of requirements and we work closely with our corporate clients to understand and define requirements of the participants and create a customized program that addresses stated goals..
Rating from our Students
IBinstitute
Well designed courses, great content, superb trainer, excellent support
Aggregate Rating: 4.5 out of 5 with 200 ratings

Know Your Course and Trainer


Contact Us
IBI- Investment Banking Institute
1/2, Near Metro Pillar No. 182,
Near East Patel Nagar Metro Station
New Delhi-110060
Call:09312222566, 09896999313, 011-45092926

Follow




Page Tags

Excel VBA Training Videos

Excel VBA Training Online

excel vba training in delhi

excel vba training institute in delhi

excel vba training

excel vba tutorial

excel vba tutorial for beginners

excel vba coaching in delhi

excel vba classes in delhi

Certification in excel VBA

Certification course in VBA excel

Rating from our Students

IBinstitute
Aggregate Rating:
4.5 out of 5 with 200 ratings
Investment Banking Institute
1/2, Near Metro Pillar No. 182,
Near East Patel Nagar Metro Station
New Delhi-110060
Call:9312222566, 011-45092926

Copyrights © 2011-2018 All Rights Reserved.