Excel VBA Mastery Program

Learn Excel VBA in Hindi

This Course includes:

  • 6 hours of Pre-recorded Hindi & English video
  • 80+ HD Videos
  • Excel VBA Mastery eBook
  • Practice files
  • Certificate of completion
  • Get 1-Year Access
  • No Refund
Enroll Now
LEARN MORE

Who this course is for:

Every professional who:
  • has been using Excel for more than two years
  • has felt left out at the workplace that is surrounded by coders
  • wishes to begin to see the results of partial automation of reporting on their career

What will you learn?

  • It’s simple - you begin to hate the subject, that you don’t understand.
  • My job is to make you love Excel VBA Macros, EVEN if you are not a Coder or a Programmer.
  • Check out the course content section to get a full list of topics.

Course Narrator

Rishabh Pugalia

Worked with KPMG, and became a Chartered Accountant
Traded Interest Rate Futures, and then worked with J.P. Morgan (Fixed Income)

We’ve helped over 7,800 learners overcome their learning “plateau”...

Don’t take my word for it – check out this feedback from some of the professionals representing virtually every business domain, background and experience level…

See our 310+ reviews on Trustpilot

Course Curriculum

Learn Excel VBA in Hindi

01
Introduction
2 Lessons
Why do we learn Excel VBA Macros?
How to learn Excel VBA Macros?
02
Basic Settings
4 Lessons
How to enable Developer Tab in Excel?
Basics of Developer Tab in Excel
Important Macro Security Settings in Excel
How to save Macros in Excel for future use?
03
Record & Run Macros
6 Lessons
How to create a Macros in Excel
How to run a Macro in all open Workbooks
Using a Button to run a Macros in Excel
Running a Macro in different ways in Excel
Understanding VBA Workspace in Excel (Basics)
Watch a Macro being recorded
04
Google Readymade VBA Codes
2 Lessons
Searching Google for VBA Codes - using the 3 magic words
Searching Google for VBA Codes - in Blogs vs Forum
05
Know Your Workspace
4 Lessons
VBA Workspace - a detailed tour
How to increase the font size of the VBA Codes
3 shortcuts to write VBA Codes faster
VBA Code Testing Tricks
06
Objects, Properties, Methods
4 Lessons
Concept of Objects, Properties, Methods in Excel VBA - Part 1
Concept of Objects, Properties, Methods in Excel VBA - Part 2
Concept of Objects, Properties, Methods in Excel VBA - Part 3
Concept of Objects, Properties, Methods in Excel VBA - Part 4
07
Range & Cells Object
3 Lessons
Range and Cells Object in Excel VBA
Example - Using Cells Object with a simple Do-While Loop
What is OFFSET property in Excel VBA
08
Range Navigation
3 Lessons
Range Navigation in Excel VBA (Basics)
Exercise - Finding Last filled Row and Next Row in Excel VBA
Exercise - Finding Last Column No. (English)
09
Variable Declaration
7 Lessons
Variables - Concept, How and Why declare Variables, Initialization
Variables - Data Types
Variables - Best Practices to name Variable
Variables - How to remember to declare Variables (Option Explicit)
Variables - DIM vs SET
Pvt vs Public - Part 1 (English)
Pvt vs Public - Part 2 (English)
10
Loops
8 Lessons
Loops - For Next Loop - Basics
Loops - If Then Else with For Next Loop
Loops - For Each Next - Basics
Loops - If Then Else with For Each Next Loop
Loops - Do While Loop - Basics
Loops - Do Until Loop - Basics
Loops - With Statement
Loops - Select Case - Basics
11
Input Box & Message Box
9 Lessons
Input Box - Basics
Input Box - Inserting user input in a cell
Input Box - Different Value Types
Input Box with IF Then Else Statement
MsgBox Introduction (English)
MsgBox - Part 1 (English)
MsgBox - Part 2 (English)
MsgBox - Part 3 (English)
MsgBox - Part 4 (English)
12
User Forms
15 Lessons
Project 1: Text Box and Command Button - Basics
Project 1: Text Box and Command Button - Designing
Project 1: Text Box and Command Button - Configuring
Project 1: Text Box and Command Button - Load button
Project 2: Option Button and Command Button - Basics
Project 2: Option Button and Command Button - Configuring
Project 3: Option Button in Multiple Clusters (3 ways) - Part 1
Project 3: Option Button in Multiple Clusters (3 ways) - Part 2
Multi Page - Introduction (English)
Multi Page - Part 1 (English)
Multi Page - Part 2 (English)
Multi Page - Part 3 (English)
Check Box - Part 1 (English)
Combo Box - Method 1 (English)
Combo Box - Method 2 (English)
13
User Defined Functions (UDF)
5 Lessons
Basics of User Defind Functions (UDF)
UDF Example 1 – Score Result with IF END IF (English)
UDF Example 2 – Cell Comments (English)
UDF Samples – Series A (English)
UDF Samples – Series B (English)
14
ActiveX Controls
2 Lessons
Form Controls vs ActiveX Controls (English)
MouseMove Event w. Appln Statusbar (English)
15
Events
8 Lessons
Introduction of Events (English)
Events – Workbook_Open and Worksheet_Activate (English)
Exercise 1 – Tracking Workbook Opens (English)
Exercise 2 – Tracking Workbook Save (English)
Event – Worksheet_BeforeDoubleClick (English)
Event – Worksheet_Change (English)
Event – Worksheet_Calculate
Pivot Table – Refresh – WorkSheetActivate (English)
16
Excel VBA Projects
2 Lessons
Excel VBA for Non-Coders Project 1
F&R Text CHR

1 Year Access

₹ 1999 365 Days
  • 6 hours of Pre-recorded Hindi & English video
  • 80+ HD Videos
  • Excel VBA Mastery eBook
  • Practice files
  • Certificate of completion
  • No Refund
ENROLL NOW
Get started now!
"I am an accountant at CA Firm. And I was faced lot of problems daily in calculations and interpretations the data. Now I do my all excel work easily. When first time i was saw the YouTube video of you (Excel superstar), I realized that you are amazing teacher sir and no one is comparable with you. And your style and the way of teaching the concepts is very unique and pure. You don't have any illogical reasons but your all reasons are fully logical behind the every excel formula. I feel proud of myself that I have teacher like you and I am student of you sir."
Jitanshu Masih
Student

Frequently Asked Questions (FAQs)

No, and I must explain why. The platform on which we host our video courses charges us an annual fee. That’s why the lifetime access option has been replaced with affordable 1-year access.

This course isn’t a copy-paste video course made by some 25-year-old ‘influencer’. We share lecture by lecture details of what’s inside this course. Check our YouTube videos, and see what people wrote in the comment section.

This course has been created by a Chartered Accountant who has worked with KPMG & J.P. Morgan. He has 16 years of experience and has taken 1000s of official in-house sessions at 70+ companies.

We do not have LIVE sessions.

There is no refund policy. There are a lot of sample videos on my YouTube channel. You can check them before buying the course.

No, but you can watch them online unlimited times during your course access period.

Once you complete our 6+ hours course, you will get a course completion certificate. There are no additional charges for that.

If you wish to get a certificate from Microsoft, then you can explore its various certification examinations. E.g., Microsoft Office Specialist – Exam 77-420: Microsoft Excel 2013. Please note that they charge separate exam fees.

Link – https://docs.microsoft.com/en-us/learn/certifications/mos-excel-2013/