Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Excel VBA Course ( Basic To Super Advance - 42 hours) in Hindi

person icon Ajay Parmar

4.2

Excel VBA Course ( Basic To Super Advance - 42 hours) in Hindi

Complete course on excel automation using VBA for Analysts & Developers

updated on icon Updated on Jun, 2025

language icon Language - English

person icon Ajay Parmar

Lectures -37

Duration -42 hours

Lifetime Access

4.2

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

  • How to do Macro recordings. Edit it, run it, debug it.
  • How to Run VBA programs or delete them or give shortcut keys.
  • Know the concept of finding out the last row – blank row or nonblank row of your data.
  • How to select the data from top to bottom or vice versa – static and dynamic approaches with their advantages, and disadvantages over each other.
  • How to turn wrong steps into correct while recording the steps.
  • How to run a program step by step and why we need it for debugging.
  • Move from one sheet to another. What errors we can expect if the sheet name changes like a Subscript out of a Range error?
  • Know how to compile data from different sheets and put it under one sheet using recording and with a basic understanding of sheets and ranges.
  • Introduction to Variables and their data types. How to define variables and benefits of using them.
  • Data types. Strings. Integer, Single, byte, Double, Variants – we have covered all. Amazing questions coming out from these live classes.
  • What if errors like – OverFlow and Type Mismatch come – Know the reason and of course a solution.
  • What are debugging windows -Local window.
  • Why we want Option Explicit – How to declare it and what benefit it provides.
  • Frequently Asked Questions in your interview related to option explicit and Variables.
  • How to connect more than one macro using a Call keyword.
  • How long a Variable remains in VBA -Scope of a Variable – Local variable, module, private level and Public or Global level variables.
  • We are taking a deep dive into Loops and IF Functions with Select Case statements. You will not need to look back on Loops topic ever if you finish this course at the end.
  • Detailed discussion on For Next loops – their use and significance. How to mould them in different ways and use them in your projects.
  • Discussion on -While & Until loops from very basic level to advanced.
  • Which loop is better or how about making a choice in loops over each other?
  • Learn loops using the basic and complex patterns in order to get mastery. Print numbers in asc or desc or diagonally patterns.
  • Detailed discussion on IF functions and their different syntaxes. For example, Single IFs, IF AND, IF OR and Nested IFs.
  • Use of Else-IF and when to use it, How it is different from IFs without Else-IF blocks. With real-time examples.
  • How to work with hundreds of conditions in one go using IFs.
  • What is a Case Select statement- How it can be an alternative to IF conditions in VBA?
  • Dangerous to run Loops on F5 mode without testing the code.
  • How to write Sub-Loops in Loops- you will find all relevant information here.
  • IF with ELSE-IF and IF without Else IF.
  • Are we interested in compiling the data from different worksheets and workbooks?
  • How to go to different workbooks pull the data from there and compile it in one place.
  • How to work with so many sheets without bothering about things – what name they have, if they will get deleted in future or if more sheets get added.
  • These collection loops make you a great programmer. In fact, if you do not know this you can never be a great coder. Come and fall in love with them. Immensely helpful, interesting and powerful. So much fun.
  • Learn How to work with workbooks and worksheets – Open, Save, Save as, delete, rename, move, add and many more such commands.
  • How to open the workbooks, how to close one workbook, a specific workbook or all opened workbooks.
  • Learn how to delete or add workbooks, and how to jump from one workbook to another. From activating files to editing them -we are covering all.
  • How to select delete or protect rename or add the worksheets in Excel.
  • How to define the workbooks and worksheets in a professional manner using the “Set” Keyword. What is the advantage of declaring objects as classes?
  • What happens if we declare set statements anywhere in the code? Is it allowed in VBA? Detailed discussion on the proper mentioning of dim and set statements while dealing with objects and classes.
  • How VBA works when it comes to writing syntaxes. Discussion on the object hierarchy and its methods and properties.
  • Questioning rounds in a live session to students to practice more on set keywords.
  • What are collection loops and their basic syntaxes – their practical use?
  • Loop through worksheets, workbooks and cells in a workbook.
  • How to copy and paste the data from each of the sheets in a workbook or from different workbooks.
  • What if you want to copy the data from multiple workbooks, going to each of the worksheets copying the data and pasting it into one single workbook? This is going to be done using a collection loop.
  • What is a Dot Operator and how objects are classified in VBA? Learn about object methods and properties – What are these and what is the difference between them? Their significance in VBA.
  • What are arrays? Why do we use them? Why they are so powerful and hold so much weight in VBA?
  • What is their by-default index system and how we can change it using the option base?
  • What are static and dynamic arrays?
  • How to use arrays with VBA loops and if functions. They work like magic together.
  • What is the use of Preserve word in arrays and how we can use it in projects?
  • Complete the tutorial with an in-depth discussion.
  • How to use the split function in arrays and what are the key things to be taken care of while using split in arrays?
  • Questions were discussed from a VBA interview perspective as well.
  • As usual- Assignments are also added to give you confidence and to check your progress.
  • How to use Dim or Redim Statements.Their real use in projects. How to use variable values in Arrays and what is the purpose of using them in arrays?
  • How to use Split function, one of the best functions we can use in arrays. How arrays work under split function.
  • How option Base-1 works for arrays created by split function.
  • What is the use of preserve word in arrays and how we can use it to hold the values? What happens if we do not use them?
  • How and where we use them. Complete discussion on its use.
  • Vlookup use – Lookup Project using Arrays.
  • Know the two or multi-dimensional arrays and their use in practical situations.
  • We are learning everything in detail about VBA inbuilt and User-created Functions from their roots.
  • All Lectures start from the basic level and then slowly move toward advanced levels.
  • The use of Inbuilt functions like Left, StrReverse, mid, find, trim, Lcase, Ucase, Date and Time etc are discussed.
  • UDFs – User-defined functions in VBA – basic plus advanced, both level examples.
  • Benefits of UDFs over Inbuilt functions. Many amazing projects are shared in the series.
  • Can we pass in parameters in sub-routines and call Functions?
  • How do we run or Call Functions from Excel sheets? A mesmerizing thing to learn and implement in your project today.
  • How to do testing of your functions like UDFs and Inbuilt VBA Functions.
  • What is the process of passing parameters from a sub-routine to a function and how it is useful for us?
  • Frequently Asked Questions in your VBA Interview.
  • How do we use VLOOKUP in VBA at the advanced level project discussed? A real-time project is discussed.
  • How can we use the Match function with Loops and VLOOKUP to create super powerful and wonderful practical automation?
  • How to go inside a folder and pick the needed files and then do things like compiling data from them or modifying the files or moving them or deleting them.
  • Learn how to use the file-dialogs so that the user can choose any folder of his or her choice and work accordingly.
  • Not just folders or Excel files -we are also going to see what to do if we have to overwrite or append the data in text files. Yes, we can even control the text files using a scripting library, Very useful especially when you are dealing with big data.
  • Skip the files while running loops that you do not want. Set the filters in the extensions using file dialogs. Learn all types of file dialogs like open dialog. Save as dialog, folder dialog and also why and where we can use them.
  • Customization of file dialog buttons, and titles to how to open multiple files with them to make a more user-friendly and robust program that can be run on any machine irrespective of the drives or folder paths they have.
  • Learn to manipulate text files using a scripting library. We have everything discussed here from the basic level to the advanced level when it comes to file and folder manipulations.
  • We have covered all form controls like labels, textboxes, combo, list boxes, frames, option buttons, check boxes and many more.
  • How to use loops in the list box.
  • Events role in Userforms like On change, After update, initialize, Activate etc.
  • How to link combo box with list boxes.
  • How to use Listbox for multiple columns.
  • From understanding the Userform control design and properties, you shall also see the magic of user form events which are very much required to create projects.
  • All of your doubts will be answered via email or forum in 24 hours.
  • You shall learn Error handlers like On error resume next and goto err.
  • You shall see what are the scenarios when we already know we can have errors – VBA Errors so if we want to ignore those errors and continue running the VBA code, how to do that first of all, why in first place, I would like to ignore the errors.
  • We will then learn how to use and customize a message box and input box in VBA with various examples.
  • We will learn how to work with events that we write inside the workbook and sheet modules.
  • Why they are called self-triggered macros and what are the conditions – Events names we can go and use for different types of jobs.
  • Learn amazing Events like – Workbook Open, Sheet Activate, sheet before Delete, sheet change event, and Selection Change Events.
  • When one event starts calling another event and you never planned for it, how to avoid this class using a public variable?
  • A few projects for you to give you more confidence in Events.
  • We are learning about Chart automation. How to create new charts using VBA. We can fully automate the making of charts using VBA.
  • Learn the Chart class called Chart and see how easy it is to create new charts.
  • The role of macro recordings play a very important role here as most of the code we can record and later customize as per the requirement.
  • How to work with existing charts in Excel. How to go to each of them one by one and do modifications. Any type of modification like changing chart design editing labels or chart titles etc.
  • Understand the Loop's importance in charts. You can loop through infinite charts using one simple collection loop.
  • Collection loops of charts – to work with multiple charts either to delete them or to edit their design, and colours. You can do whatever. Even change the axes.
  • Use of other Collection loops with chart collection loops. Loops in Loops.
  • You will become a master in Pivots. From making new pivots to working on existing pivots and modifying them.
  • Collection loops in PIvots – how to access pivots. How to loop pivot field items and fully control them.
  • We will learn the classes we use in Pivots to handle new pivots or existing pivots like Pivot-table and Pivot cache classes.
  • We will take a deep dive into knowing other classes as well which helps us in controlling the pivot fields and field items like pivot item class and pivot-field class.
  • How to mix worksheet collection loops with pivot collection loops in real-time projects and what are the benefits of the same.
  • What is the role of macro recording in making pivots and how to edit those recordings if the requirement changes?
  • How to work with row or column of filter pivot fields. Line-by-line explanation.
  • We are learning how to connect Outlook with Excel VBA.
  • Early binding approach and Late Binding Approaches. Advantages/Disadvantages.
  • Sending auto emails, Customizing the email subject lines, body, signatures, too, cc, bcc, and attachments.
  • Copying or moving folders in Outlook.
  • Copying or moving emails from one folder to another
  • How to extract the files from Outlook emails and save them on your machine.
  • How to work with default folders, own created folders/subfolders and much more.
  • Discussing the connectivity of Excel with PowerPoint in this advanced series using Excel VBA.
  • How to copy table data from Excel and paste it into PowerPoint application slides.
  • How to export charts from Excel sheets to PowerPoint and paste them into one slide or more slides one by one.
  • Taking a deep dive into PowerPoint classes like Presentation class, Slide class and shapes class. Understanding the PowerPoint object hierarchy.
  • How every class is responsible for other classes using the dot hierarchy.
  • How to work with already created PowerPoint applications and also how to create new PowerPoint applications and work with them.
  • How to resize the charts or tables images in slides and move them to the top left or right of the slides.
  • Control which chart should go in PowerPoint using the Excel sheet cells.
  • How to loop through all sides and decide which one to delete or use for data presentation.
  • Collection loops for slides as well as shapes. This is an amazing source of learning.
  • Real-time project discussion with you to give you live exposure to working with PowerPoint.
  • Understanding the concept of Early Binding and Late Binding methods or techniques.
  • Learn about ADO Library. Active- X data object library in VBA. Why it is required and how to activate this.
  • Know about the ado library classes and use them for database connections.
  • How to set up a connection with access located on a server or local machine using Excel VBA.
  • What are recordsets in MS Access using Excel VBA and how do strings connect with databases?
  • For more databases how to plan things and see the connection strings for different types of databases.
  • How to run loops in access tables.
  • How to use SQL Commands like select statement, update statement, delete SQL syntax and insert syntax to exchange the information back and forth.
  • How to edit or change specific records in MS Access creating user forms.

