Excel VBA MACRO KickStart Course for absolute beginner

A perfect MS-Excel VBA (macros ) starter course from industry experienced programmer
4.8 (10 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.
97 students enrolled
$19
$50
62% off
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

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

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

What 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.

Curriculum

Section 1: Overview
05:46

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

04:38

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

1-1
3 questions
Section 2: Excel VBA Overview
02:50

You will learn VBA object model

05:19

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

2.1
5 questions
Section 3: Introduction to Macros
02:09

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

03:51

You will learn different types of macro security

5 pages

You will get overview of macro recording in this lecture

3.1
4 questions
Section 4: Jump into Macros
00:59

You will learn how to run existing macros

02:26

You will learn how to record macros

3 pages

You will learn how to delete a macro

03:09

You will learn types of macro recordings

03:13

You will learn different ways to trigger your macros

02:28

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

4.1
5 questions
Section 5: Basic VBA Programming
02:18

You will write your first VBA program

02:48

You will first time interact with variables in your program.

03:57

You will learn different types of variables

05:00

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

Section 6: Using conditions
IF Condition
09:20
08:17

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

06:24

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

05:34

Another Type of Condition

Section 7: Loops
06:08

You will get introduction of loop and its components.

08:23

You will see how to use while loop with an example

09:39

You will learn use of For Loop

03:51

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

02:46

This loop has different working pattern

Section 8: Using Forms
06:46

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

06:14

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

04:02

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

Section 9: Tweak Macros
04:07

You will learn how to improve your macros

00:54

Congratulations!! You have completed macro starter course.

5.1
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