Excel VBA Mastery Course

About Course

इस कोर्स में आप एक्सेल VBA ऑटोमेशन कम्पलीट सिख पावोगे, मैंने लगबग सभी TOPIC को इस एक्सेल VBA कोर्स में ऐड करने की कोशिश कियी है, इस कोर्स में क्या, क्या कंटेंट है इसकी आईडिया आपको कंटेंट देखकर आ जाएगी पर फिर भी मैं आपको बताना चाहूंगा इस कोर्स तैयार करने के लिए मैंने ६० दिन खर्च किये है और इस कोर्स में बहोत सरे टाइम सेविंग प्रोजेक्ट कैसे बनाते है ये स्टेप बाय स्टेप गाइड किया है, उसे देखकर आप वैसे खुद के जरुरत के अनुसार प्रोजेक्ट बना सकते हो या फिर जो दिए है उस प्रोजेक्ट में बदलाव कर सकते हो , अगर आप प्रोग्रामिंग बैकग्राउंड से नहीं हो तो चिंता करने की जरुरत नहीं है क्यूंकि प्रोग्रामिंग कॉन्सेप्ट भी मैंने डिटेल में बताये है |

This course creates and Provided on the PCskill app by Satish Dhawale with the collaboration of PCSkill Founder: Abhimanyu Sir, for any query related to the course you can contact us on this Whatsapp number: +91 8591597259 we will be happy to help you

Note: First 3 Videos are unlocked to check quality of teaching & All practice files can be download at once download link is available in Part no 4,5,6 check below the video (Download all Practice file Button)

Course Content

VBA Introduction

1 – VBA – Introduction

24:28

VBA Basic (8 Videos)

VBA – IF Condition (5 Videos)

Loops in VBA (4 Videos)

Projects with using Loops (8 Videos)

Message box and Input box in VBA (3 Videos)

Project On Sheets (5 Videos)

Object And Class (1 Video)

Collection Loops (4 Videos)

Workbook command and its Projects (9 Videos)

40 – VBA – Workbook Commands

19:13
41 – VBA – Workbook Protection Command

06:41
42 – VBA – List of Worksheets from workbook

08:26
43 – VBA – Open All Workbook From Specific Folder

10:57
44 – VBA – Find Workbook

17:52
45 – VBA – Deleting Unwanted Workbook

14:46
46 – VBA – Protect All Sheets Using Loop

07:34
47 – VBA – Protect Unprotect Set Custom Password

04:33
48 – VBA – Collection Loop For Workbook

12:43

Nested Loop (2 Videos)

Array in VBA (15 Videos)

51 – VBA – Array Introduction

10:14
52 – VBA – Array in Loop

10:37
53 – VBA – List of Arrays

07:33
54 – VBA – List of Arrays

19:10
55 – VBA – Comparing 3 List using Arrays

13:42
56 – VBA – Start Point of Arrays

04:39
57 – VBA – Dynamic Array

12:09
58 – VBA – Array Project Rename Sheets

24:28
59 – VBA – Project Find and Delete Using Array

28:16
60 – VBA – Lbound and UBound in Array

06:14
61 – VBA – Array from Range

06:41
62 – VBA – Two Dimensional Array

10:06
63 – VBA – Dynamic Two Dimensional Array

06:37
64 – VBA Project on Array with VLOOKUP Function

23:02

Functions In VBA (17 Videos)

65 – VBA-Text Functions in VBA

19:23
66 – VBA – Find and Left Practical Use

15:31
67 – VBA – Find with Right and Mid Practical Use

21:12
68 – VBA – INSTR and Replace Function

21:19
69 – VBA – String comparison

16:44
70 – VBA – Change Case Functions

13:33
71 – VBA – IsNumeric Function Practical use

24:37
72 – VBA – SUMIF Function

12:06
73 – VBA – SUMIFS Function

15:34
74 – VBA – COUNTIF and COUNTIFS Function

17:59
75 – VBA – Vlookup Function

15:58
76 – VBA – Match Function

11:13
77 – VBA – Autorun Vlookup Event

10:50
78 – VBA – Date Functions

23:51
79 – VBA – DateDiff and DatePart Function

10:43
80 – VBA – Project on DateDiff Function

11:13
81 – VBA – All Date and Time Functions

16:50
82 – VBA – CASE Function

08:52

User Defined Function In VBA (8 Videos)

Userforms In VBA (12 Videos)

1 – VBA – Userform Introduction

21:44
2 – VBA – Userform Label and Text Box Properties

11:21
3 – VBA – Userform use of Command Button

08:38
4 – VBA – Submit Data to Excel using userform

