Skill Course By Satish Dhawale

Menu
Login
  • Home
  • Courses
  • Excel VBA Programming Course

Excel VBA Programming Course

Learn Excel VBA from scratch with Satish sir, and Automate Complex Tasks with Microsoft Excel VBA & Excel Macros with Real-job Projects.
4.9 Rating
★★★★★ 5/5
  • 2806 Students Enrolled
  • Created By Satish Dhawale
  • In Hindi
  • 125 Lessons

₹999

₹3299

76% off

Enroll Now
Play Video

Course Description

VBA Macros use the Visual Basic Application in Excel to create custom user-generated functions and speed up manual tasks by creating automated processes. Completing VBA (Visual Basic for Applications) training opens the door to jobs with titles like Analyst, Business Analyst, or Data Analyst.

In this course you will learn Excel VBA Programming from Beginners to Advance. (Courses by Satish Dhawale Sir) सभी कोर्सेस आसान हिंदी भाषा में | Read More पे क्लिक करे और कोर्स के फीचर्स जानने के लिए |

Course Features
✅सभी कोर्सेस सरल हिंदी भाषा में
✅Excel VBA Programming बेसिक से एडवांस कोर्सेस
✅125 DETAIL वीडियोस
✅ कोर्स प्रैक्टिस फाइल्स उपलब्ध
✅कोर्स कम्पलीशन सर्टिफिकेट
✅इंस्टेंट एक्सेस –
⬇️ Download Video in APP

Free BONUSES-
✅ PDF शॉर्टकट्स

This course is Created by : Satish Dhawale
सतीश सर को कंप्यूटर के क्षेत्र में टीचिंग का लगभग 16 साल का अनुभव हैं जिसमे उन्होंने 14 साल तक ऑफलाइन कंप्यूटर संस्थान में 40000+ से अधिक स्टूडेंट्स को और अपने Online अपने Learn More Channel के माध्यम से लगभग 17,00,000+ से ज्यादा स्टूडेंट्स को कंप्युटर कि शिक्षा देने का कार्य किया हैं। YouTube : 7 Silver and 1 Gold Button Award Winner for their 7 YouTube Channels

Course Benefits

  • Understand VBA and Macro
  • Variables & Data Types in VBA
  • Important Features of VBA
  • Working with IF, AND, OR, NestedIF
  • Loops and Nested loop in VBA
  • Real Job Project for loops
  • Error Handling in VBA
  • Message and Input Box in VBA
  • Working with worksheets in VBA
  • Understand Object and Class

Materials Included

  • 125 Video tutorial
  • 30 Hours on demand lectures
  • Real Job Problem scenario
  • Downloadable Practice file available
  • Course completion ISO certificate
  • WhatsApp and Call Support

Course Curriculum

VBA : Module - 1

Preview

Play Video

01 - Introduction

Preview

Play Video

02 - What is Variable and Data Type

Preview

Play Video

03 -Sheets and Cell Selection

04 -Dynamic Copy Code of VBA 13.22 Min
05 – Offset Command 9.48 Min

VBA Basic and IF Condition : Module - 2

01 -Project on Copy paste 17.16 Min
02 -Inputbox and Messagebox 7.56 Min
03 – Variable Types 17.15 Min
04 – Option Explicit 06:46 Min
05 – IF Condition 06:27 Min
06 – IF Condition with And 09:44 Min
07 – IF Condition with OR 06:49 Min
08 – NestedIF Condition 10:16 Min
09 – Project on IF 26:06 Min

Loops in VBA : Module - 3

01 – VBA For Next Loop 22:10 Min
02 – For Loop Decrement Method 06:44 Min
03- Do While Loop 12:07 Min
04 – Do Until Loop 05:11 Min

Project With Using Loops : Module - 4

01 – For Loop Project Remove Blank Rows 18:04 Min
02 – For Loop Project Add Alternate Blank rows 22:02 Min
03 -For Loop Project Insert Number of rows and Columns 10:08 Min
04 -Error Handler 09:52 Min
05 – Do While Loop with Nested if Project 17:08 Min
06 – For Loop with Nested if Project 06:51 Min
07 – Merge Sheets using For Loop 19:40 Min
08 – Create Index Using for Loop 16:14 Min

Message Box and Input Box In VBA : Module - 5

