Excelgoodies logo +91 9176633248

Excel VBA Training in Bangalore

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 Bangalore

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 Bangalore - 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

VBA (Visual Basic for Applications) is a programming language embedded in Microsoft Excel that allows users to automate repetitive tasks, create custom functions, and develop complex macros, enhancing productivity and efficiency in data processing and reporting.

ExcelGoodies offers a comprehensive 40-hour VBA course designed for beginners. With structured sessions and hands-on practice, learners can expect to grasp the fundamentals and start automating tasks effectively within a month.

Yes, VBA remains a valuable skill for automating Excel-based tasks, especially in finance, accounting, and data analysis roles. Its ability to streamline workflows and integrate with other Microsoft Office applications keeps it relevant in the job market.

Proficiency in VBA opens doors to roles such as Excel VBA Developer, Business Analyst, Reporting Specialist, and MIS Executive. These positions are prevalent in Bangalore industries like finance, consulting, and IT, where data automation is crucial.

VBA enables users to record and write macros that automate repetitive tasks like data entry, formatting, and report generation, significantly reducing manual effort and the potential for errors, thereby improving overall productivity.

No prior programming experience is required. Excelgoodies' VBA course starts with the basics, introducing programming concepts in a simple manner, making it accessible for business users and professionals seeking to enhance their Excel capabilities.

VBA developers in Bangalore can expect an average salary ranging from ₹6 to ₹12 lakhs per annum, depending on experience and expertise. Advanced skills in VBA can lead to higher-paying opportunities in specialized roles.

Commonly used VBA functions include Range, Cells, MsgBox, InputBox, For Each...Next loops, If...Then...Else statements, and Application.WorksheetFunction. These functions facilitate tasks like data manipulation, user interaction, and automation of Excel operations.

Yes, VBA allows seamless integration with other Microsoft Office applications like Word, Outlook, and Access. This capability enables the automation of cross-application tasks, such as generating reports in Word or sending automated emails via Outlook.

Learning VBA enhances data analysis skills by enabling the automation of data cleansing, transformation, and reporting processes. This leads to more efficient data handling, quicker insights, and the ability to manage larger datasets effectively.

Learning VBA in Bangalore helps you automate tasks, improve productivity, and advance your career in data management and analysis. ExcelGoodies offers a 40-hour course with 90+ real-world scenarios, 7 case studies, and a live VBA project, giving you practical experience to become job-ready.

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

No. Coding knowledge is not required to join the VBA course.

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 Bangalore learners have successfully secured VBA roles after completing this course.

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

Yes. The registration fee for VBA training in Bangalore 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-level VBA Developers (e.g. 2 years experience) earn around ₹3 ‒ ₹5 LPA. Mid-level VBA Developers (3-5 years) often earn ₹5 ‒ ₹8.5 LPA. With more years of experience (6-8 years+) and complex responsibilities, salaries can go up to ₹12.5 LPA or more in Bangalore.

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