Excel VBA MACRO KickStart Course for absolute beginner

A perfect MS-Excel VBA (macros ) starter course from industry experienced programmer
4.7 (11 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
100 students enrolled
Take This Course
  • Lectures 31
  • Length 2.5 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2015 English

Course Description

Interested in learning macros?

Either you wanted to learn macros to automate your task or to start your career in VBA programming or just wanted o highlight your performance in appraisals using VBA then this is perfect starter course for you,

We can automate several lengthy tasks like reporting, data analysis and so on.

This is starter course to VBA & Macros for absolute beginner. You will get familiar with use of macro recordings to automate tasks, basic concepts and learn some important techniques which will help you to improve your code and get more from recorded macros. You will also learn Excel formulas and references types.

You will get discount coupons for my others upcoming course for as you will be an existing students.

What are the requirements?

  • Basic Knowledge of any MS-Excel (2013, 2010, 2007 or 2003)

What am I going to get from this course?

  • Set up security level in Excel for your macro as per need
  • Run existing macros
  • Create and use buttons for your macros
  • Macros supported file format
  • Record macros to automate your task
  • Improve your Macros
  • Different Excel formulas and referances
  • Effective use of Visual basic editor and tools
  • Learn Excel Formulas
  • Learn VBA object model application in macros
  • IF Condition
  • IF Block
  • Types of IF Statements
  • Select Statement
  • Loop concept
  • While Loop
  • For Loop
  • Usages of Do Until Loop
  • Designing User Forms
  • Adding Code to controls of User Forms
  • Enhancing User Forms

Who is the target audience?

  • Anyone who is willing to learn macros

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Overview

You will learn usefule excel formulas and how to learn any new formula in excel


You will learn types of excel formula referances and how to use them

3 questions
Section 2: Excel VBA Overview

You will learn VBA object model


you will learn how to setup VBA editor and its important tools

5 questions
Section 3: Introduction to Macros

You will learn different types for files and their pro n cons


You will learn different types of macro security

5 pages

You will get overview of macro recording in this lecture

4 questions
Section 4: Jump into Macros

You will learn how to run existing macros


You will learn how to record macros

3 pages

You will learn how to delete a macro


You will learn types of macro recordings


You will learn different ways to trigger your macros


You will learn how to run your recorded macro on specific event

5 questions
Section 5: Basic VBA Programming

You will write your first VBA program


You will first time interact with variables in your program.


You will learn different types of variables


You will learn variable declaration, its advantages, how to use comments and expert developers best pratices

Section 6: Using conditions
IF Condition

You will learn how to write code for more than one condition


You will learn different types and IF statement and how to efficiently use them into your VBA code


Another Type of Condition

Section 7: Loops

You will get introduction of loop and its components.


You will see how to use while loop with an example


You will learn use of For Loop


This lession will explain a special type of for loop which you will be able to apply on objects


This loop has different working pattern

Section 8: Using Forms

You will be able to design form as per your requierment.


You will learn how to write a code for a specific control of form in VBA


You will learn key points to enhance your forms to give it a proffessional touch

Section 9: Tweak Macros

You will learn how to improve your macros


Congratulations!! You have completed macro starter course.

2 questions

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Rajesh Mhatre, Senior Software Engineer

My name is Rajesh Mhatre.

I was crazy to get a programming job. I started from automation with VBA and I really loved it. I started reading books from different authors checking videos but just this did not helped me to achieve mastery but when I worked on different real development projects I got that expert shine. I used to work 12- 14 hours per day as it became my passion.

Now I am having 7+ years of experience. I worked for different companies such as IT Firms, Investment Banks, Accounting firms and KPO on different roles such as MIS Specialist, Automation specialist, Senior Software developer and every where I experienced different use and power of VBA. I like to teach and I turned many students to a software developer. I also write blog so such students can get tips.

I wanted to share my all core knowledge to all of you. So you don't have to spend so much time to become an expert.

Ready to start learning?
Take This Course