Excel VBA Tutorial in Hindi

Buy Excel VBA in Hindi [Pendrive]
INR 4000
Watch & Learn Excel VBA through videos on TV or Computer, Mobile Unprotected Pendrive
80+ MP4 videos (Hindi & English)
Total 300+ mins of videos tutorials
Free Courier
Free Training Files (For practice)
Free 16 GB Pen Drive
Buy Excel VBA in Hindi [Online Access]
INR 1499
Actual Price INR 4̶0̶0̶0̶ / Watch & Learn Excel through videos on TV or Computer, Mobile
80+ MP4 videos (Hindi & English)
Total 300+ mins of videos tutorials
Online Access
Free Training Files (For practice)
Lifetime Access

 Learn Excel VBA tutorial In Hindi

Apane Excel trainer dost ko jaanie:

  • Name: Mr. Rishabh Pugalia
  • Profession: Chartered Accountant
  • Has worked for KPMG (Audit), J.P. Morgan (Investment Banking & Research), Futures First (STIR F&O)
  • 4.0 years of work experience in the area of Audit, Investment Banking & Proprietary trading
    • Program Director & Training Instructor – Advanced Excel Course, Advanced PowerPoint, Financial Modeling, VBA Macros
    • 7.0 years of work experience in Corporate Training, eLearning Content Development
    • Under him, He has trained more than 12,000 professionals across 14+ cities
    • Successfully completed six-weeks Analyst training program of Adkins Matchett & Toy
    • Conducted CPE seminars for Chartered Accountants – Kolkata, Mumbai, Jodhpur

Jaanie, anya students ka kya kahana hai iss Excel Training course ke bare me:

 

Course Curriculum

001 – Why do we learn Excel VBA Macros?
001A – How to learn Excel VBA Macros?
002 – How to enable Developer Tab in Excel?
003 – Basics of Developer Tab in Excel
004 – Important Macro Security Settings in Excel
005 – How to save Macros in Excel for future use?
006 – Part 1 – How to create a Macros in Excel
007 – Part 2 – How to run a Macro in all open Workbooks
008 – Part 3 – Using a Button to run a Macros in Excel
009 – Part 4 – Running a Macro in different ways in Excel
010 – Part 5 – Understanding VBA Workspace in Excel (Basics)
011 – Part 6 – Watch a Macro being recorded
012 – Part 1 – Searching Google for VBA Codes – using the 3 magic words
013 – Part 2- Searching Google for VBA Codes – in Blogs vs Forum
014 – VBA Workspace – a detailed tour
015 – How to increase the font size of the VBA Codes
016 – 3 shortcuts to write VBA Codes faster
017 – VBA Code Testing Tricks
018 – Part 1 – Concept of Objects, Properties, Methods in Excel VBA
019 – Part 2 – Concept of Objects, Properties, Methods in Excel VBA
020 – Part 3 – Concept of Objects, Properties, Methods in Excel VBA
021 – Part 4 – Concept of Objects, Properties, Methods in Excel VBA
022 – Range & Cells Object in Excel VBA
023 – Example – Using Cells Object with a simple Do-While Loop in Excel VBA
024 – What is OFFSET property in Excel VBA
025 – Range Navigation in Excel VBA (Basics)
026 – Exercise – Finding Last filled Row & Next Row in Excel VBA
027 – Exercise – Finding Last Column No.
028 – Part 1 – Variables – Concept, How & Why declare Variables, Initialization
029 – Part 2 – Variables – Data Types
030 – Part 3 – Variables – Best Practices to name Variable
031 – Part 4 – Variables – How to remember to declare Variables (Option Explicit)
032 – Part 5 – Variables – DIM vs SET
033 – Pvt vs Public 01 
034 – Pvt vs Public 02
035 – Loops – For Next Loop – Basics
036 – Loops – If Then Else with For Next Loop
037 – Loops – For Each Next – Basics
038 – Loops – If Then Else with For Each Next Loop
039 – Loops – Do While Loop – Basics
040 – Loops – Do Until Loop – Basics
041 – Loops – With Statement
042 – Loops – Select Case – Basics
043 – Part 1 – Input Box – Basics
044 – Part 2 – Input Box – Inserting user input in a cell
045 – Part 3 – Input Box – Different Value Types
046 – Part 4 – Input Box with IF Then Else Statement
047 – Introduction
048 – MsgBox – 1
049 – MsgBox – 2
050 – MsgBox – 3
051 – MsgBox – 4
052 – User Forms – Project 1 – Part 1 – TextBox & CommandButton – Basics
053 – User Forms – Project 1 – Part 2 – TextBox & CommandButton – Designing
054 – User Forms – Project 1 – Part 3 – TextBox & CommandButton – Configuring
055 – User Forms – Project 1 – Part 4 – TextBox & CommandButton – Load button
056 – User Forms – Project 2 – Part 1 – Option Button & CommandButton – Basics
057 – User Forms – Project 2 – Part 2 – Option Button & CommandButton – Configuring
058 – User Forms – Project 3 – Part 1 – Option Button in Multiple Clusters (3 ways)
059 – User Forms – Project 3 – Part 2 – Option Button in Multiple Clusters (3 ways)
060 – Multi Page – Introduction
061 – Multi Page – 1
062 – Multi Page – 2
063 – Multi Page – 3
064 – Check Box 001
065 – Combo Box – Method 1
066 – Combo Box – Method 2
067 – User Defined Functions (UDF) – Basics
068 – UDF Example 1 – Score Result with IF END IF
069 – UDF Example 2 – CellComments
070 – UDF Samples – Series A
071 – UDF Samples – Series B
072 – Form Controls vs ActiveX Controls
073 – MouseMove Event w. Appln Statusbar
074 – Introduction
075 – Events – Workbook_Open and Worksheet_Activate
076 – Exercise 1 – Tracking Workbook Opens
077 – Exercise 2 – Tracking Workbook Save
078 – Event – Worksheet_BeforeDoubleClick
079 – Event – Worksheet_Change
080 – Event – Worksheet_Calculate
081 – Pivot Table – Refresh – WorkSheetActivate
082 – Speed up the code running – 1
083 – Speed up the code running – 2
084 – Speed up the code running – 3