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 :
Find A Batch10,000
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