Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
3 Hour(s) 59 Minute(s)
Language
English
Taught by
Manoj Kumar
Certificate
- Available
- *The delivery and distribution of the certificate are subject to the policies and arrangements of the course provider.
Rating
Course Overview
Visual Basic for application (VBA) for Excel is to automate repetitive Task, Reduce work load & unlock real Excel Power.
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.
Course Content
- 9 section(s)
- 45 lecture(s)
- Section 1 Getting Started
- Section 2 Introducing VBA and Record first Macro
- Section 3 Do some basic Calculations Using VBA
- Section 4 VBA Commands and Properties
- Section 5 Use of Excel Formulas and Take some Practical Examples
- Section 6 Create Events in Macro to run Program Automatically
- Section 7 Managing Data through Userform
- Section 8 Case Study: Rearrange Data with Macro
- Section 9 Transfer data from One Workbook or one worksheet to another Master workbook
What You’ll 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
Skills covered in this course
Reviews
-
CCisca Gerber
I liked the course and it is very informative. The drawbacks are that the instructor is sometimes hard to understand and there are now source data for the lectures.
-
EEdward Francis Keating
It is very well explained
-
RRaymond Biharie
Goede begeleiding. Voor enkele oefeningen zou ik wel graag de gebruikte dataset willen hebben om alles te kunnen oefenen.
-
SSherwin Dennis T. Ruiz
Great course. well explained method
