+91 9176633248

Courses

Batch starts on

th

Course on Business Reporting & Process Automation

Course on Business Process Automation

Excel VBA Training in Pune – Automate Tasks with Macros

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

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

Program Overview

Total Course Duration

40-hours, 16 Sessions

Both Classroom & Online is available.

Training Schedule

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

list-dot Excel VBA Developer
Eligibility:
On clearing post-training assessments/exams
View Sample Certificate

Few of the VBA Projects done by our students

FAQ's

Yes. VBA remains highly relevant in Pune’s corporate settings—especially in finance, MIS automation, and process optimization—where Excel task automation is essential. Excelgoodies’ VBA training ensures you gain automation expertise that employers continue to value.

Mastering VBA through structured, hands-on training at Excelgoodies. The 40-hours program includes 90+ real VBA scenarios and seven end-to-end automation case studies, empowering learners to build automation skills with real-world practice.

You can learn VBA in Pune at Excelgoodies through online sessions, where a 40-hours, 16-session course is offered in online formats, complete with live projects, certification, and post-training support.

Excelgoodies is a top online VBA training in Pune. Their VBA Developer course includes project-based learning, a globally verifiable certificate, and 30-day post-training support, ensuring both skill-building and career readiness.

VBA works within Excel by allowing you to write scripts that manipulate objects like workbooks, sheets, and ranges. Excelgoodies teaches you to automate repetitive workflows through macros and custom code for efficient reporting.

VBA training at Excelgoodies delivers automation skills that save time, reduce errors, and enhance productivity. Through 90+ scenarios and seven case study projects, you’ll gain the ability to build robust Excel automations for real business needs.

Yes. No coding experience is needed. Excelgoodies’ VBA course starts with foundational Excel formulas (nested IFs, lookups, pivots), enabling beginners to learn automation through hands-on practice.

Completing Excelgoodies’ VBA training prepares you for roles like Automation Specialist, MIS Analyst, Reporting Officer, or Excel Developer. The certificate and practical project experience bolster your resume for business efficiency roles.

The Excelgoodies VBA course is a 40-hours program delivered across 16 sessions—typically on weekends—making it efficient for learners to develop strong Excel automation skills in just a few weeks.

No. Prior coding isn’t required. Excelgoodies accepts learners with basic Excel knowledge (formulas, pivots) and builds automation and macro skills from the ground up.

VBA enables advanced Excel automation via macros, object manipulation (workbooks, sheets, ranges), custom functions, and case study-driven projects—empowering you to automate reporting and workflows effectively.

VBA helps to automate repetitive Excel tasks—like data processing, formatting, and reporting. With Excelgoodies’ 7 executive-level automation projects, you’ll learn to streamline workflows and save hours of manual effort.

Macros are recorded Excel actions; VBA is the programming language behind them, offering customization, logic control, and error handling. ExcelGoodies trains you to move from macro recording to scripting robust automation workflows.

While Excel is the primary focus, VBA skills can usually transfer to other Office applications like Word and Outlook for automation. Excelgoodies’ course focuses on Excel automation best, forming a foundation for broader Office scripting.

The course fee for studying VBA in Pune with ExcelGoodies is ₹15,000. On average, VBA training in Pune typically ranges between ₹15,000 to ₹18,000, making ExcelGoodies a cost-effective choice for high-quality, hands-on learning.

Training is led by Microsoft-certified professional Mr. Sami, with 18+ years of industry experience and involvement in projects for clients like the Deutsche Bank, Standard Chartered Bank, World Bank, etc.

Excelgoodies provides job assistance through mock interviews, profile building, and referrals. Many Pune learners have successfully secured VBA roles after completing this course.

No, ExcelGoodies does not provide recorded sessions. The VBA training in Pune is offered only through live online sessions with interactive, real-time guidance.

Yes. The registration fee for VBA training in Pune is INR 500, which will be deducted from the total course fee.

Yes, if a minimum of 5+ participants join together, ExcelGoodies offers a 10% corporate discount on the course fee.

Junior or entry-level VBA Developers (e.g. 0-2 years experience) tend to be on the lower end of the pay scale: around ₹2.5 ‒ ₹5 lakh per annum.

Mid-level VBA Developers (3-5 years) often earn ₹5 ‒ ₹8 lakhs per annum, depending on company and skills.

With more years of experience (say 6-8 years and above), and more complex responsibilities (automation, macro/VBA integration, large-scale reporting), salaries could go toward the higher side: up to or beyond ₹12 lakhs in Pune.

power-bi-training-in-chennai FAQ's

For more questions?

Call: +91 9176633248

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

Excel VBA Developer

Eligibility: On clearing post-training assessments/exams

Sample Certificate: View here

Excel VBA Training in Pune - Training Schedule

Session Date Time

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?

40 hours of Instructor-led training

90+ VBA Scenarios

7 large VBA automation (case studies)

30-Days post-training support (via Email)

Excel VBA Developer

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

Trainers Microsoft Certificate Trainers Microsoft Certificate

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 , .

Registration Closes on .

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

Power BI

Micorsoft T-SQL

Microsoft T-SQL

MS-SQL Integrated Services

MS-SQL Integrated Services

Python

Python

Microsoft Excel VBA

Microsoft Excel VBA

MS-Excel

MS-Excel

Power Query

Power Query