30-days Money-Back Guarantee
Complete course on excel automation using VBA for Analysts & Developers
Updated on Sep, 2026
Office Productivity, Microsoft, Excel VBA
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
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.
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.
Check out the detailed breakdown of what’s inside the course
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.
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.