5.00(5)

Master Excel VBA and Excel Macros

  • Course level: All Levels

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

62 Lessons05h 59m 44s

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

5.00 (47 ratings)

6 Courses

3890 students

Student Feedback

5.0

Total 5 Ratings

5
5 ratings
4
0 rating
3
0 rating
2
0 rating
1
0 rating

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.

429.00

Material Includes

  • 6 Hours of Training Videos
  • 62 Video Lectures
  • Practice File

Requirements

  • Computer with MS Office Installed
  • Knowledge of MS Excel