Understanding VBA Programming Environment

• Project
• Project Explorer
• Menubar
• Toolbar
• Code Window
• Module
• UserForm

Programming Fundamentals Using VBA

• Procedures
• User Defined Functions
• InputBox Function
• MsgBox Function
• Variables
• Constants
• Data Types
• Working with Logical Operators
• IF statement
• Nested IF Statement
• IF with And Or Scenarios
• Select Case
• VBA Functions
• Problem solving techniques required for programming
• Saving Macro Enabled Files
• For Loops
• Do Loops
• While...Wend Statement
• Protecting Code
• Error Handling

Running Code

• Run mode as a developer
• Running Code as end user
• Running Code to debug procedures & Functions

VBA Programming Fundamentals

• Understanding Object Based Programming
• Understanding Objects
• Working with Collection Objects
• Working with Methods
• Read & Write Properties

Programming & Automating with Excel Objects

• Excel Object
• Workbook Object
• Worksheet Object
• Cell Objects
• WorksheetFunction Object
• PivotTables Object
• Chart Objects
• Other Misc Objects

Code Automation Concepts via Excel Automation

• Calling Methods
• Passing Arguments while calling procedures
• Passing Arguments while calling functions
• Creating & Strategizing re-usable code modules

Excel Forms

• Understanding Excel Forms
• Creating Attractive User Experience with Excel Forms
• Using Forms Control
• Linking & Managing Forms Control
• Performing CRUD (Create, Retreive, Update & Delete Records) with Excel Forms

VBA Forms

• Understanding VBA Forms
• Creating Attractive User Experience with VBA Form
• Pros & Cons of VBA Form
• Understanding Toolbox
• Using Tools Objects like label, textbox, listbox, combobox, option buttons, command buttons, etc
• Understanding Events
• Working with Form Events
• Performing CRUD (Create, Retreive, Update & Delete Records) with VBA Form

Creating & Manupulating Word Documents using Word Objects

• Using a Set Statement
• Understanding Object Variables
• Application Object
• Documents Object
• Table Object
• Working with Selections
• Other Misc Word Objects

Sending Emails & Reading Incoming Emails using Outlook Objects

• Outlook Object
• Items Object
• Emails Collection
• Sending emails with Plain Text & Attachments
• Sending HTML Emails
• Query to retrieve Mail From, to and CC address
• Retrieve Mail Subject and Time
• Retrieve Mail Attachment

Other Misc Automations

• Creating a browse option in the Macro
• Reading file list from a folder
• Create, Rename & Delete Folders
• Managing versions with date & time stamp
• Creating Excel Add-in
• Dynamic Data Consolidations

Working with MS-Access Applications

• Creating a Database
• Understanding Tables and Creating Tables
• Querying Data
• Filtering Data
• Grouping Data
• Ordering Data
• Column Aliases
• Table Aliases
• Retreiving data with VBA
• Inserting, Updating and Deleting Data with VBA

Web Scrapping with VBA

• Understanding & Installing Chrome Driver
• Understanding HTML Tags
• Understanding IDs, Class & Elements
• Understanding basic Javascripts
• Reading & Updating Websites using Element IDs, Class & Names
• Reading Dynamic Elements in websites using VBA
• Auto Filling Complex WebForms with VBA
• Performing Web based actions using VBA

Developing RPA Functionalities with VBA

• Programming Windows Desktop Applications with VBA
• Understanding Windows API
• Calling Windows API Using VBA
• Working with Windows Libraries
• Reading & Updating System registries
• Working with user32.dll
• Working with kernel32.dll
• Working with shell32.dll
• Other advanced RPA functionalities built with VBA

Integrating with other web based applications using API

• Understanding APIs
• Understanding JSON File Types and XML Files
• Creating API calls with VBA
• Reading, updating & deleting data with API
• Working with Google APIs, Microsoft APIs, SalesForce APIs, etc