Learn Excel VBA in Hindi
Instructor: CA Rishabh Pugalia
Language: Hindi & English
Enrolled Learners: 174
Validity Period: 365 days
Validity Period: 730 days
Download Course Curriculum of Excel VBA Mastery Program
This Course includes:
Confused if this program is right for you? Whatsapp us on +917021329219
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.
Why is this course different? What separates this course from the rest?
The most difficult thing when learning a new topic is to START.
Being a non-coder, it’s even more difficult to start learning VBA Macros. There are many questions such as:
Given the lack of clarity, learners like you start with the WRONG sequence of learning. At the end of the weekend, all you learn is the “Hello World” message box. Result: You get discouraged. You give up, before even starting.
Excel VBA Macros are best learned by NOT following the textbook approach. The first hour of learning is the most crucial. It’s a make-or-break hour. In this course, we start with –
(a) Examples of why we need VBA Macros,
(b) How can you get started with minimal coding and see results
(c) Then, gradually, we move towards the essential theory, which is explained in a day to day language.
You cannot learn everything about VBA Macros from the videos. BUT you should learn how to search for your answers, as you progress in your journey.
Who this course is for:
Every professional who:
Is it lifetime access?
No, and I must explain why. The platform on which we host our video courses charges us an annual fee. To maintain the best viewing experience, we have also subscribed to VIMEO for video hosting.
Plus, we keep adding monthly updates to the course, without any additional charges to the existing subscribers. That’s why the lifetime access option has been replaced with affordable 1-year and 2-year access.
Isn't this course too expensive?
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.
Will there be LIVE sessions?
We do not have LIVE sessions.
Is there a refund policy?
There is no refund policy. There are a lot of sample videos on my YouTube channel. You can check them before buying the course.
Can I download the videos?
No, but you can watch them online unlimited times during your course access period.
Will I get a certificate?
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/
Is your course inclusive of GST?
Yes, the fees you pay include GST. The GST portion of the fee is paid to the Government.
|Excel VBA Mastery Program Tracker||Preview|
|Section 01 - Introduction|
|Why do we learn Excel VBA Macros?||Preview|
|How to learn Excel VBA Macros?||Preview|
|Section 02 - Basic Settings|
|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?|
|Section 03 - Record & Run Macros|
|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|
|Section 04 - Google Readymade VBA Codes|
|Searching Google for VBA Codes - using the 3 magic words|
|Searching Google for VBA Codes - in Blogs vs Forum|
|Section 05 - Know Your Workspace|
|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|
|Section 06 - Objects, Properties, Methods|
|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|
|Section 07 - Range & Cells Object|
|Range and Cells Object in Excel VBA|
|Example - Using Cells Object with a simple Do-While Loop|
|What is OFFSET property in Excel VBA|
|Section 08 - Range Navigation|
|Range Navigation in Excel VBA (Basics)|
|Exercise - Finding Last filled Row and Next Row in Excel VBA|
|Exercise - Finding Last Column No. (English)|
|Section 09 - Variable Declaration|
|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)|
|Section 10 - Loops|
|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|
|Section 11 - Input Box & Message Box|
|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)|
|Section 12 - User Forms|
|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)|
|Section 13 - User Defined Functions (UDF)|
|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)|
|Section 14 - ActiveX Controls|
|Form Controls vs ActiveX Controls (English)|
|MouseMove Event w. Appln Statusbar (English)|
|Section 15 - Events|
|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)|
|Section 16 - Excel VBA Projects|
|Excel VBA for Non-Coders Project 1 18:00|
|F&R Text CHR|
After a successful purchase, this item would be added to your courses.
You can access your courses in the following ways :