Excelgoodies logo +91 9176633248

Excel VBA Training in Pune

Excel VBA Macro Programming

VB Programming Report Automation MS-Office Automation

  • Both Online & Classroom | 3-4 Months (16 Sessions, 2-hrs each)
  • 90 VB Scenarios, 7 Case Studies & Live Project

(1.5K+ Professionals enrolled)

Prove you're human: Type the code shown.

=
Excelgoodies

Program Overview

Training Schedule

Tuesday, 11 Apr

View Schedule

3-4 Months | 32 Hours

16 Sessions, 2 Hrs Each

Online & Classroom, Instructor-Led

Pre-Requisite

Excel Formulas

View Course Syllabus

Course Fee

₹15,000

Check what’s included?

Excel VBA Programming in Pune

floating_menu floating_menu floating_menu

Batch starts on

th

From Basics to Pro

Work Smarter, Not Harder:
Transform Your Workflow with VBA

Whether you're starting with VBA or you’ve been using it for years, this 32-hour course will show you how to "automate tasks, create powerful macros, and optimize workflows," making your day more efficient and helping you focus on what moves the the needle—"no prior coding knowledge required."

Tools You'll Learn

Data Analysis Tool

Microsoft Excel

Automation & Scripting Tool

Excel VBA

In just 3-4 Months, you'll be able to:

Automate Excel tasks and workflows using VBA.

Confidently write and debug VBA code for automation.

Develop scalable Excel applications to improve efficiency.

Handle advanced Excel automation with ease.

Integrate Excel with other Microsoft Office applications.

In just 3-4 Months, you'll be able to:

Automate Excel tasks and workflows using VBA.

Confidently write and debug VBA code for automation.

Develop scalable Excel applications to improve efficiency.

Handle advanced Excel automation with ease.

Integrate Excel with other Microsoft Office applications.

A snapshot of what you'll be learning in 3-Months.

Course Syllabus Overview

Core Fundamentals

Objective: The term "basic" is subjective based on levels of knowledge, experience, exposure, etc. Basic for one individual doesn't have to be basic for another. Nearly all participants in this training are self-taught and have some Excel skills as well as some gaps.

The objective of this module is to fill gaps, bring everyone to the same level and empower them with comfort and confidence to learn Excel as a reporting solution and not as a computer tool.

Duration – 2.5 Hours (Rapid Session)

CORE FUNDAMENTALS

  • Understanding Excel Environment
  • Entering, Editing and Deleting Text, Numbers, Dates
  • How Excel Understand your information including Text, Numbers and Date values.
  • Fundamental Formatting Techniques & Best Practices
  • Understanding Cell Formats including Advanced Custom Formats
  • Copying and Clearing Formats
  • Working with Styles
  • Understanding Simple Conditional Formatting
  • Moving and Copying data
  • Quick Navigation Techniques
  • Inserting, Deleting and Hiding Rows & Columns
  • Inserting, Deleting, Moving and Copying Sheets
  • Working with multiple Excel Worksheets & Workbooks
  • Working with View Tab including freeze panes, split, new workbook, etc
  • Quick Data Entry Techniques including Auto Fills
  • Understanding & Working with Formulas
  • Mastering Referencing Techniques including Relative, Absolute & Mixed Reference
  • Working with fundamental functions including sum, count, average, max, min, etc
  • Fundamental Keyboard Shortcuts

Advanced Formulas & Functions

Objective: Master 60+ MS Excel formulas to dramatically simplify the work you do in Excel. By the end of the section, you'll be writing robust, elegant formulas from scratch.

Duration – 5 Hours

MATHEMATICAL FUNCTIONS

  • SumIf, SumIfs
  • CountIf, CountIfs
  • AverageIf, AverageIfs
  • SumProduct, Subtotal

LOOKUP FUNCTIONS

  • Vlookup / HLookup
  • Match
  • Dynamic Two Way Lookup
  • Creating Smooth User Interface Using Lookup
  • Offset
  • Index
  • Dynamic Worksheet linking using Indirect

LOGICAL FUNCTIONS

  • Nested If ( And Conditions , Or Conditions )
  • Alternative Solutions for Complex IF Conditions to make work simple
  • And, Or, Not

TEXT FUNCTIONS

  • Upper, Lower, Proper
  • Left, Mid, Right
  • Trim, Len
  • Concatenate
  • Find, Substitute

DATE AND TIME FUNCTIONS

  • Today, Now
  • Day, Month, Year
  • Date, DateDif, DateAdd
  • EOMonth, Weekday

