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

₹799

₹3299

76% off

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

01 - Introduction

Preview

02 - What is Variable and Data Type

Preview

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

₹799

₹3299

76% off

Course Rating By Summary

5.0

5.0 out of 5 stars (based on 10 reviews)

Excellent100%

Very good0%

Average0%

Poor0%

Terrible0%

Submit Your Feedback

Toiqrar ansari

February 9, 2023

It’s Amazing Course Sir

Toiqrar ansari

Arjun Bain

February 9, 2023

Maybe New MS Access VBA Course Will Come

Arjun Bain

VAIBHAV PATIL

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

Shibli Anwar

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

Jitendra Doshi

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

Pritish Patil

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

Sanish Kushwaha

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

Moinuddin Saifi

February 9, 2023

Very good ????

Moinuddin Saifi

REWATI MISHRA

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

Kishanpreet Singh

February 9, 2023

Best Teacher

Kishanpreet Singh