Goals

  • It is divided into 5 sections - Introduction, Variables, Loops with IF, Collection Loops with Classes, Arrays & Functions - Basic to Advance.

  • This Course has 20 hours of super duper content for you starting from basic to advanced.

  • Students will learn how to automate Excel tasks with VBA from scratch. This course is from the beginning to the super advanced level.

  • Students will be able to understand VBA Fundamentals. How they can customize the syntaxes and not be dependent on the internet for any troubleshooting.

  • You will know How to record, edit, run and save Macro Recordings. What are the advantages and limitations of Macro recordings?

  • You will learn every type of Loop used in VBA like For next, do while and do until loops and why loops are needed to learn. Practical examples.

  • Learn about Variables and data types and why we need them, and Interview-related questions on Variables preparation.

  • Students will be able to learn IF statements like single IF, IFAND, IFOR and IF with else if, IF without Else If. Difference between types of IFs.

  • Mix IF with Loops by taking a live example case study.

  • Errors like overflow, data type mismatch, argument not optional, property method not defined, subscript out of range - True meaning of these errors and solving.

  • Learn about Collection Loops and take your data working to a new level. You can learn how to work with multiple workbooks - Copy Paste data tasks so easy now.

  • Learn about the set keyword- how to define objects using VBA Classes - Its methods and properties.

  • Classes like Worksheet, Workbook, Range, Worksheet Function, Strings, Info - How to use Object Browser in VBA.

  • How to use VBA Inbuilt functions and Create your own functions - User-defined functions UDFs.

  • Learn about the use of Arrays in VBA - the most important and versatile thing you ever want to know.

  • Every topic will have a Practical example discussed in detail.