ROUNDING FUNCTIONS

  • Round
  • RoundUp
  • RoundDown
  • MRound

ERROR HANDLING FUNCTIONS

  • isNa
  • isErr
  • isError

VBA Programming

Understanding VBA Programming Environment

Overview

  • 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 Automation using Excel

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

Developing User Interface

Excel Forms

  • Understanding Excel Forms
  • Creating Attractive User Experience with Excel Forms
  • Using Forms Control
  • Linking & Managing Forms Control
  • Performing CRUD (Create, Retrieve, 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, Retrieve, Update & Delete Records) with VBA Form

Working with Other Applications

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 (Additional Cost Applicable)

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 (Additional Cost Applicable)

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

RPA With VBA (Additional Cost Applicable)

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

System Integration using API (Additional Cost Applicable)

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

System Requirements

System Requirements:

  1. Computer

    • Windows operating system
    • Minimum 4GB RAM (8GB or higher recommended)
    • Dual-core processor or higher
    • Reliable internet connection for seamless online sessions and downloads
  2. Software

    • Microsoft Excel (version 2010 or later) installed on your computer
    • Microsoft Visual Basic for Applications (VBA) enabled within Excel

  3. Webcam

    A working webcam is required to participate in online sessions. Please ensure it is functional and positioned properly for clear visibility.

  4. Secondary Monitor (optional, but recommended)

    Having a secondary monitor will greatly assist in following the pace of the trainer. It allows you to view instructions and your own workspace simultaneously, enhancing your learning experience.

fullstack courses

Taught by Microsoft Certified Trainers

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

fullstack courses

Excel VBA Training in Pune - Training Schedule

Limited Seats. Registration Closing Soon

Have Questions?

Tel:

+91 9176633248

Email:

support@excelgoodies.com

Projects & Assignments

What's included?

  • 32 hours of Instructor-led training
  • 90+ VBA Scenarios
  • 7 large VBA automation (case studies)
  • 30-Days post-training support (via Email)
  • Preparatory Excel (60+ Functions & Formulas)
  • Excel VBA Developer

Upcoming Batch

Starts On

Time

Course Fee

₹15,000

Plus GST for Company-Sponsored.

FAQs

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 (0-2 years experience) earn around ₹2.5 ‒ ₹5 LPA. Mid-level VBA Developers (3-5 years) often earn ₹5 ‒ ₹8 LPA. With more experience (6-8 years+) and complex responsibilities, salaries can go up to ₹12 LPA or more in Pune.

More questions ?

Specialist Certification

Certification: Excel VBA Developer

A piece of paper means nothing if you can’t apply the skills. Our certifications are industry-recognized and backed by hands-on training—ensuring you’re not just qualified, but ready to perform from day one.

Eligibility:

On clearing post-training assessment.

View Sample Certificate

Shareable certificate

Add to your LinkedIn profile

Excelgoodies

Level :

Certificate Code : EG-SPL-002

Eligibility:

On clearing post-training assessment.

Shareable certificate

Add to your LinkedIn profile

Build Real-World Solutions During the Course

Key Skills You'll Master

Task Automation

Custom Excel Functions

Automated Reporting

Data Processing

User Interface Design

Macro Management

Decision-Making Logic

Workflow Optimization

Error Handling

Application Integration

About The Trainer

Mr. Sami

MCT, MCSA

15,000+

Students Trained

19+

Year of Experience

4.9

Reviews

Mr. Sami, Microsoft Certified Trainer, with his qualifications in Finance, HR & Information Technology brings in 19 years of Industry experience. He has successfully trained 15,000+ 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

Google Reviews

Corporate Training

bi_report_automation_mob

Avail additional 10% Corporate Benefit on the total course fee for 5+participant.

Get you team BI ready, today.

Ms.Jayasree

Business Associate

Prove you're human: Type the code shown.

=
Excelgoodies

Esteemed Clientele

Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele Esteemed Clientele

Thousands Trained. Here’s What They Say.

Total Reviews 2080
Average Rating
4.5
Excelgoodies Excelgoodies Excelgoodies Excelgoodies Excelgoodies
Why Excelgoodies image

Thousands Trained. Here’s What They Say.

APPLICATION DEADLINE

Registration Closes
on .

Prove you're human: Type the code shown.

=
Excelgoodies

Industry Insights

Industry Insights

Browse City & State Schedules

Find VBA Course Near Me