Excel VBA Introduction Series1

person icon Ajay Parmar

Excel VBA Introduction Series1

Introduction to Macro Editor, VARIABLES & Sheet Data Selection Fundamentals

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Ajay Parmar

architecture icon Excel VBA,Office Productivity,Microsoft


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  15. Call key word .

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

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

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


What will you learn in this course:

  • Aim is to introduce you to Excel VBA - What is the importance of it and how you can automate day to day office work.
  • Aim is to give you a smooth learning from very basic level. Know the macro recordings, editing and debugging of codes
  • You will be able to do basic level of automations especially data copy and paste, coloring the cells and adding the data one by one into one sheet.


What are the prerequisites for this course?

  • Basic knowledge of Excel is required
  • You should have Excel 2007 version or above installed.
Excel VBA Introduction Series1


Check out the detailed breakdown of what’s inside the course

Introduction to VBA
10 Lectures
  • play icon Introduction to Macro Editor - Let us Begin the journey.
  • play icon Introduction to VBA Editor and Macro recording 01:11:51 01:11:51
  • play icon Questions for practice Solved - Range and Data selections
  • play icon Data selection and Range commands 46:45 46:45
  • play icon A project for you - How we should Compile Data from sheets
  • play icon Project - Data Compile 47:51 47:51
  • play icon What is a Personal Macro workbook
  • play icon Personal MacroWorkbook 17:17 17:17
  • play icon Student Doubt Cleared - Great fundamental question
  • play icon Your Doubt Answered 10:02 10:02
Introduction to VBA Variables
8 Lectures

Instructor Details

ajay parmar

ajay parmar

Data Analytics Trainer

I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.

Show less

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best




Life begins at the end of your comfort zone

Awesome classes, very helpful to learn

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us