In this introduction Series we are learning:What is an Excel VBA and how it is programmed in excel.
Why we use VBA - Its advantages over manual excel work.
What is a VBA Editor- where we write programming language or VBA codes. its important features - full discussion with examples
What is a macro editor recording tool.
How to start, stop and edit the macros- their full use and other important features useful for beginners
What are the limitations of macro recordings.
What are the benefits of macro recordings for beginners and how it can be useful in learning the syntaxes fast.
Do we need to remember VBA codes, If yes how and if no, then what is the correct way of learning and understanding the coding.
Are VBA and macro recording same OR different?
Why we need to learn VBA - What is the advantage of VBA over advance Excel. Who can control excel better?
A simple but yet very powerful project to help you in understanding the use of Macro editor and to showcase the power of VBA.
Data compile project completion with just a few basic VBA commands. A simple and logical approach discussion. Discussing good approach and bad approach methodologies adapt by beginners in beginning days.
Basic range and sheet, data selection syntaxes. Why and how to use the correct and most appropriate syntaxes.
What are variables - their definition, use and data types
Public, module, local and Global level variables
Use of Call keyword with Option Explicit
Name the macros and modules - rules to follow
What is a personal macro workbook in VBA - its use and advantage over normal this workbook macros
How to edit the recorded macros and use in your own projects
Discussion on some basic mistakes done by Students initially - Student doubts answered
Two assignments for students to monitor the performance.
Facilities
Location
Start date
Online
Start date
Different dates availableEnrolment now open
About this course
You will understand the meaning of Excel VBA- programming language used in excel to do the full automation in excel tasks.
You will get to know VBA automation scope and advantage of learning it.
Basic simple syntax's plus recording of macros.
Use of Variables and its data types
Questions you may expect in your interview and how to answer them
Questions & Answers
Add your question
Our advisors and other users will be able to reply to you
We are verifying your question adjusts to our publishing rules. According to your answers, we noticed you might not be elegible to enroll into this course, possibly because of: qualification requirements, location or others. It is important you consult this with the Centre.
Thank you!
We are reviewing your question. We will publish it shortly.
Or do you prefer the center to contact you?
Reviews
Have you taken this course? Share your opinion
This centre's achievements
2021
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 6 years
Subjects
Editors
MS Excel
Project
Public
Global
Approach
Benefits
Excel
Course programme
Introduction to VBA
6 lectures03:25:38A quick demo. What are you going to Learn? Let us see what is stored in for you in this section 1 - Introduction to VBA.Chapter1 This lecture will teach you about the macro editors and vba environment. We will see how to record the macro. what are the methods to run the macro and how to edit the macros and make them brilliant ones Chapter2 Welcome to series2 video of chapter1. In this video we are going to learn how we can select cells, sheets using vba. How to select the data using the perfect methods in vba. Entire chapter revolves around the selection of cell, worksheets and ranges. Chapter3 In chapter-3 of introduction chapter here we are working on a project which not only helps you to implement the VBA coding but also show you the power of macro editors which people often take it lightly .With little bit of basic VBA you can edit your macros and make them so powerful. We are learning here how to copy the data from multiple spreadsheets and paste them in different excel workbook. Though this is an introduction chapter but it will give you so much knowledge and provides the insight on the power of upcoming sessions.Chapter4 Student asked me a doubt he faced while practicing and i found it very genuine and also a good source of knowledge which i am sharing it with you. This video does not need any code support or excel file. Just go through the lecture and get your knowledge brighten today.Chapter5 We learn in this lecture what is a personal macro-workbook and how it differs from normal macros which we record . A very good learning for new students and this completes your first step as well towards the biggest start of your career in automation field.
Introduction to VBA
6 lectures03:25:38A quick demo. What are you going to Learn? Let us see what is stored in for you in this section 1 - Introduction to VBA.Chapter1 This lecture will teach you about the macro editors and vba environment. We will see how to record the macro. what are the methods to run the macro and how to edit the macros and make them brilliant ones Chapter2 Welcome to series2 video of chapter1. In this video we are going to learn how we can select cells, sheets using vba. How to select the data using the perfect methods in vba. Entire chapter revolves around the selection of cell, worksheets and ranges. Chapter3 In chapter-3 of introduction chapter here we are working on a project which not only helps you to implement the VBA coding but also show you the power of macro editors which people often take it lightly .With little bit of basic VBA you can edit your macros and make them so powerful. We are learning here how to copy the data from multiple spreadsheets and paste them in different excel workbook. Though this is an introduction chapter but it will give you so much knowledge and provides the insight on the power of upcoming sessions.Chapter4 Student asked me a doubt he faced while practicing and i found it very genuine and also a good source of knowledge which i am sharing it with you. This video does not need any code support or excel file. Just go through the lecture and get your knowledge brighten today.Chapter5 We learn in this lecture what is a personal macro-workbook and how it differs from normal macros which we record . A very good learning for new students and this completes your first step as well towards the biggest start of your career in automation field.
A quick demo. What are you going to Learn? Let us see what is stored in for you in this section 1 - Introduction to VBA.
A quick demo. What are you going to Learn? Let us see what is stored in for you in this section 1 - Introduction to VBA.
A quick demo. What are you going to Learn? Let us see what is stored in for you in this section 1 - Introduction to VBA.
A quick demo. What are you going to Learn? Let us see what is stored in for you in this section 1 - Introduction to VBA.
Let us see what is stored in for you in this section 1 - Introduction to VBA.
Let us see what is stored in for you in this section 1 - Introduction to VBA.
Chapter1 This lecture will teach you about the macro editors and vba environment. We will see how to record the macro. what are the methods to run the macro and how to edit the macros and make them brilliant ones
Chapter1 This lecture will teach you about the macro editors and vba environment. We will see how to record the macro. what are the methods to run the macro and how to edit the macros and make them brilliant ones
Chapter1 This lecture will teach you about the macro editors and vba environment. We will see how to record the macro. what are the methods to run the macro and how to edit the macros and make them brilliant ones
Chapter1 This lecture will teach you about the macro editors and vba environment. We will see how to record the macro. what are the methods to run the macro and how to edit the macros and make them brilliant ones
This lecture will teach you about the macro editors and vba environment. We will see how to record the macro. what are the methods to run the macro and how to edit the macros and make them brilliant ones
This lecture will teach you about the macro editors and vba environment. We will see how to record the macro. what are the methods to run the macro and how to edit the macros and make them brilliant ones
Chapter2 Welcome to series2 video of chapter1. In this video we are going to learn how we can select cells, sheets using vba. How to select the data using the perfect methods in vba. Entire chapter revolves around the selection of cell, worksheets and ranges.
Chapter2 Welcome to series2 video of chapter1. In this video we are going to learn how we can select cells, sheets using vba. How to select the data using the perfect methods in vba. Entire chapter revolves around the selection of cell, worksheets and ranges.
Chapter2 Welcome to series2 video of chapter1. In this video we are going to learn how we can select cells, sheets using vba. How to select the data using the perfect methods in vba. Entire chapter revolves around the selection of cell, worksheets and ranges.
Chapter2 Welcome to series2 video of chapter1. In this video we are going to learn how we can select cells, sheets using vba. How to select the data using the perfect methods in vba. Entire chapter revolves around the selection of cell, worksheets and ranges.
Welcome to series2 video of chapter1. In this video we are going to learn how we can select cells, sheets using vba. How to select the data using the perfect methods in vba. Entire chapter revolves around the selection of cell, worksheets and ranges.
Welcome to series2 video of chapter1. In this video we are going to learn how we can select cells, sheets using vba. How to select the data using the perfect methods in vba. Entire chapter revolves around the selection of cell, worksheets and ranges.
Chapter3 In chapter-3 of introduction chapter here we are working on a project which not only helps you to implement the VBA coding but also show you the power of macro editors which people often take it lightly .With little bit of basic VBA you can edit your macros and make them so powerful. We are learning here how to copy the data from multiple spreadsheets and paste them in different excel workbook. Though this is an introduction chapter but it will give you so much knowledge and provides the insight on the power of upcoming sessions.
Chapter3 In chapter-3 of introduction chapter here we are working on a project which not only helps you to implement the VBA coding but also show you the power of macro editors which people often take it lightly .With little bit of basic VBA you can edit your macros and make them so powerful. We are learning here how to copy the data from multiple spreadsheets and paste them in different excel workbook. Though this is an introduction chapter but it will give you so much knowledge and provides the insight on the power of upcoming sessions.
Chapter3 In chapter-3 of introduction chapter here we are working on a project which not only helps you to implement the VBA coding but also show you the power of macro editors which people often take it lightly .With little bit of basic VBA you can edit your macros and make them so powerful. We are learning here how to copy the data from multiple spreadsheets and paste them in different excel workbook. Though this is an introduction chapter but it will give you so much knowledge and provides the insight on the power of upcoming sessions.
Chapter3 In chapter-3 of introduction chapter here we are working on a project which not only helps you to implement the VBA coding but also show you the power of macro editors which people often take it lightly .With little bit of basic VBA you can edit your macros and make them so powerful. We are learning here how to copy the data from multiple spreadsheets and paste them in different excel workbook. Though this is an introduction chapter but it will give you so much knowledge and provides the insight on the power of upcoming sessions.
In chapter-3 of introduction chapter here we are working on a project which not only helps you to implement the VBA coding but also show you the power of macro editors which people often take it lightly .With little bit of basic VBA you can edit your macros and make them so powerful. We are learning here how to copy the data from multiple spreadsheets and paste them in different excel workbook. Though this is an introduction chapter but it will give you so much knowledge and provides the insight on the power of upcoming sessions.
In chapter-3 of introduction chapter here we are working on a project which not only helps you to implement the VBA coding but also show you the power of macro editors which people often take it lightly .With little bit of basic VBA you can edit your macros and make them so powerful. We are learning here how to copy the data from multiple spreadsheets and paste them in different excel workbook. Though this is an introduction chapter but it will give you so much knowledge and provides the insight on the power of upcoming sessions.
Chapter4 Student asked me a doubt he faced while practicing and i found it very genuine and also a good source of knowledge which i am sharing it with you. This video does not need any code support or excel file. Just go through the lecture and get your knowledge brighten today.
Chapter4 Student asked me a doubt he faced while practicing and i found it very genuine and also a good source of knowledge which i am sharing it with you. This video does not need any code support or excel file. Just go through the lecture and get your knowledge brighten today.
Chapter4 Student asked me a doubt he faced while practicing and i found it very genuine and also a good source of knowledge which i am sharing it with you. This video does not need any code support or excel file. Just go through the lecture and get your knowledge brighten today.
Chapter4 Student asked me a doubt he faced while practicing and i found it very genuine and also a good source of knowledge which i am sharing it with you. This video does not need any code support or excel file. Just go through the lecture and get your knowledge brighten today.
Student asked me a doubt he faced while practicing and i found it very genuine and also a good source of knowledge which i am sharing it with you. This video does not need any code support or excel file. Just go through the lecture and get your knowledge brighten today.
Student asked me a doubt he faced while practicing and i found it very genuine and also a good source of knowledge which i am sharing it with you. This video does not need any code support or excel file. Just go through the lecture and get your knowledge brighten today.
Chapter5 We learn in this lecture what is a personal macro-workbook and how it differs from normal macros which we record . A very good learning for new students and this completes your first step as well towards the biggest start of your career in automation field.
Chapter5 We learn in this lecture what is a personal macro-workbook and how it differs from normal macros which we record . A very good learning for new students and this completes your first step as well towards the biggest start of your career in automation field.
Chapter5 We learn in this lecture what is a personal macro-workbook and how it differs from normal macros which we record . A very good learning for new students and this completes your first step as well towards the biggest start of your career in automation field.
Chapter5 We learn in this lecture what is a personal macro-workbook and how it differs from normal macros which we record . A very good learning for new students and this completes your first step as well towards the biggest start of your career in automation field.
We learn in this lecture what is a personal macro-workbook and how it differs from normal macros which we record . A very good learning for new students and this completes your first step as well towards the biggest start of your career in automation field.
We learn in this lecture what is a personal macro-workbook and how it differs from normal macros which we record . A very good learning for new students and this completes your first step as well towards the biggest start of your career in automation field.
Introduction to Variables
4 lectures02:38:12Chapter 1 We will be taking a deep dive into the scope and type of variables used in VBA with different different examples. This will lay the foundation for the upcoming chapters in VBA so this is a must go through chapter. Knowing option explicit , types of data types - string,integer,single,double etc, public variables,global variables - we have everything covered in this chapter.Chapter 2 This video is in continuation to the previous video on variables. We are exploring more data types here and understanding theirs purpose from interview perspectives, from real mis environment perspective as well.Chapter 3 So, this chapter completes our variable discussion. we are learning the use of option explicit, types of variables and their benefits, advantages and disadvantages.Chapter 4 Before we jump on to new series we are doing quick revision on so far covered topics . This will boost our confidence too.
Introduction to Variables.
4 lectures02:38:12Chapter 1 We will be taking a deep dive into the scope and type of variables used in VBA with different different examples. This will lay the foundation for the upcoming chapters in VBA so this is a must go through chapter. Knowing option explicit , types of data types - string,integer,single,double etc, public variables,global variables - we have everything covered in this chapter.Chapter 2 This video is in continuation to the previous video on variables
Additional information
Should be well versed with Excel Front end.
Should have Ms excel installed on computer 2007 or onward versions - any