Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel VBA Introduction- Data Analytics Series1
Highest Rated
Rating: 4.8 out of 5(18 ratings)
402 students
Created byajay parmar
Last updated 10/2021
English

What you'll learn

  • First step towards learning Excel VBA - Macro recordings, fundamentals, Range commands, why variables,types variables, cal keyword, interview related question
  • Great start for beginers
  • What is VBA and why it is required in Excel.
  • Introduction to Macro Editor. How to record, save and Edit a macro. Step by step in detail
  • How to work with Range , cells and data copy commands. Why you don't have to remember them.
  • Work with Sheets and data copy in this very first introduction and see the power of Macro Editors.
  • Limitations of Macro Editor and Advantages of macro editor. How to use them in your favor always.
  • Mini project on Data compile. How to copy data from different sheets and paste into one sheet with no hand written code.
  • Get the last row and how to select tables - Static and Dynamic methods. Which one to use and when to use it.
  • Different ways to run a macro. For users as well as developers.
  • Introduction to Variables. Its data types like string, long, byte, single, double and variant.
  • Why do we need data types and difference between these data types.
  • How to know the problem when error comes like Overflow, Type mismatch , Subscript out of range.
  • Scope of a variable- Public , Module level and local variables - in full detail using Call Keyword
  • Assignments on introduction to macro plus Variables is also shared with you. It has solutions as well.
  • What is an Option Explicit. How to activate it and is it required always?
  • What is type mismatch , subscript out of range and overflow erros in vba - Cause and solutions
  • Questions you may expect in your interview regarding Variable and Error messages. Full on preparation in the course itself.
  • A practical project for you showing the use of range commands and macro recordings. How to compile the data from multiple sheets and paste into one sheet.

Course content

1 section • 10 lectures • 6h 3m total length

  • Quick Glance at the course. What you will learn today.11:50

    Let us see what we have to do in this first series of Excel VBA. Obviously , as name itself suggest, this is a first series so we are going to enter in EXCEL VBA world. To make your experience memorable and enjoyable I am not only discussing about the subject but also how to implement things practically. So, come and join me in our first introduction series where we will be talking about Variables and Macro editors .

  • Introduction to VBA Macro Editor - Recording and Syntaxes1:11:51

    • This series1 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 - Which one is the best.

    • how to edit the macros and make them brilliant ones

    • How to view VBA Editor from excel

    • What is a project browser and standard toolbars

    • How to insert modules

    • How to run macro for testing the code line by line

    • How to edit the macro - know the fundamentals

    • How to select the cells using range commands

    • How to select the sheets.


  • Assignment Questions on Range and Data Selections46:45

    • Welcome to Part2 now. 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 cells, worksheets and ranges.

    • Focus on selection syntaxes as they are the basics to begin with.

  • Project for you - Compile data from different sheets - Fundamentals47:51

    • 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.

    • Data compiling is so easy and this is what you will learn today. It is just our first chapter and with few basic things if we know like how to find the last row, how to select the cells, how to activate sheets and what are dynamic and static ways to work with Ranges, you can still do so much.

  • Macro Limitation - Student Question Answered10:02

    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.

  • What is a Personal MacroWorkbook17:17

    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 data types56:09

    • 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 & Variant data type.

    • Which data type one should use and why . Practical scenarios discussed and what type of questions one can ask in VBA Interview.

    • Scope of a Variables like - Public variables, Global variables & Local Variables - we have everything covered in this chapter.

    • Let us learn first the data types used in VBA like byte, integer, single, double, string, variant

    • Difference and similarities between these data types.

  • Introduction to data types and Option Explicit35:47

    • 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.

    • Why we need string data type

    • What is variant data type

    • Confusion and doubts with regards to overflow and type mismatch errors

    • When and when not- you should use variant data type

    • What happens if you do not use Dim key word

    • What is option explicit - Is it required and how we can on this feature

    • Interview related questions which can be asked to you

  • Scope of a Variable - local and module and public with CALL Keyword30:31

    • How to write and use local, module level and public level variables.

    • Learn how to use Call keyword.

    • When you should use local or module level or public level variables.

    • How to carry forward variable values

    • How long a variable exist in a VBA memory.

    • Does local variable is better than module or private or public level variables.

    • Which one you should use with clear explanations.

    • Can you use Call keyword across modules apart from within the modules.

    • Rules to follow while giving names to sub routines


  • Assignment Discussion for more confidence35:44

    Before we jump on to new series we are doing quick revision on so far covered topics . This will boost our confidence too.

Requirements

  • Basic knowledge of Excel and you need to have excel installed

Description

  • I am here to make you awesome in Excel VBA. Let us take a deep dive into VBA and learn it from the beginning.

  • We are starting with Macro recorder introduction. How to record steps and play it later using VBA.

  • How to Edit the existing macros if your boss want you to change few lines.

  • How to Run macros or delete macros or give shortcut keys. There are different ways to execute your program or macro. Know all of them.

  • How to find out last row and how to select the data. We have discussed Static and Dynamic , both approaches and their advantages ,disadvantages over each other. Everything is discussed in full detail. Great for freshers who do not know anything about programming.

  • How to correct Macros if they are recorded with wrong steps.

  • How to run macro step by step which we need it for debugging.

  • How to move from one sheet to another. What errors we can expect if sheet name changes and how to sort out your issues.

  • Introduction to Variables. What are variables and why do we need them. How to declare them.

  • Data types of Variables and their significance in your project. Strings. Integer, Single, byte, Double , Variants - we have covered all.

  • Grip over variable related errors - overflow and type mismatch - Why they come and how to resolve the issues.

  • Use of Local window for better testing of your code. How to activate it and how to use this window.

  • Option Explicit - How to declare it and what benefit it provides.

  • Frequently asked Questions related to Variables asked in your interview.

  • Call key word .

  • Scope of Variable - Local, module, private and Public level variables . In full detail everything is covered.

  • Assignments solutions are also provided in the form of file as well as lecture video explaining it.

  • We have a long way to go and i promise you wont be disappointed after taking this program. We have live project discussions and assignments for you to practice. You will not only learn here but also know how to implement the VBA in real environment.

Who this course is for:

  • Anyone who knows basics of Excel and want to make career in Data Analytics. It is a time for Automation.
  • Professionals who want to automate every task in Excel using VBA. Bye bye to manual work

Report abuse