Prerequisites

  • You should know basic formulas like Text functions, Lookup functions, and Excel and basic knowledge of Excel is required.

  • No prior programming knowledge is required. This course is for beginners and gradually turning into advanced.

  • Excel shortcut keys are an additional advantage like Copy, Cut & Paste and How to move from the first cell to another, and how to select the data using shortcut keys like ctrl+shift+down arrow keys, etc.

  • Excel 2007 or any higher version should be fine. VBA is compatible with all versions.

Excel VBA Course ( Basic To Super Advance - 42 hours) in Hindi

Curriculum

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

Let us start this awesome journey

37 Lectures
  • play icon Introduction to macros, recordings, vba editor and mistakes – In detail 01:28:51 01:28:51
  • play icon Variables – Its use and data types 01:43:21 01:43:21
  • play icon Scope of a Variable-Local,Global with option explicit 45:39 45:39
  • play icon Loops and If functions 37:20 37:20
  • play icon For Loops continues- More amazing patterns 01:19:47 01:19:47
  • play icon Do Loops – In depth 58:05 58:05
  • play icon SubLoops 17:08 17:08
  • play icon Workbook and sheet commands – For data automation 01:17:31 01:17:31
  • play icon Set keyword- Define objects using Classes 50:44 50:44
  • play icon Collection Loops begin – WorkSheets 01:26:39 01:26:39
  • play icon Workbook CollectionLoop with data compile 53:50 53:50
  • play icon Range collection Loops and more 01:02:03 01:02:03
  • play icon Assignment solutions – Collection Loops 02:01:28 02:01:28
  • play icon Arrays 01:32:32 01:32:32
  • play icon Functions – UDFs -Create own function 46:12 46:12
  • play icon Count occurances – Split and UDF – Awesome 48:32 48:32
  • play icon More examples on functions 48:11 48:11
  • play icon Error Handers – On error resume and GoTo err 01:43:23 01:43:23
  • play icon More on Error handlers 45:38 45:38
  • play icon Work with Files and Folders – Scripting 01:18:13 01:18:13
  • play icon File Dialogs 01:01:00 01:01:00
  • play icon UserForm – Full knowledge 01:25:36 01:25:36
  • play icon Userform events – More knowledge 59:40 59:40
  • play icon Project as a bonus-Move up Listbox items 16:01 16:01
  • play icon Move down project – bonus 17:15 17:15
  • play icon Events – self triggered macros – V imp 01:47:40 01:47:40
  • play icon Events continues 01:16:24 01:16:24
  • play icon Drop Down example on events 52:19 52:19
  • play icon Outlook Connectivity – know outlook Classes 01:22:42 01:22:42
  • play icon Connectivity with Outlook – more tough examples 01:42:21 01:42:21
  • play icon Powerpoint application connectivity – Awesome 01:39:08 01:39:08
  • play icon Powerpoint connection continues 01:10:32 01:10:32
  • play icon Charts automation 01:59:48 01:59:48
  • play icon Learn more automation on Charts 50:26 50:26
  • play icon Pivots automation- my favourite 01:01:58 01:01:58
  • play icon Pivots continues 43:52 43:52
  • play icon Database connectivity 01:32:08 01:32:08

Instructor Details

ajay parmar

ajay parmar

I have been teaching online from 13 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.

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

Annual Membership

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

Subscribe now
Annual Membership

Online Certifications

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

Explore Now
Online Certifications

Talk to us

1800-202-0515