5.00(5)

Master Excel VBA and Excel Macros

by himanshu
Course level: All Levels
Share:

Categories Office Productivity
Duration 05h 59m 44s
Total Enrolled 423

Description

MS Excel is the integral part of MIS profession and one of the most useful Application for reporting and analysis. However to be successful in in this field only having the knowledge of MS Excel is not sufficient, the aspirant has to be well versed with Excel VBA as well. You may get to know about VBA at the time of learning and working with Macro itself. Macro recording enable the user to create a function it often requires. While the user records macros the Excel do a VBA programming for you. You may work on very advance level projects if you have got the knowledge of VBA. Our course curriculum has been considered as one of the most advance one. Moreover it enables the user to do what can be one in Excel itself but thousand times faster.

What Will I Learn?

Learn how to automate daily routine tasks within Excel
Learn best practices when creating macros
Learn to use the Macro Recorder effectively
Learn how to write custom VBA Macros to create more robust automation
Reduce manual routine tasks to the click of a button
Create simple solutions to complex problems by levering Excel functionality with Macros
Learn to create interactive Userform
Learn to make customized functions through VBA

Topics for this course

62 Lessons05h 59m 44s

Macro Recording

Macro Recording Example 100:15:17

Macro Recording Example 200:05:20

Macro Recording Example 300:03:10

Types of ways to run macros00:05:59

Getting Started with Excel VBA – Macro

Handling Range/Cell in Macro

Handling Worksheets in Macro

Handling Workbooks in Macro

Working with Declared Variable

IF and Select Case in VBA

Working with Loop in Macro

Understanding Loop00:05:39

Loop Practical Example00:05:02

Loop Related Task Solution00:04:14

Do While Loop00:02:13

For Loopcounter Loop00:06:29

For Loopcounter Step Importance00:03:50

For Loopcounter Step Example 200:06:34

For Each Loop00:04:46

For Each more Example00:04:15

For Each Task Solution00:02:41

Loop Related Project00:01:38

Project Solution and further Task00:06:23

Loop Related Major Project00:09:25

Events Handling in Macro

Functions in Macro

Handling Outlook and Pivot Table in Macro

Userform through Macro

File System Object (FSO) in VBA

Late Binding in Macro

About the instructor

himanshu

5.00 (45 ratings)

6 Courses

3883 students

Student Feedback

5.0

Total 5 Ratings

5 ratings

0 rating

virendra yadav

5 days ago

Delighted when seeing codes I entered working. Great to have the course saved so can re-run sections to improve memory & speed of using formulas & procedures. Thank You.

rahul yadav

5 days ago

Very helpful

Anand pal

5 days ago

The lectures are very interesting and make me eager to listen. The lectures are with real-time examples so I am able to understand better. this course deserve a full 5 stars and no regret on enrolling it.

Sunil kumar

6 days ago

First I have done excel from here only after that I have completed Macros. Yes I am satisfied.

Pintu singh

6 days ago

I am well versed with excel and looking for vba training only. The course has served the purpose very well. Full marks to the trainer.

~~₹1,499.00~~ ₹129.00

Material Includes

6 Hours of Training Videos
62 Video Lectures
Practice File

Requirements

Computer with MS Office Installed
Knowledge of MS Excel

Master Excel VBA and Excel Macros

Description

What Will I Learn?

Topics for this course

Macro Recording

Macro Recording Example 100:15:17

Macro Recording Example 200:05:20

Macro Recording Example 300:03:10

Types of ways to run macros00:05:59

Getting Started with Excel VBA – Macro

Introduction To Excel VBA – Macro00:08:57

Start Macro Programming00:07:06

Macro Task Basic00:04:05

Handling Range/Cell in Macro

Methods to Refer Range00:06:55

Selection of Multiple Cell00:05:56

Formatting through VBA00:07:18

End Command In VBA00:06:15

Offset In VBA00:04:49

Task on Data Entry Automate00:02:14

Solution For The Task00:05:11

Handling Worksheets in Macro

Methods to Refer to Sheets00:08:31

Methods Related to Sheets00:10:05

Sheet Related Task00:01:52

Sheet Related Task Solution00:03:48

Handling Workbooks in Macro

Methods to Refer to Workbooks00:02:50

Methods Related to Workbook00:03:20

Workbook Related Project00:10:35

Working with Declared Variable

Understanding Declared Variable00:10:02

Data Types in Variable00:06:16

Object Variable Related Task00:02:16

Object Variable Task Solution00:03:43

Variable related Major Project00:07:42

IF and Select Case in VBA

Apply IF in VBA00:05:22

AND OR in VBA00:08:13

Task for IF00:01:28

Solution of IF Task00:03:03

Working with Select Case00:03:50

Select Case 2nd Scenario00:04:50

Select Case 3rd Scenario00:08:38

Working with Loop in Macro

Understanding Loop00:05:39

Loop Practical Example00:05:02

Loop Related Task Solution00:04:14

Do While Loop00:02:13

For Loopcounter Loop00:06:29

For Loopcounter Step Importance00:03:50

For Loopcounter Step Example 200:06:34

For Each Loop00:04:46

For Each more Example00:04:15

For Each Task Solution00:02:41

Loop Related Project00:01:38

Project Solution and further Task00:06:23

Loop Related Major Project00:09:25

Events Handling in Macro

How To Create Events00:09:25

Events Example and Project00:03:04

Event Project Solution00:02:37

Sheet Specific Events00:03:18

Functions in Macro

Create Function in VBA00:06:49

Function Related Project00:01:33

Function Related Project Solution00:01:42

Create Optional Parameter In Function00:04:15

Handling Outlook and Pivot Table in Macro

VBA To Control Outlook For Mail00:09:24

Outlook Related Project00:05:13

Create Pivot Table with VBA00:09:03

Userform through Macro

Create Userform00:18:41

File System Object (FSO) in VBA

File System Object -Handling File and Folders00:05:46

Handling File In FSO00:03:03

FSO Practical Example00:07:00

Late Binding in Macro

Late Binding Technique in Macro00:04:49