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.
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.
325 students enrolled
$19
$25
24% off
Take This Course
  • Lectures 45
  • Length 4 hours
  • Skill Level Intermediate Level
  • 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 5/2015 English

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

What are the requirements?

  • You should have at least beginner level knowledge of Excel

What am I going to get from this course?

  • 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

What 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

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: Getting Started
Introduction to the Course Contents
Preview
03:15
Section 2: Introducing VBA and Record first Macro
05:04

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

06:23

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

07:21

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

03:39

Learn how to enter data in any specific worksheet.

02:19

How to insert a description in a macro .

01:30

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

01:29

Enable and disable macros in Excel.

08:09

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

07:18

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

05:28

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.

03:07

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

03:15

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

Section 3: Do some basic Calculations Using VBA
03:25

Perform some basic Excel calculation using VBA with range properties.

02:23

Perform some basic Excel calculation using VBA with Cells properties.

02:41

Perform some basic Excel calculation using VBA with variables.

Section 4: VBA Commands and Properties
03:15

Learn alternative ways to enter data in Excel with VBA coding

Work with Data Fonts with Cells Properties
01:52
05:50

Transfer data from one worksheet to another worksheet automatically.

05:48

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

07:16

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

07:52

How to copy data from one Excel sheet to another

05:52

How to manage the error with VBA commands.

Section 5: Use of Excel Formulas and Take some Practical Examples
07:26

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

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
Use Of Vbyesno On Msgbxo To Provide Flexibility
Preview
05:31
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
Section 6: Create Events in Macro to run Program Automatically
03:38

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.

04:10
Learn how to automatically adjust the column width when you add data in worksheet in Excel
02:45

Run a macro when you open or close a workbook.

Section 7: Managing Data through Userform
01:13

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

05:42

A simple example to understand the use of User Form.

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
Section 8: Case Study: Rearrange Data with Macro
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
Section 9: Transfer data from One Workbook or one worksheet to another Master workbook
11:08

Send data to another closed workbook with Excel VBA automatically.

12:09

Transferring the data to Another Workbook after Verification.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Manoj Kumar, 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.

Ready to start learning?
Take This Course