Visual Basic of Applications: Become Excel VBA Programmer
3.8 (15 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.
348 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Visual Basic of Applications: Become Excel VBA Programmer to your Wishlist.

Add to Wishlist

Visual Basic of Applications: Become Excel VBA Programmer

Visual Basic for application (VBA) for Excel is to automate repetitive Task, Reduce work load & unlock real Excel Power.
3.8 (15 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.
348 students enrolled
Created by Manoj Kumar
Last updated 6/2016
English
Curiosity Sale
Current price: $10 Original price: $25 Discount: 60% off
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Over 35 Lectures and 3 Hours of Video Content
  • Learn to Record, Write and Dubug Basic and Semi Adv. Macro
  • Learn the use of Inputbox, Do....Loop, Do while and Do Until, For.....Next
  • Writing Personal Macro, Worksheet and Workbook Events, VB Protection
  • Userforms, Define short cut key, Defined Functions, Error handing, break points
  • Learn the best way to use Range, Cells and Offset to access the cells
View Curriculum
Requirements
  • You should have at least beginner level knowledge of Excel
Description

In this course, Learn how to unlock the power of Microsoft's VBA programming language to build effective and powerful programs.

You will first learn how to record a Basic macro, how to define Short cut key, how to debug and run macros. Once you are comfortable with VBA environment, we will cover most frequently used commands like Do while, For Next, Input box, Userform, Workbook and worksheet Events. At last we shall take many practical long problems to advance your knowledge on VBA.

The best way to learn Macro is to learn it with case studies. With case studies, you develop your creativity. You will learn multiple ways to write a program with different coding.

Once you learn VBA, the task that you do in several hours, you will be able to complete that in just few seconds. You will be able to perform even that task which is not possible with Only Excel.

Who is the target audience?
  • One who want to make full use of Excel and solve problems which is beyond the Excel.
  • Anyone who wants to learn how to write VBA in a professoinal environment
  • Anyone who wants to add weight to resume and value to their current or potential employer
Students Who Viewed This Course Also Viewed
Curriculum For This Course
45 Lectures
04:00:00
+
Getting Started
1 Lecture 03:15
+
Introducing VBA and Record first Macro
12 Lectures 55:02

A simple example will show the Power of Macro how fast it can work.

Introducing Macro
05:04

Learn to record Excel event in VBA coding through Record Macro and define short cut key.

Record Your First Macro
06:23

This is the first macro (VBA coding) to enter data in active worksheet.

Preview 07:21

Learn how to enter data in any specific worksheet.

Preview 03:39

How to insert a description in a macro .

Insert Coment to a Macro
02:19

Saving a macro file is different then a normal excel file. Learn how to save a macro enabled file.

Saving An Macro Enabled File
01:30

Enable and disable macros in Excel.

Dealing With Macro Security
01:29

Use of useful command in VBA in Input box. Lets see how can we make the macro inteactive with Input box.

Use Of Input Box And Formula Comand
08:09

Interact with user and make Macro dynamic while entering data in excel worksheet.

Use Of Inputbox, Msgbox, Formula In Different Way
07:18

Make a button in Excel sheet and link it to a particular Macro, so that you can run it by clicking on that Button only.

Preview 05:28

Learn how to make any macro available in every excel workbook through Personal Macro workbook.

Personal Macro Workbook
03:07

How to delete any macro which is personal and available in every workbook.

How to delete a Personal macro and Personal Macro Workbook
03:15
+
Do some basic Calculations Using VBA
3 Lectures 08:29

Perform some basic Excel calculation using VBA with range properties.

Perform Calculations with Range Properties
03:25

Perform some basic Excel calculation using VBA with Cells properties.

Perform Calculations with Cells Properties
02:23

Perform some basic Excel calculation using VBA with variables.

Perform Calculations with Variables
02:41
+
VBA Commands and Properties
7 Lectures 37:45

Learn alternative ways to enter data in Excel with VBA coding

Multiple ways to Enter Date in Excell with Cell, Range and Variable
03:15

Work with Data Fonts with Cells Properties
01:52

Transfer data from one worksheet to another worksheet automatically.

Preview 05:50

How to control the running macro on its way with Break Points and link one macro with another macro with Call command.

Break Points And Call Command
05:48

Some basic worksheet commands to select, rename, add, delete

Worksheet Related Commands: Select, Add, Rename And Delete Worksheet
07:16

How to copy data from one Excel sheet to another

Copy Data To Sheet3 With Variables
07:52

How to manage the error with VBA commands.

How To Handle The Error1
05:52
+
Use of Excel Formulas and Take some Practical Examples
9 Lectures 01:09:26

Frequently used and Advance VBA command is offset. You will use in at various VBA coding.

Use offset to put values
07:26

Assign Result Based On Marks Using If, Offset And For----next Command
06:46

Assign Grades Based On Marks Using If, Offset And For----next Command
05:35

Select Case an Alternative to IF Function in VBA
08:57

Use Of Do While And Do Until............loop
07:12

Use Of Formula Command With For.........Next
05:41


A combined Use Of Do While & For Next to enter details in Excel
13:23

Define a Fucntion which is not Pre-Defined in Excel
08:55
+
Create Events in Macro to run Program Automatically
3 Lectures 10:33

Events are powerful properties in VBA. They trigger macro when any specific event occurs. Learn how to trigger a macro automatically when you activate or deactivate a worksheet in Excel.

Preview 03:38

Learn how to automatically adjust the column width when you add data in worksheet in Excel
Autofit Column Width with Change Event
04:10

Run a macro when you open or close a workbook.

Workbook Opening & Closing Events
02:45
+
Managing Data through Userform
5 Lectures 15:45

Use User Form to enter data in excel, do calculations and much more.

Understand First Basic Userform
01:13

A simple example to understand the use of User Form.

Basic Example On How To Create Userform
05:42

Basic Example On How To Create Userform Continued
03:20

Use Of Userform Without Defining Variables
01:43

Use of Combobox to Provide Defined List
03:47
+
Case Study: Rearrange Data with Macro
3 Lectures 16:28
Reconding Macro with Use Of Relative References
02:47

Transpose The Data With Do While..............Loop
09:15

Transpose The Data With Do While Loop Continued
04:26
+
Transfer data from One Workbook or one worksheet to another Master workbook
2 Lectures 23:17

Send data to another closed workbook with Excel VBA automatically.

Transfer data to Another WB Automatically with VBA
11:08

Transferring the data to Another Workbook after Verification.

Transfer data to Another WB based on criterias with VBA
12:09
About the Instructor
Manoj Kumar
3.8 Average rating
65 Reviews
2,188 Students
4 Courses
Expert Level Training for Finance Professionals

I am Manoj Kumar. I am an MBA (Finance) from ICFAI and CFA level 3 candidate from CFA Institute, USA. I am running Investment Banking Institute, New Delhi. I teach Adv Excel, VBA, Dashboards, Financial Modeling, Valuations & M&A. I have been into consulting in Project Finance before moving to training.

Areas of Training: Excel, VBA,Dashboard Designing,Financial Modeling, Valuation & M&A —Have trained in WNS, Global Energy, Intec Capital, Creative Web Mobi, ICOFP, GNIM etc —Conducted more than 150 open workshops and trained more than 2500 participants —Developed Video based Training courses on Various SubectsMy passion for training led me to start the IB Institute in New Delhi, India. I have two years of rich experience in the fields of Investment Banking, Corporate Valuation, Equity Research and Consulting for Project appraisal.

I have conducted more then 150 workshops for various colleges and corporate houses. I am Certified Excel Specialist and Trainer from Microsoft.