Excel VBA Introduction Series 1

Course

Online

£ 10 + VAT

Description

  • Type

    Course

  • Methodology

    Online

  • Start date

    Different dates available

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

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Emagister S.L. (data controller) will process your data to carry out promotional activities (via email and/or phone), publish reviews, or manage incidents. You can learn about your rights and manage your preferences in the privacy policy.

Reviews

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 lectures 03:25:38 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. 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 lectures 03:25:38 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. 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 lectures 02:38:12 Chapter 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 lectures 02:38:12 Chapter 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

Excel VBA Introduction Series 1

£ 10 + VAT