16:19
5 – VBA – Userform Events and Text Box Events

30:05
6 – VBA – Userform Use of ComboBox

08:55
7 – VBA – Userform Listbox

11:11
8 – VBA – Userform CheckBox

14:30
9 – VBA – Userform use of Option Button

14:43
10 – VBA – Adding Image in Userform-1

16:31
11 -VBA – Adding Image in Userform-2

08:40
12 – VBA – Adding Image in Userform-3

26:20
Next Video coming soon lifetime update chapter

00:00

Excel To Outlook (5 Videos)
Send Email using VBA Code from Excel to outlook, Send bulk emails, Send email with attachments and lot more

Web Scraping In VBA (6 Videos)

VBA Events (3 Video) New Chapter

Project In VBA

VBA Assignments with Video Answers

VBA Interview Questions

VBA Final Exam

Student Ratings & Reviews

5.0

Total 3 Ratings

3 Ratings

0 Rating

Aditya Bhargava

3 years ago

Excellent explanations with practical solutions. Loved learning

Balaji Ranvirkar

3 years ago

Thanks a lot sir

GEETA SINGH

3 years ago

best course

PCskill

About Course

What Will You Learn?

Course Content

VBA Introduction

1 – VBA – Introduction

VBA Basic (8 Videos)

2 – VBA – What is Variable and Data Type

3 – VBA – Sheets and Cell Selection

4 – VBA – Dynamic Copy Code of VBA

5 – VBA – Offset Command

6 – VBA – Project on Copy paste

7 – VBA – Input box and Message box

8 – VBA – Variable Types

9 – VBA – Option Explicit

VBA – IF Condition (5 Videos)

10 – VBA – IF Condition

11 – VBA IF Condition with And

12 – VBA – IF Condition with OR

13 – VBA – Nested IF Condition

14 – VBA Project on IF

Loops in VBA (4 Videos)

15 – VBA – For Next Loop

16 – VBA – For Loop Decrement Method

17 – VBA – Do While Loop

18 – VBA – Do Until Loop

Projects with using Loops (8 Videos)

19 – VBA – For Loop Project Remove Blank Rows

20 – VBA – For Loop Project Add Alternate Blank rows

21 – VBA – For Loop Project Insert Number of rows and Columns

22 – VBA – Error Handler

23 – VBA – Do While Loop with Nested if Project

24 – VBA – For Loop with Nested if Project

25 – VBA – Merge Sheets using For Loop

26 – VBA – Create Index Using for Loop

Message box and Input box in VBA (3 Videos)

27 – VBA – Type of Msg Box

28 – VBA – Use of Yes, No Type MsgBox

29 – VBA – Select Range Using Input box

Project On Sheets (5 Videos)

30 – VBA – For Each Loop

31 – VBA – Method of Adding worksheets

32 – VBA – Insert N Number of Sheets

33 – VBA – Method of Deleting Sheets

34 – VBA Using For Loop Delete Multiple Sheets

Object And Class (1 Video)

35 – VBA – What is Object and Class

Collection Loops (4 Videos)

36 – VBA – Collection of Loop

37 – VBA – Delete Blank Sheets For Each Loop

38 – VBA – Collection Loop For Each Cell

39 – VBA – Collection Loop Interview Question

Workbook command and its Projects (9 Videos)

40 – VBA – Workbook Commands

41 – VBA – Workbook Protection Command

42 – VBA – List of Worksheets from workbook

43 – VBA – Open All Workbook From Specific Folder

44 – VBA – Find Workbook

45 – VBA – Deleting Unwanted Workbook

46 – VBA – Protect All Sheets Using Loop

47 – VBA – Protect Unprotect Set Custom Password

48 – VBA – Collection Loop For Workbook

Nested Loop (2 Videos)

49 – VBA – Nested Loop

50 – VBA – Nested Loop Assignment

Array in VBA (15 Videos)

51 – VBA – Array Introduction

52 – VBA – Array in Loop

53 – VBA – List of Arrays

54 – VBA – List of Arrays

55 – VBA – Comparing 3 List using Arrays

56 – VBA – Start Point of Arrays

57 – VBA – Dynamic Array

58 – VBA – Array Project Rename Sheets

59 – VBA – Project Find and Delete Using Array

60 – VBA – Lbound and UBound in Array

61 – VBA – Array from Range

62 – VBA – Two Dimensional Array

63 – VBA – Dynamic Two Dimensional Array

64 – VBA Project on Array with VLOOKUP Function

Excel To Outlook (5 Videos)
Send Email using VBA Code from Excel to outlook, Send bulk emails, Send email with attachments and lot more

VBA Events (3 Video) New Chapter