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.
A simple example will show the Power of Macro how fast it can work.
Learn to record Excel event in VBA coding through Record Macro and define short cut key.
This is the first macro (VBA coding) to enter data in active worksheet.
How to insert a description in a macro .
Saving a macro file is different then a normal excel file. Learn how to save a macro enabled file.
Enable and disable macros in Excel.
Use of useful command in VBA in Input box. Lets see how can we make the macro inteactive with Input box.
Interact with user and make Macro dynamic while entering data in excel worksheet.
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.
Learn how to make any macro available in every excel workbook through Personal Macro workbook.
How to delete any macro which is personal and available in every workbook.
Perform some basic Excel calculation using VBA with range properties.
Perform some basic Excel calculation using VBA with Cells properties.
Perform some basic Excel calculation using VBA with variables.
Learn alternative ways to enter data in Excel with VBA coding
Transfer data from one worksheet to another worksheet automatically.
How to control the running macro on its way with Break Points and link one macro with another macro with Call command.
Some basic worksheet commands to select, rename, add, delete
How to copy data from one Excel sheet to another
How to manage the error with VBA commands.
Frequently used and Advance VBA command is offset. You will use in at various VBA coding.
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.
Run a macro when you open or close a workbook.
Use User Form to enter data in excel, do calculations and much more.
A simple example to understand the use of User Form.
Send data to another closed workbook with Excel VBA automatically.
Transferring the data to Another Workbook after Verification.
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.