Excel VBA Programming How to write Macros Like a Professional In Hindi

in Microsoft Excel

Best Seller

5.0

(2 Ratings)

24 Students enrolled

Created by A K

Hindi Intermediate

Last Updated

5 Dec 2022

What you'll learn

1. Learn how to create Excel VBA macros from scratch

2. Learn Email Automation and send bulk Emails with different attachments within seconds

Learn automation secrets from scratch in simple language with the practical projects like Consolidation of different worksheets in a workbook

You will get assignments with there solutions to test your VBA knowledge

Get certificate of completion

Jobs that require this skill:

1. Financial Analyst and Market research analysts
2. Data Analyst
3. Business Intelligence Analyst
4. Database Developer
5. Software Developer
6. Systems Analyst
7. Systems Integrator
8. Business Systems Analyst
9. Programmer Analyst
10. Research Analyst

Course content

53 Lessons • 3:53 Hr

Introduction & Scope of Visual Basic for Applications in Excel

4 Lessons • 0:13 Hr

Introduction of Visual Basic for Applications

0:01 Hr

Start with the Macro Recorder - Create your first Macro

0:05 Hr

Assigning the Macro to a button

0:04 Hr

Placing a Macro on the Quick Access Toolbar

0:02 Hr

Working with VBE, Range Objects, Range Properties

5 Lessons • 1:08 Hr

Understand about VBE Components -

0:06 Hr

Writing to cells using Activecell, Range, Cell & offset Property -

0:15 Hr

Range Properties & methods which you must know

0:24 Hr

Methods to find the Last row & Last Column of your range

0:15 Hr

Understand the Copy & Paste Method

0:07 Hr

Working with Workbook, Worksheets & Variables

2 Lessons • 0:12 Hr

Overview about Variables & use of Option Explicit

0:06 Hr

Learn about Referencing Worksheets & Workbooks

0:06 Hr

Looping through Collections – Part 1

4 Lessons • 0:31 Hr

With & End with Statement for easy execution of codes

0:06 Hr

Learn about For Next Loop

0:08 Hr

Apply V-lookup formula with For Next loop

0:09 Hr

For Each to Loop through collections

0:07 Hr

Looping through Collections – Part 2

2 Lessons • 0:28 Hr

IF Then (Else, Else IF) Constructs

0:21 Hr

Controlling Code execution – Goto Statements

0:07 Hr

Looping through Collections – Part 3

3 Lessons • 0:14 Hr

Select Case Constructs

0:07 Hr

Do Until Loop through collections

0:04 Hr

Do While loop through collections

0:02 Hr

Error Handling in VBA

2 Lessons • 0:08 Hr

Learn about different types of errors in VBA

0:03 Hr

Use of Error Handler

0:04 Hr

Understanding about Excel VBA Events

4 Lessons • 0:23 Hr

Introduction to Events

0:03 Hr

Learn about Open Event, Before Close Event

0:05 Hr

Learn about Change Event, SelectionChange Event

0:11 Hr

Learn about BeforeDoubleClick Event, BeforeRightClick Event

0:02 Hr

Assignments

7 Lessons •

Copy Paste Method

Do Until Loop

Do While Loop

For each Loop

Macro Recording

Select Case

Variables

Assignments Answers

7 Lessons •

Copy & Paste

Do Until Loop

Do While Loop

For each Loop

Macro Recording

Select Case

Variables

Bonus Lectures

2 Lessons • 0:31 Hr

Consolidation of different worksheets in one workbook

0:20 Hr

Final Email Automation

0:11 Hr

Excel Templates used in Recording

11 Lessons •

Do Until Loop through collections

Do While loop through collections

Introduction & Scope of Visual Basics for Applications in Excel

Looping through Collections_For Each loop

Select Case

Vlookup with For Next loop

With & End with Statement Template

Working with VBE_Range Objects_Range Properties

Working with Workbook, Worksheets & Variables

If then Else If Start

Goto Statement

7 more sections

Requirements

Excel Must be Installed

Course Is Recorded in Excel 2019.

Compatible with 2007, 2010, 2013, 2016

About this course

VBA (Visual Basic for Applications) is a programming language that is used within Microsoft Office applications. It is used to create macros and automate repetitive tasks. It can be used to automate tasks within Excel, Word, PowerPoint, Access, Outlook and other Office applications. VBA is a powerful tool that can make complex tasks easier and automate manual tasks. It can also be used to create custom forms and user interfaces to better interact with data within Office applications.

We’re in the News!

Featured Review

Arun Kumar

Fri, 9-Dec-2022

Good Course got to learn many things.

About the instructor

A K

EFA User

A K

EFA User

2 Reviews
24 Students
1 Courses

5.00

Hello Guys, We believe that learning is an integral part of someone's life and We always ensure that our students be on top in this competitive world this is the reason which makes us different.

With our video lectures you will learn VBA in very simple language, I am very excited to see you in the course.

Happy Coding!!!!!

53 Video Lessons

Get instant & lifetime access

This course contains pre-recorded videos that can be watched anytime

30 day money back

Don’t like it, no problems

If for any reason you are not happy with your purchase, simply email us within 30 days of purchase and we will refund you within 24 hours.

Celebrating

200000+

Happy Learners!

Student reviews

5.0

Course Rating

Content quality (5.0)

Instructor skills (5.0)

Purchase worth (5.0)

Support quality (5.0)

Wed, 4-Jan-2023 Puja thakur

This course was amazing. great teaching skills from the instructor. very well detailed. Don't doubt to buy this course! it will be very helpful.

Fri, 9-Dec-2022 Arun Kumar

Good Course got to learn many things.

Excel VBA Programming How to write Macros Like a Professional In Hindi

in Microsoft Excel

Best Seller

5.0

(2 Ratings)

24 Students enrolled

Created by A K

Hindi Intermediate

Last Updated

5 Dec 2022

₹399.00

₹2,999.00

Get Discount 86.70% off

7 Hours left for this price

₹399.00

₹2,999.00

30 Days money back guarantee

Gift this course

Send this course as a gift to your friends

This Course includes:

3:53 Hours On demand videos

53 Lessons

Full time access

Access on mobile, Tablet and tv

Course specifications

Capacity:

0 Students

Duration:

3:53 Hours

Files:

Excel VBA Programming How to write Macros Like a Professional In Hindi

What you'll learn

Get certificate of completion

Jobs that require this skill:

Course content

Requirements

About this course

We’re in the News!

Arun Kumar

About the instructor

A K

A K

53 Video Lessons

Get instant & lifetime access

30 day money back

Don’t like it, no problems

Celebrating

200000+

Happy Learners!

Student reviews

Excel VBA Programming How to write Macros Like a Professional In Hindi

Gift this course

Course specifications

Report course

Share

Buy with points