+91 9176633248

Courses

Batch starts on

Jul 06th

Course on Business Reporting & Process Automation

Course on Business Process Automation

Excel VBA Macro Programming

Excel VBA Macro
Programming

36-hours Course | 90-Scenarios | Live VBA Project |

36-hours Course | 90-Scenarios | Live VBA Project

Program Overview

Total Course Duration

36-hours, 12 Saturdays

Both Classroom & Online is available.

Training Schedule

Saturday, 06 Jul

Course Fee

INR 15,000

Plus GST for Company-Sponsored.

CERTIFICATE

Excel VBA Developer

Globally verifiable certificate

PRE-REQUISITE

Excel Formulas

Nested IFs, Lookups, Pivots etc.

Our 5 Steps Learning Process

VBA Learning Redefined.

Learn Excel

LEARN from Microsoft Certified Trainers

Practice Excel

EXPLORE 90+ Small Scale VBA Scenarios

Revise Excel

PRACTICE with 7 VBA Case Studies

Speed-up Excel

HANDS-ON experience with a Live VBA Project

Excel On-Job Support

ON-JOB Support to implement learnings

Both Online & Classroom is available.*

All our classes are live, hands-on and with real-trainers.

No recorded sessions.

Live VBA Project

We believe firmly in result-oriented Automation training. Hence, the learning at Excelgoodies doesn't stop just with the Classroom sessions. Post the Training; you will be offered an opportunity to take up a live VBA project from your company and implement all the concepts learned in real-time.

You will also be honored with the "Report Automation Specialist" Certificate on saving at least 2 hours of work per day.

Certifications

Report Automation Specialist using Excel VB Programming
Eligibility:
On implementing a successful live VBA project
View Sample Certificate
Excel VBA Developer
Eligibility:
On clearing post-training assessments/exams
View Sample Certificate

Few of the VBA Projects done by our students

Course Content Overview

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

Report Automation Specialist using Excel VB Programming

Eligibility: On implementing a successful live VBA project

Sample Certificate: View here

Excel VBA Developer

Eligibility: On clearing post-training assessments/exams

Sample Certificate: View here

Training Schedule

Session Date Time
Session 1 06-Jul 3:00 PM to 05:30 PM
Session 2 13-Jul 3:00 PM to 05:30 PM
Session 3 20-Jul 3:00 PM to 05:30 PM
Session 4 27-Jul 3:00 PM to 05:30 PM
Session 5 03-Aug 3:00 PM to 05:30 PM
Session 6 10-Aug 3:00 PM to 05:30 PM
Session 7 17-Aug 3:00 PM to 05:30 PM
Session 8 24-Aug 3:00 PM to 05:30 PM
Session 9 31-Aug 3:00 PM to 05:30 PM
Session 10 14-Sep 3:00 PM to 05:30 PM
Session 11 21-Sep 3:00 PM to 05:30 PM
Session 12 28-Sep 3:00 PM to 05:30 PM

Course Fee

INR 15,000

CORPORATE
Training 5 or
more people?

Avail additional 10% Corporate Benefit*
on the total course fee for 5+ participants.
Get you team BI ready, today.

What is included?

36 hours of Instructor-led training

90+ VBA Scenarios

7 large VBA automation (case studies)

30-Days post-training support (via Email)

Report Automation Specialist Certification

View Certificate

Live VBA Project

We believe firmly in result-oriented Automation training. Hence, the learning at Excelgoodies doesn't stop just with the Classroom sessions. Post the Training; you will be offered an opportunity to take up a live VBA project from your company and implement all the concepts learned in real-time.

You will also be honored with the "Report Automation Specialist" Certificate on saving at least 2 hours of work per day.

About the Trainer

Mr. Sami, MCT, MCSA Data Enthusiast & a Technophile

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance, HR & Information Technology brings in 14 years of Industry experience. He has successfully trained 9500+ professionals by now, and the counting is still on.

He has undertaken assignments with the renowned IRS, The World Bank, Tata Chemicals, Buckman Laboratories, Standard Chartered, ING Barings and much more. His nature of going that Extra Mile has got him the startling popularity amongst the Excelgoodies prominent clients.

Classroom Gallery

APPLICATION DEADLINE

Application Deadline

Registration Closes on
Wednesday, 03 Jul.

Registration Closes on Wed, 03 Jul.

Google Reviews

Contact Us

Excelgoodies Software Private Limited

No.56, 1 & 2 Floor, North Boag Road,

T-Nagar, Chennai - 17

Tel: +91 9176633248

inquiry@excelgoodies.com

Recommended Course (For Advanced Reporting Users Only)

Full Stack BI R
Reporting & Automation Course.

72 Sessions | 9-Specialist Certifications

You will learn to use the right and hybrid technology for end-to-end advanced power reporting.

Tools: Power BI, Power Pivot, VBA, Excel,
M-Programming, MS-SQL, SSIS, and many more.

Power BI

Micorsoft T-SQL

MS-SQL Integrated Services

Python

Microsoft Excel VBA

MS-Excel

Power Query