Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel VBA MACRO KickStart Course for absolute beginner to your Wishlist.

Add to Wishlist

Excel VBA MACRO KickStart Course for absolute beginner

A perfect MS-Excel VBA (macros ) starter course from industry experienced programmer
4.6 (8 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.
109 students enrolled
Created by Rajesh Mhatre
Last updated 10/2015
$10 $50 80% off
2 days left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
  • Basic Knowledge of any MS-Excel (2013, 2010, 2007 or 2003)

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.

Who is the target audience?
  • Anyone who is willing to learn macros
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 31 Lectures Collapse All 31 Lectures 02:21:16
2 Lectures 10:24

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

Preview 05:46

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

Preview 04:38

3 questions
Excel VBA Overview
2 Lectures 08:09

You will learn VBA object model

VBA Object Model

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

VBA Editor and tools

5 questions
Introduction to Macros
3 Lectures 06:00

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

Excel File types

You will learn different types of macro security

Macro Security

You will get overview of macro recording in this lecture

Macro Recording Tips
5 pages

4 questions
Jump into Macros
6 Lectures 12:15

You will learn how to run existing macros

Running Macros

You will learn how to record macros

Recording macros

You will learn how to delete a macro

Deleting a Macro
3 pages

You will learn types of macro recordings

Macros recording types

You will learn different ways to trigger your macros

Trigger your macros

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

Excel Events

5 questions
Basic VBA Programming
4 Lectures 14:03

You will write your first VBA program

First VBA Program

You will first time interact with variables in your program.

Using Variables

You will learn different types of variables

Variable Types

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

Variable Declaration
Using conditions
4 Lectures 29:35
IF Condition

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

IF ... Else...

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

Types of IF Statements

Another Type of Condition

Select Case
5 Lectures 30:47

You will get introduction of loop and its components.

Simple Loop

You will see how to use while loop with an example

While Loop

You will learn use of For Loop

For Loop

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

For Each Loop

This loop has different working pattern

Do Until....Loop
Using Forms
3 Lectures 17:02

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

Designing a Form

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

Writing code for Forms

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

Enhancing Form
Tweak Macros
2 Lectures 05:01

You will learn how to improve your macros

Improving macros

Congratulations!! You have completed macro starter course.


2 questions
About the Instructor
4.6 Average rating
8 Reviews
109 Students
1 Course
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.

Report Abuse