Excel VBA MACRO KickStart Course for absolute beginner
4.6 (9 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.
117 students enrolled
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 (9 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.
117 students enrolled
Created by Rajesh Mhatre
Last updated 10/2015
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • Basic Knowledge of any MS-Excel (2013, 2010, 2007 or 2003)
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.

Who is the target audience?
  • Anyone who is willing to learn macros
Students Who Viewed This Course Also Viewed
Curriculum For This Course
31 Lectures
02:21:16
+
Overview
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

1-1
3 questions
+
Excel VBA Overview
2 Lectures 08:09

You will learn VBA object model

VBA Object Model
02:50

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

VBA Editor and tools
05:19

2.1
5 questions
+
Introduction to Macros
3 Lectures 06:00

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

Excel File types
02:09

You will learn different types of macro security

Macro Security
03:51

You will get overview of macro recording in this lecture

Macro Recording Tips
5 pages

3.1
4 questions
+
Jump into Macros
6 Lectures 12:15

You will learn how to run existing macros

Running Macros
00:59

You will learn how to record macros

Recording macros
02:26

You will learn how to delete a macro

Deleting a Macro
3 pages

You will learn types of macro recordings

Macros recording types
03:09

You will learn different ways to trigger your macros

Trigger your macros
03:13

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

Excel Events
02:28

4.1
5 questions
+
Basic VBA Programming
4 Lectures 14:03

You will write your first VBA program

First VBA Program
02:18

You will first time interact with variables in your program.

Using Variables
02:48

You will learn different types of variables

Variable Types
03:57

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

Variable Declaration
05:00
+
Using conditions
4 Lectures 29:35
IF Condition
09:20

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

IF ... Else...
08:17

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

Types of IF Statements
06:24

Another Type of Condition

Select Case
05:34
+
Loops
5 Lectures 30:47

You will get introduction of loop and its components.

Simple Loop
06:08

You will see how to use while loop with an example

While Loop
08:23

You will learn use of For Loop

For Loop
09:39

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

For Each Loop
03:51

This loop has different working pattern

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

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

Designing a Form
06:46

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

Writing code for Forms
06:14

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

Enhancing Form
04:02
+
Tweak Macros
2 Lectures 05:01

You will learn how to improve your macros

Improving macros
04:07

Congratulations!! You have completed macro starter course.

Conclusion
00:54

5.1
2 questions
About the Instructor
Rajesh Mhatre
4.6 Average rating
9 Reviews
117 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.