Skip to content
UdemyExcelPaid courseAll LevelsCertificate

Excel Automation: Learn VBA & Macros From Scratch! (Udemy.com)

Learn to Automate your work in Excel using VBA | NO coding experience required | Simple language for Absolute Beginners

Created by: Kamal Vaswani

Last updated June 2026

icon
What you will learn

  • Fundamentals of coding, to be able to Understand, Read & Write your own codes
  • Understand the syntax so you can read an existing code and make changes where necessary
  • Combined use of Writing & Recording to build full fledged Automations of your own
  • Save time by Automating repetitive or Routine work

How it compares

Against the other 355 rated Udemy courses in Excel on CourseDuck:

  • Rating4.5 out of 5higher than 39% of them
  • Reviews270#270 of 356 by number of reviews
  • Length7.1 hourslonger than 57% of them
  • Last updatedJune 2026more recently than 86% of them

icon
Course Description

This course is built for Existing Excel users who would like to make their life more simpler and smarter by automating manual/repetitive work in Excel.


FAQs

Q: I've never done coding before and have no background to VBA. Can I still learn it?

A: Yes, This course is mainly targeted to those who are absolutely new to coding/programming. I've trained over 5000 students with no programming background successfully. 

Q: I'm not a great learner, I find difficulty understanding and working with codes/programming. can I learn it?

A: I consider myself as the worst student. So if I can learn it, you can too. 

Q: Why is coding/programming considered so difficult? Can a person with not a great memory learn it?

A: Anything is difficult to remember and understand, if you do not have ample background to it, which answers the "WHYs?" of those concepts. Moreover, I'm myself the person who's not too great at memory, and that makes me ensure that I use simple language, with relatable examples and provide ample background to the concepts in my course. 


Q: I know how to record macros and I'm doing pretty well? What more this course has to offer?

A: Recording is just one part of your learning. there are many more concepts in VBA which a person should know, to get smarter and more efficient at coding. This course doesn't revolve around recording the macros only. It focuses more on how to Write the macros from scratch. The idea is to make sure you are able to understand the codes so well, that it becomes easy for you to make more smarter macros going forward. Refer to the course contents of this course to know the details of what will be covered in this course.


 "If you feel something is complicated or not your cup of tea, its majorly because you tried jumping on the advanced concepts rather than absorbing the basics first"  -  

This course is an effort to provide ample background of each concepts and stresses on the fundamental areas to ensure that you learn it correctly and can re-implement the concepts when required.


After completing this course you will be able to:

  1. Build your own full fledged macros from scratch

  2. Write your macros

  3. Understand your macros

  4. Edit/Modify your macros to improve performance

  5. Create your own User Defined Functions

  6. Auto execute Macros on Several Events.

  7. Re implement the concepts to different problems

  8. Start Loving to code (in case you currently don't)

Looking forward to having more interactions with you in the course.

Happy Learning!

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Kamal Vaswani

My Experience: I come with a decent 10,000+ hours of training individual, corporate and online live and video mode. 

My Background: I come from a commerce background and most of the topics you see me teaching here have not much link to my background. 

My Story: I had a hard time learning these skills, specially coding (was completely beyond my dreams). But after learning it the hard way I did find ways to make it simple to understand. Exactly what one needs. I very closely understand the pain of learning something new and thus my effort is to make sure your learning experience is less painful.

My Approach: I follow a "Medicine Approach" in all my training. This is to ensure you learn something only after a proper understanding of the problem/Pain area.

My strength : to make things simple for understanding. I enjoy doing this. I hate making things complicated. 

I Believe: "If you ever see yourself struggling with the advanced concepts, question your basics". A strong foundation will make your advanced knowledge more Powerful. 

icon
More Excel courses

$39.99

Free

$99.99

Free

$15.99

$119.99

icon
Reviews

4.5

270 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Sanjeev Kumar on 12/29/2025

Really enjoyed completing this. Wanted to have more assignments on so that within course there will be more practice.

By Ravindra Pujari on 8/31/2021

Could give more examples on how to make macro more dynamic

By Charisse Zshornack on 3/13/2020

This is really a 5 Star course, I learn a lot of new knowledge. This will help me to create a template in my daily tasks. The course get easy to understand because on how you explain everything, in the future I want to learn more about the dim, I really don't know how to use it. Thank you!

By Lakshmikanth Pissay on 1/11/2020

Thanks Kamal and Udemy! This was definitely a good course for me to start with learning macros. It is quite interesting and I wish I had done this long ago! Good basic knowledge given and slowly and precisely articulated. There were very few exercises though. If you can include a source where more practice exercises can be obtained from, it would be an icing on the cake for this course. Thanks, Lakshmikanth

By Peter Galligan on 9/16/2019

Great course. Kamal goes over the underlying principals for each concept before showing it in practice. It's a great way to get started on this topic for those with little experience in VBA or Excel.

By Per Christner on 7/30/2019

A very good match for me and the course is very well taught. It really teaches you VBA from the base up. I have been doing a few youtube tutorials in VBA from scratch, but those tutorials are far from the knowledge this course cointains. The way you talk and use your language really helps to actually do while listening which for me accelerates my learning. Ofcourse you can't teach it all in one course. I feel I was missing the Dim and Set of variables. This is pretty easy to learn yourself on youtube though, but when googling for help, the Dim As is widely used and it was a little bit difficult to understand. Overall - Great! Worth every penny, and then some. Thank you! Kind Regards Per Christner - Sweden

By M Taufique Khan on 10/16/2018

I learnt about functions and real-world examples. The course was designed exceptionally wonderful. The methodology was excellent as all assignments were solved in detail. The instructor was very helpful and patient. There is a minor point to be mentioned that two words 'Module' and 'Generic' were pronounced in Hindi accent. I wish all the best for Mr Kamal Vaswani.

By Fernando Carraro Aguirre on 6/24/2018

Hace tiempo que no programaba usando VBA. El curso me parece de buen nivel. Las explicaciones son claras y directas. It has been a long time since I programmed using VBA. The course seems to me of good level. The explanations are clear and direct.

By Bijendra Singh on 6/10/2018

Kamal quick responsive to any question that you put across makes this course top of the chart. had a great fun and learning experience while doing this course and assignments. looking Forward for advanced VBA Courses from Kamal.

By Rajneesh on 4/17/2018

The course is really good for people who have no prior knowledge of VBA. Kamal starts off with the most basic concepts of VBA and works through the way up. The pace is comfortable enough to pick up things on a conceptual level. You can always ask questions if you need more clarifications. I have only completed the Theory section as of now but have full faith that the rest of the course will be as engaging and satisfactory.

Showing all 10 reviews on CourseDuck

Read all 270 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100