Excel VBA Macro Expert

Course Overview

In this course, we'll delve into the more intricate aspects of VBA programming to elevate your Excel automation skills. This course goes beyond the basics to explore class modules, collections, and dictionaries, providing you with the tools to create sophisticated, reusable code and manage complex data structures efficiently. You'll gain expertise in designing custom classes, handling multiple data types, and implementing advanced programming concepts to build robust, scalable solutions. With hands-on projects and real-world examples, you'll learn to harness VBA’s full potential, enabling you to tackle complex automation tasks and streamline your workflows with precision and flexibility.

Rating :

4.6

Reviews :28

Students :47

Available In :English | Hindi

Updated On :September, 2024

Trainer :Sagar Thorat

Fee :

10,000

Find A Batch

Key Features

Zero to Hero
Learn with fun
Hands-on learning
Real-world projects
Easy to follow lessons
Comprehensive Curriculum
Certificate of Excellence
Live online sessions

Who should join?

Experienced VBA Users: If you already have a good understanding of VBA and want to elevate your skills, this course will help you leverage class modules, collections, and dictionaries to create more sophisticated and reusable code

Pre-requisites

Curious to Learn

Willingness to Practice

Good understanding of VBA

Course content

IMPORTANT: Currently we are re-desiging all our courses and latest syllabus will be available as soon as it is ready.

1.What Is D-Approach In Programming?
- Developer As User
- Developer As Hidden User
- Developer As Developer
- What Approach Should A Developer Follow While Creating A Program
2.Working With Names
- Creating Names To Store And Use Important Data
- Creating Hidden Names
- Creating Names To Store Array
- Advantages & Dis-Advantages Of Using Name
3.Working With Registry
- Using Registry To Store And Retrieve Data
- Advantages & Dis-Advantages Of Using Registry
4.Working With Collection
- Using Collection To Store Multiple Values
- Working With Key In Collection
- Using Collection To Get Unique Data
- Using Collection To Get Unique Data Based On Multiple Headers
- Using Multiple Key Combination In Dictionary
- Advantages & Dis-Advantages Of Using Collection
5.Working With Dictionary
- Using Dictionary To Store Multiple Values
- Working With Key In Dictionary
- Using Dictionary To Get Unique Data
- Using Dictionary To Get Unique Data Based On Multiple Headers
- Using Multiple Key Combination In Dictionary
- Advantages & Dis-Advantages Of Using Dictionary
6.Difference Between Collection And Dictionary
- Benefits Of Collection Over Dictionary
- Benefits Of Dictionary Over Collection
7.Creating & Working With Custom Classes
- Creating Enumerable Classes
- Creating Object Class
- Creating Collection Classes
- Creating Custom Class Properties
- Creating Custom Class Events
- Creating Custom Class Methods
- Advantages And Dis-Advantages Of Using Custom Classes
- Using Custom Classes For Robust Programming
- Creating Reusable Custom Classes
- Using Custom Classes Across Multiple Projects
- Using Custom Classes For Faster Programming
- Using Custom Classes For Reducing Programming
- Using Custom Classes For Error Handling
8.Working With File System Object
- Using FSO To Create Text File
- Using FSO To Import Data From Text File
- Using FSO To Create Zip Files
- Using FSO To Loop In All Directories Within Directories
9.What Is Recursion?
- When Should We Use Recursion?
- Creating Recursion Methods
10.Binding
- What is Binding?
- What Are Types Of Binding? (Early Binding And Later Binding)
- Advantages And Dis-Advantages Of Using Early Binding
- Advantages And Dis-Advantages Of Using Late Binding
11.Working With Web Applications
- Connection To Internet Using VBA
- Inserting Data On Website
- Fetching Data From Website
- Fetching Stock Data
- Login To Google
- Working With Various Website
- Using ID, Tag, Class, Position To Get Element
12.Dynamic Add-Ins
- Creating Dynamic Add-Ins
- Benefits Of Using Dynamic Add-Ins
13.Types Of Classes
- P-Class
- PBNC-Class
- GMU-Class
- MU-Class
14.Working With VB6
- What Is DLL (Dynamic Link Library)?
- Creating Custom DLL
- Using Custom DLL
15.Working With User Forms
- Creating Dynamic User Forms
- Using Collection & Object Class To Build Robust User Form Application