01 – Type of MsgBox 07:50 Min
02 – Use of Yes, No Type MsgBox 18:20 Min
03 – Select Range Using Input box 06:38 Min

Project On Sheets : Module - 6

01 – For Each Loop 13:24 Min
02 – Method of Adding worksheets 11:16 Min
03 – Insert N Number of Sheets 05:47 Min
04 – Method of Deleting Sheets 05:32 Min
05- Using For Loop Delete Multiple Sheets 08:34 Min

Object And Class : Module - 7

01 – What is Object and Class 08:00 Min

Collection Loops : Module - 8

01 – Collection of Loop 05:34 Min
02 – Delete Blank Sheets For Each Loop 14:16 Min
03 – Collection Loop For Each Cell 09:09 Min
04 – Collection Loop Interview Question 09:32 Min

Workbook Command And its Projects : Module - 9

01- Workbook Commands 19:13 Min
02 -Workbook Protection Command 06:40 Min
03 – List of Worksheets from workbook 08:26 Min
04 – Open All Workbook From Specific Folder 10:57 Min
05 – Find Workbook 17:52 Min
06 – Deleting Unwanted Workbook 14:46 Min
07 – Protect All Sheets Using Loop 07:34 Min
08- Protect UnProtect Set Custom Password 04:33 Min
09 – Collection Loop For Workbook 12:43 Min

Nested Loop : Module - 10

01 – Nested Loop 15:48 Min
02 – Nested Loop Assignment 13:01 Min

Array In VBA : Module - 11

01 – Array Introduction 10:14 Min
02 – Array in Loop 10:37 Min
03 – List of Arrays 07:33 Min
04 – List of Arrays 19:10 Min
05- Compairing 3 List using Arrays 13:42 Min
06 – Start Point of Arrays 04:39 Min
07 – Dynamic Array 12:09 Min
08 – Array Project Rename Sheets 24:28 Min
09 -Project Find and Delete Using Array 28:16 Min
10 – Lbound and UBound in Array 06:14 Min
11 – Array from Range 06:41 Min
12 – Two Dimensional Array 10:06 Min
13 – Dynamic Two Dimensional Array 06:37 Min
14- Project on Array with Vlookup Function 23:02 Min

Function In VBA : Module - 12

01 – Text Functions in VBA 19:23 Min
02 – Find and Left Practical Use 15:31 Min
03 – Find with Right and Mid Practical Use 21:12 Min
04 – INSTR and Replace Function 21:19 Min
05 – String comparison 16:44 Min
06 – Change Case Functions 13:33 Min
07 – IsNumeric Function Practical use 24:37 Min
08 – SUMIF Function 12:06 Min
09 – SUMIFS Function 12:06 Min
10 – COUNTIF and COUNTIFS Function 17:59 Min
11 – Vlookup Function 15:58 Min
12 – Match Function 11:13 Min
13 – Autorun Vlookup Event 10:50 Min
14 – Date Functions 23:51 Min
15 – DateDiff and DatePart Function 10:42 Min
16 – Project on DateDiff Function 11:13 Min
17 – All Date and Time Functions 16:50 Min
18 – CASE Function 08:52 Min

User Defined Function In VBA : Module - 13

01 – Introduction of UDF 21:40 Min
02 – Create GetText Function 21:21 Min
03 – Create Get Numbers Function 08:18 Min
04 – Project on Separate Names :33:02 Min
05 – M Vlookup for Multiple Values 19:53 Min
06 – Combine Function Extract Text and Numbers 12:21 Min
07 – Reverse Lookup 14:35 Min
08 – Reverse Lookup Using Index Code 23:20 Min

User Form In VBA : Module - 14

01 – Userform Introduction 21:44 Min
02 – Userform Label and Text Box Properties 11:21 Min
03 – Userform use of Command Button 08:38 Min
04 – Submit Data to Excel using userform 16:18 Min
05 – Userform Events and Text Box Events 30:05 Min
06 – Userform Use of ComboBox 08:55 Min
07 – Userform Listbox 11:11 Min
08 – Userform CheckBox 14:30 Min
09 – Userform use of Option Button 14:43 Min
10 – Adding Image in Userform-1 16:31 Min
11 – Adding Image in Userform – 2 08:40 Min
12 – Adding Image in Userform-3 26:20 Min

