Excel VBA Mastery Course
About Course
What Will I Learn?
- 100 + Video Tutorials
- 100 + Practice Files
- Course Test
- Course Completion ISO Certificate
Topics for this course
VBA Introduction
VBA Basic (8 Videos)
4 – VBA – Dynamic Copy Code of VBA00:13:22
5 – VBA – Offset Command00:09:48
6 – VBA – Project on Copy paste00:17:16
7 – VBA – Input box and Message box00:07:56
8 – VBA – Variable Types00:17:15
9 – VBA – Option Explicit00:06:46
VBA – IF Condition (5 videos)
10 – VBA – IF Condition00:06:27
11 – VBA IF Condition with And00:09:44
12 – VBA – IF Condition with OR00:06:49
13 – VBA – Nested IF Condition00:10:16
14 – VBA Project on IF00:26:06
Loops in VBA (4 videos)
15 – VBA – For Next Loop00:22:10
16 – VBA – For Loop Decrement Method00:06:44
17 – VBA – Do While Loop00:12:07
18 – VBA – Do Until Loop00:05:11
Projects with using Loops (8 videos)
19 – VBA – For Loop Project Remove Blank Rows00:18:04
20 – VBA – For Loop Project Add Alternate Blank rows00:22:02
21 – VBA – For Loop Project Insert Number of rows and Columns00:10:08
22 – VBA – Error Handler00:09:52
23 – VBA – Do While Loop with Nested if Project00:17:08
24 – VBA – For Loop with Nested if Project00:06:51
25 – VBA – Merge Sheets using For Loop00:19:40
26 – VBA – Create Index Using for Loop00:16:14
Message box and Input box in VBA (3 videos)
27 – VBA – Type of Msg Box00:07:50
28 – VBA – Use of Yes, No Type MsgBox00:18:20
29 – VBA – Select Range Using Input box00:06:38
Project On Sheets (5 videos)
30 – VBA – For Each Loop00:13:24
31 – VBA – Method of Adding worksheets00:11:16
32 – VBA – Insert N Number of Sheets00:05:47
33 – VBA – Method of Deleting Sheets00:05:32
34 – VBA Using For Loop Delete Multiple Sheets00:08:34
Object And Class (1 video)
35 – VBA – What is Object and Class00:08:00
Collection Loops (4 videos)
36 – VBA – Collection of Loop00:05:34
37 – VBA – Delete Blank Sheets For Each Loop00:14:16
38 – VBA – Collection Loop For Each Cell00:09:09
39 – VBA – Collection Loop Interview Question00:09:32
Workbook command and its Projects (9 videos)
40 – VBA – Workbook Commands00:19:13
41 – VBA – Workbook Protection Command00:06:40
42 – VBA – List of Worksheets from workbook00:08:26
43 – VBA – Open All Workbook From Specific Folder00:10:57
44 – VBA – Find Workbook00:17:52
45 – VBA – Deleting Unwanted Workbook00:14:46
46 – VBA – Protect All Sheets Using Loop00:07:34
47 – VBA – Protect Unprotect Set Custom Password00:04:33
48 – VBA – Collection Loop For Workbook00:12:43
Nested Loop (2 videos)
49 – VBA – Nested Loop00:15:48
50 – VBA – Nested Loop Assignment00:13:01
Array in VBA (14 videos)
51 – VBA – Array Introduction00:10:14
52 – VBA – Array in Loop00:10:37
53 – VBA – List of Arrays00:07:33
54 – VBA – List of Arrays00:19:10
55 – VBA – Comparing 3 List using Arrays00:13:42
56 – VBA – Start Point of Arrays00:04:39
57 – VBA – Dynamic Array00:12:09
58 – VBA – Array Project Rename Sheets00:24:28
59 – VBA – Project Find and Delete Using Array00:28:16
60 – VBA – Lbound and UBound in Array00:06:14
61 – VBA – Array from Range00:06:41
62 – VBA – Two Dimensional Array00:10:06
63 – VBA – Dynamic Two Dimensional Array00:06:37
64 – VBA Project on Array with VLOOKUP Function00:23:02
Functions In VBA (18 videos)
65 – VBA-Text Functions in VBA00:19:23
66 – VBA – Find and Left Practical Use00:15:31
67 – VBA – Find with Right and Mid Practical Use00:21:12
68 – VBA – INSTR and Replace Function00:21:19
69 – VBA – String comparison00:16:44
70 – VBA – Change Case Functions00:13:33
71 – VBA – IsNumeric Function Practical use00:24:37
72 – VBA – SUMIF Function00:12:06
73 – VBA – SUMIFS Function00:15:34
74 – VBA – COUNTIF and COUNTIFS Function00:17:59
75 – VBA – Vlookup Function00:15:58
76 – VBA – Match Function00:11:13
77 – VBA – Autorun Vlookup Event00:10:50
78 – VBA – Date Functions00:23:51
79 – VBA – DateDiff and DatePart Function00:10:42
80 – VBA – Project on DateDiff Function00:11:13
81 – VBA – All Date and Time Functions00:16:50
82 – VBA – CASE Function00:08:52
User Defined Function In VBA (8 videos)
1 – VBA – Introduction of UDF00:21:40
2 – VBA – Create Get Text Function00:21:21
3 – VBA – Create Get Numbers Function00:08:18
4 – VBA – Project on Separate Names00:33:02
5 – VBA – M Vlookup for Multiple Values00:19:53
6 – VBA – Combine Function Extract Text and Numbers00:12:21
7 – VBA – Reverse Lookup00:14:35
8 – VBA – Reverse Lookup Using Index Code00:23:20
User Form In VBA (12 videos)
1 – VBA – Userform Introduction00:21:44
2 – VBA – Userform Label and Text Box Properties00:11:21
3 – VBA – Userform use of Command Button00:08:38
4 – VBA – Submit Data to Excel using userform00:16:18
5 – VBA – Userform Events and Text Box Events00:30:05
6 – VBA – Userform Use of ComboBox00:08:55
7 – VBA – Userform Listbox00:11:11
8 – VBA – Userform CheckBox00:14:30
9 – VBA – Userform use of Option Button00:14:43
10 – VBA – Adding Image in Userform-100:16:31
11 -VBA – Adding Image in Userform-200:08:40
12 – VBA – Adding Image in Userform-300:26:20
Next Video Coming Soon Life time update Chapter
Excel To Outlook (5 Videos)
1 – VBA Outlook – Configure with gmail00:10:29
2 – VBA Outlook – Sending Email through Outlook00:07:50
3 – VBA – Outlook Email with Attachment00:12:33
4 – VBA – Outlook Send Bulk Email00:10:44
5 – VBA – Outlook Send Bulk Email with attachments00:03:27
Next lesson Coming soon Lifetime update chapter
Web Scraping In VBA (6 Videos)
1 – VBA – Web Scraping Introduction00:12:36
2 – VBA – Web Scraping Loop until Ready state00:07:13
3 – VBA – Web Scraping Get data from Website00:16:50
4 – VBA – Web Scraping Get data from Website 200:12:27
5 – VBA – Web Scraping Get All Links00:21:46
6 – VBA – Web Scraping Get Exact Data from Website00:29:36
VBA Events (3 Video) *New Chapter*
1 – VBA – Change Events00:18:26
2 – VBA – Events Auto filter Using Macro00:19:56
3 – VBA – Basic Events00:13:02
Project In VBA (3 Projects)
1 – Create Add-ins – Add picture in Comment Box00:45:53
2 – VBA Projects – Get Grace Marks Amazing Project00:38:24
3 – VBA Projects – Get Links of All Excel Files From any Folder00:31:00
VBA Assignments with Video Answers (4 Videos)
1 – VBA – Assignment – For Loop and if assignment00:29:36
2 – VBA – OMR Sheets Assignment00:26:44
3 – VBA – Interview Question – UDF of Reverse Text00:12:18
4 – VBA Project – Lock Data once you type00:36:00
VBA Interview Questions
1 – VBA – Interview Questions00:15:27
VBA Final Exam
Excel VBA Trial Paper
Final Exam for Certificate
About the instructors
39 Courses
59611 students
Student Ratings & Reviews
5.0
Total 26 Ratings
Dattatreya Dave
1 week ago
Excellent Satish Sirji, Your Teaching style with Hindi language is awesome. You have tried to cover subject thoroughly. This is really a helpful course to all who knows at least MS EXCEL in nutshell. I have no words to appreciate your Guru. ji Job in Computer universe. Thanks & god bless......
KULDEEP SINGH
2 months ago
Dear sir
Apne jo ye VBA ki suruwaat ki hai yha ek bahoot hi Nek kaam kiya hai hum sb K liye
Kyunki Aapka jo teaching style hai bahoot Achaa hai Mujko aapki Sikhane ka tarika Achaa Lagta hai Ab Bas SQL Ka intzaar rehegaa mere sabhi friend aap se hi learning kr Rey hai Sabko ab SQL ke series ka wait hai sir kb laaoge ???
Raju Sasmal
5 months ago
Sir, thank you for great VBA course.
Kuljeet VERMA
5 months ago
सर आपका कोर्स बहुत अच्छा है ! सर मुझे एक फाइल बनवानी हैं उसके लिए मुझे मदद नहीं मिल रही कृपया मदद करे
Best Course. explained each and every concept in detail. teaching style of sir is excellent
Pravesh Babu
5 months ago
Sir apka courses good hain standards hain jitni bhi tarif ki Jaye utni hi km hain sir ab hm Microsoft office me ab to 100 percentage Master bn ke hi rhenge main sir up manipuri se hu
gajendrasinghrajput3483
6 months ago
Thank You sir ji
For All Explain Action in Detail
Great App
Great Advance Master Course
Shibli Anwar
6 months ago
The course was absolutely fantastic. Every nook and corner of the topic was explained throughly and there were live projects and interview questions which really helped me to clear the concepts. Thanks a lot Satish Sir!!
Chaitanya Karmarkar
6 months ago
Thanks Satish sir this course is very helpful.
Amazing
Only Problem is app is little bit slow & Download options not available kindly provide download button like you tube for the offline watching. Otherwise all is good
Yogita Patil
6 months ago
Hello Sir,
Apka sikhane ka tarika bahot achha he. So please interview questions or answer ka vedio banao..
Vinod Kumar Yadav
7 months ago
Aaj se mai jaa raha hu VBA shikhna ka shuruvat karne
Thanka satish sir
Respected Satish Dhawale Sir, thanks you so much for this VBA Course. you explain in very details and mind blowing way. I learn Everyday VBA and update myself. I am belong to low-class family and i can't afford vba fees but when you updated vba course so I saw I can learn and I develop my future and increase my salary. so I thanks you thousand time and Satish sir update vba new video with your team. you're very helpful us and that's people who can afford high fees, helpless student whose can't afford fees due to family situation.
Praveen Kumar
7 months ago
Sir {Python, c++ , java language }courses bhi laiye n please
SUNITA THORAT
8 months ago
excellent explanation each & every point. very helpful
Happy Verma
8 months ago
Learn well and Earn well....
Nice meeting and we are a family together.
Thanks a lot.
Vishal Tukaram Kamble
8 months ago
Vba शिकण्याची माझी खूप इच्छा होती आणि तुम्ही पूर्ण केली खूप खूप धन्यवाद सर एवढा चांगला कोर्स दिल्याबद्दल
kamlesh kumar
9 months ago
thanks you so much sir
Abhishek Pandey
10 months ago
A huge Salute to you Satish Ji. You are genius, hats off to all your efforts. Great Tutor and Mentor!!
ANIL CHOUDHARY
10 months ago
Thanks You sir For this Course..
KARAN SINGH CHANDEL
10 months ago
Dear Sir
I was waiting for such a course for a long time and thank you for providing the course at such a reasonable price
And Keep doing similar courses in the future also.
Pritish Patil
10 months ago
The Best vba excel online course ever.
very well explained...
early reply from learn more....if there is a problem that are released by the phone immediately
DILIP RAYSING
10 months ago
Good sir your explanation are so simple and understanding
Pankaj Pathak
10 months ago
Dear Satish Sir
I am big fan of you and ajay sir.
I am also waiting for your VBA course ..
Thanks a lot...
Aapke samjhane ka andaz nirala hai...
Thanks once again
Pankaj pathak
Jitendra Doshi
10 months ago
Respected sir, is course ka mai besabrise intzar kar raha tha, aaj jaise aapne launch kiya maine enrolled kiya aur pehle 5 video dekhe aur bas aapne aap ko review dene se rok nahi paya, sir you deserve 5 out 5, bahot mehant liyi hai aapne course me, persentation ke sath vba ko explain karne ka tarika mujhe pasand aaya. pehle bahut video maine dekhe par vba bheje me hi nahi jata tha par ab sab kuch samj raha hai, dil se shukriya sir mujhe ye office ke liye bahut jaruri tha.
Requirements
- Microsoft Excel Knowledge
Enrolment validity: Lifetime
Login
Material Includes
- Variable in VBA
- If and nested in VBA
- For Loop in VBA
- Do While Loop
- Classes and Objects
- Collection Loops
- Type of Message Box
- Array in VBA
- Functions in VBA
- UDF in VBA
- User forms in VBA
- Web Scraping in VBA
- Excel To Outlook Connection
Target Audience
- VBA Course
- Learn VBA
- College Student
- Online Classes
- programming
- VBA Programming
- Excel advance course
- VBA Excel
- VBA Uppercase
- VBA Function list