Master Excel VBA and Excel Macros
Description
MS Excel is the integral part of MIS profession and one of the most useful Application for reporting and analysis. However to be successful in in this field only having the knowledge of MS Excel is not sufficient, the aspirant has to be well versed with Excel VBA as well. You may get to know about VBA at the time of learning and working with Macro itself. Macro recording enable the user to create a function it often requires. While the user records macros the Excel do a VBA programming for you. You may work on very advance level projects if you have got the knowledge of VBA. Our course curriculum has been considered as one of the most advance one. Moreover it enables the user to do what can be one in Excel itself but thousand times faster.
What Will I Learn?
- Learn how to automate daily routine tasks within Excel
- Learn best practices when creating macros
- Learn to use the Macro Recorder effectively
- Learn how to write custom VBA Macros to create more robust automation
- Reduce manual routine tasks to the click of a button
- Create simple solutions to complex problems by levering Excel functionality with Macros
- Learn to create interactive Userform
- Learn to make customized functions through VBA
Topics for this course
Macro Recording
Macro Recording Example 100:15:17
Macro Recording Example 200:05:20
Macro Recording Example 300:03:10
Types of ways to run macros00:05:59
Getting Started with Excel VBA – Macro
Handling Range/Cell in Macro
Handling Worksheets in Macro
Handling Workbooks in Macro
Working with Declared Variable
IF and Select Case in VBA
Working with Loop in Macro
Events Handling in Macro
Functions in Macro
Handling Outlook and Pivot Table in Macro
Userform through Macro
File System Object (FSO) in VBA
Late Binding in Macro
About the instructor
6 Courses
3883 students
Delighted when seeing codes I entered working. Great to have the course saved so can re-run sections to improve memory & speed of using formulas & procedures. Thank You.
Very helpful
The lectures are very interesting and make me eager to listen. The lectures are with real-time examples so I am able to understand better. this course deserve a full 5 stars and no regret on enrolling it.
First I have done excel from here only after that I have completed Macros. Yes I am satisfied.
I am well versed with excel and looking for vba training only. The course has served the purpose very well. Full marks to the trainer.