Excel To Outlook : Module - 15

1 – Outlook – Configure with gmail 10:29 Min
2 – Outlook – Sending Email through Outlook 07:50 Min
3 – Outlook Email with Attachment 12:33 Min
4 – Outlook Send Bulk Email 10:44 Min
5 – Outlook Send Bulk Email with attachments 03:27 Min

Web Scrapping In VBA : Module - 16

01 – Web Scraping Introduction 12:36 Min
02 – Web Scraping Loop until Ready state 07:13 Min
03 – Web Scraping Get data from Website 16:50 Min
04 – Web Scraping Get data from Website 2 12:27 Min
05 – Web Scraping Get All Links 21:46 Min
06 – Web Scraping Get Exact Data from Website 29:36 Min

VBA Events : Module - 17

01 – Change Events 18:26 Min
02 – Events Autofilter Using Macro 19:56 Min
03 – Basic Events 13:02 Min

Project In VBA : Module - 18

01 – Create Add-ins – Add picture in Comment Box 45:53 Min
02 – Projects – Get Grace Marks Amazing Project 38:24 Min
03 – Projects – Get Links of All Excel Files From any Folder 31:00 Min
04 – Project – to Count Cells of Conditional Formatting (New Video) 22:24 Min

VBA Assignment With Video Answer : Module - 19

01 – Assignment – For Loop and if assignment 29:36 Min
02 – OMR Sheets Assignment 26:44 Min
03 – Interview Question UDF of Reverse Text 12:18 Min
04 – Project Lock Data once you type 36:00 Min

VBA Interview Questions : Module - 20

01 – Interview Questions 15:27 Min

Course Instructor

Satish Dhawale

Founder & CEO of CoursePe

Satish Dhawale has over 15 years of experience in the field of computer education, he has been promoting computer education through his blog www.learnmoreindia.in and YouTube channel Learn More with 1.5 M+ subscribers for more than 5 years now. 1 Gold Play and 5 Silver Play Awards have been awarded by YouTube. Learn More YouTube channel provides tutorials related to computer and technology in the Hindi language to Learn and improve your life. 

Course Completion Certificate

₹999

₹3299

76% off

Enroll Now

Course Rating By Summary

5.0
Rated 5.0 out of 5
5.0 out of 5 stars (based on 11 reviews)
Excellent100%
Very good0%
Average0%
Poor0%
Terrible0%

Submit Your Feedback

​

vba

Rated 5.0 out of 5
November 23, 2023

it is amazing .very helpful and easy to understand. how can i purchase it i am from pakistan

syed aftab rehman

Toiqrar ansari

Rated 5.0 out of 5
February 9, 2023

It’s Amazing Course Sir

Toiqrar ansari
Verified

Arjun Bain

Rated 5.0 out of 5
February 9, 2023

Maybe New MS Access VBA Course Will Come

Arjun Bain
Verified

VAIBHAV PATIL

Rated 5.0 out of 5
February 9, 2023

Very nicely explained all concepts. I am waiting for more videos on File system objects and user forms ( project’s)

VAIBHAV PATIL
Verified

Shibli Anwar

Rated 5.0 out of 5
February 9, 2023

The course was absolutely fantastic. Every nook and corner of the topic was explained thoroughly and there were live projects and interview questions which really helped me to clear the concepts. Thanks a lot Satish Sir!!

Shibli Anwar
Verified

Jitendra Doshi

Rated 5.0 out of 5
February 9, 2023

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, presentation 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.

Jitendra Doshi
Verified

Pritish Patil

Rated 5.0 out of 5
February 9, 2023

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

Pritish Patil
Verified

Sanish Kushwaha

Rated 5.0 out of 5
February 9, 2023

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.

Sanish Kushwaha
Verified

Moinuddin Saifi

Rated 5.0 out of 5
February 9, 2023

Very good ????

Moinuddin Saifi
Verified

REWATI MISHRA

Rated 5.0 out of 5
February 9, 2023

sir thanks for this module, this is very helpful, my all doubt has cleared in this module. the explanation towards lastrow and total value is very awesome, you have clearly taught here.

REWATI MISHRA
Verified

Send your doubt

“Please note: You will receive a reply from our team on your email ID within 24 to 48 hours.”