By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email.
Power BI | MS-SQL | DAX | Power Apps | Power Automate
Power BI | MS-SQL | ETL with SSIS | VBA | Python
Advanced Excel | MIS Reporting | Power Query
VB Programming | VBA | MS-Office Automation
Power BI | Power Pivot | Power Query | Basic DAX
Advanced Excel | MIS Reporting | Model Building
Course on Business Reporting & Process Automation
Course on Business Process Automation
40-hours Course | 90-Scenarios | Live VBA Project | View Schedule
40-hours Course | 90-Scenarios | Live VBA Project View Schedule
This is a 40-hour program, designed for Advanced Excel users, to automate routine Excel reports or processes using VBA Programming & Excel macros coupled with 90+ small-scale scenarios, 7 case studies and, a Live VBA project (post-training) to get a knack of real-time automation.
It doesn't matter if you have zero knowledge of programming. This section starts with the basics of programming for a layperson - establishing a solid foundation for the development of a full-fledged macro, to the most complex coding concepts.
Is VBA a valuable skill?
Yes – If you are a “BUSINESS USER” (non-programmer).
From a reporting perspective, Excel is hundred times more powerful when you learn VBA.
This section will teach how to plug in all the concepts learned in your first section to build a real-time, full-fledged Excel report automation. It will guide you to automate your routine Excel-related processes and tasks - efficiently and effectively.
15 best practices for VBA coding
Many people don’t understand the power of MS-Office and how all the MS-Office applications can communicate with each other or other systems to streamline workflow within your business. This section will teach you how to interact Excel with other applications.
Key benefits of MS Office Automation
Leverage Excel to capture, import, consolidate, lookup, calculate, analyze, summarize, and visualize data. Then update a variety of documents, including:
This section will guide you through the most sought-after topic - web scraping or extracting data from publicly accessible web data to make smarter decisions. You will learn to connect Excel with browsers like Chrome, IE, etc.
Pros and Cons of Web Scraping
Pros
Cons
RPA and macros have several features in common. But each has its own pros and cons. This section will focus on how to leverage the RPAs functionality of seamlessly integrating with non-office applications to automate more tasks in one workflow.
When to use both?
VBA might be a good fit if,
While RPA might be a better fit if,
We live in an increasingly API-centric world. APIs is everywhere you look. This section will teach you how to communicate or share data between VBA and other web applications such as Google, YouTube, Facebook, Twitter, etc. Using APIs.
When are APIs useful?
APIs are useful when fetching continuously varying data like stock price or currency exchange rate. Getting data from APIs is much faster than screen-scraping. Screen-scraping is also affected by UI changes. APIs with response in XML or JSON format can be called using the xmlhttp feature.
Tips for using APIs
| * |
The topics marked in red are advanced training modules - available at an additional cost.
|
It doesn't matter if you have zero knowledge of programming. This section starts with the basics of programming for a layperson - establishing a solid foundation for the development of a full-fledged macro, to the most complex coding concepts.
Yes – If you are a “BUSINESS USER” (non-programmer).
From a reporting perspective, Excel is hundred times more powerful when you learn VBA.
This section will teach how to plug in all the concepts learned in your first section to build a real-time, full-fledged Excel report automation. It will guide you to automate your routine Excel-related processes and tasks - efficiently and effectively.
Many people don’t understand the power of MS-Office and how all the MS-Office applications can communicate with each other or other systems to streamline workflow within your business. This section will teach you how to interact Excel with other applications.
Leverage Excel to capture, import, consolidate, lookup, calculate, analyze, summarize, and visualize data. Then update a variety of documents, including:
This section will guide you through the most sought-after topic - web scraping or extracting data from publicly accessible web data to make smarter decisions. You will learn to connect Excel with browsers like Chrome, IE, etc.
Pros
Cons
RPA and macros have several features in common. But each has its own pros and cons. This section will focus on how to leverage the RPAs functionality of seamlessly integrating with non-office applications to automate more tasks in one workflow.
VBA might be a good fit if,
While RPA might be a better fit if,
We live in an increasingly API-centric world. APIs is everywhere you look. This section will teach you how to communicate or share data between VBA and other web applications such as Google, YouTube, Facebook, Twitter, etc. Using APIs.
APIs are useful when fetching continuously varying data like stock price or currency exchange rate. Getting data from APIs is much faster than screen-scraping. Screen-scraping is also affected by UI changes. APIs with response in XML or JSON format can be called using the xmlhttp feature.
Tips for using APIs
| * |
The topics marked in red are advanced training modules - available at an additional cost.
|
LEARN from Microsoft Certified Trainers
EXPLORE 90+ Small Scale VBA Scenarios
PRACTICE with 7 VBA Case Studies
HANDS-ON experience with a Live VBA Project
ON-JOB Support to implement learnings
*
The topics marked in red are advanced training modules - available at an additional cost.
Alternatively, check our comprehensive Full Stack BI Reporting Course that includes all the above-mentioned topics.
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.
 |
Excel VBA Developer Eligibility: On clearing post-training assessments/exams View Sample Certificate |
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) tend to be on the lower end of the pay scale: around ₹3 ‒ ₹5 lakh per annum.
Mid-level VBA Developers (3-5 years) often earn ₹5 ‒ ₹8.5 lakhs per annum, depending on company and skills.
With more years of experience (6-8 years and above) and complex responsibilities, salaries could go toward the higher side: up to or beyond ₹12.5 lakhs in Bangalore.
For more questions?
Call: +91 9176633248
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.
Eligibility: On clearing post-training assessments/exams
Sample Certificate: View here
Excel VBA Training in Bangalore - Training Schedule
| Session | Date | Time |
|---|
Avail additional 10% Corporate Benefit*
on the total course fee for
5+
participants.
Get you team BI ready, today.
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
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.
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.
One of the best training classes attended so far. A very professional approach, well designed way of teaching. The trainer made sure that even the most slowest learner understands the concepts well. Their true intentions to make sure that everybody who attends should not complete just for the sake of completion but should understand all the concepts was very evident.
They were encouraging us to attend reclasses we dint understand any topic or wanted to learn one more time. Worthyful of the money and time spent. My special thanks and appreciations to sami sir and sai sir for their incredible teaching. Definitely would happy to recommend to others.
I am impressed with the methodology with excel goodies. It was a great learning experience for me at Excel goodies. A professional training institutions and clear road map given to students to achieve their goals.
Top class training program with step by step guidance. Had gained much knowledge in Excel VBA.! Especially Mr.Sami guided us a lot in best way. It was an very good experience with Sami and Sai. Thanks a lot to both of them. :)
I went through the VBA training here at Excelgoodies. The tutors are extremely knowledgeable and helpful. The training programme flow is well planned and helps us to scale up to doing automation in our work place. I found it very useful and it definitely helps anyone doing Excel consolidation and routine reports.
The tutors give individual focus and ensure that all students in the group have properly understood each topic. They even take the same topic again in case we do not understand. I strongly feel there is value for money for the coaching they give. At the end of the course, I could do live projects in my organisation !! Thanks to Excelgoodies :)
My overall experience at Excel Goodies was very very good - All along I used to browse the web to get a VBA Code for my requirement now and then, but the training / guidance offered at Excel Goodies by Mr.Sami and Mr.Sai has really put me in a position whereby, I can really read through the codes and understand how it works and start constructing my own.
Infact I have been looking for a Guru to teach me the fundamentals on VBA Automation for quite a long period, in order to implement my thought process on automating many of the day to day activities that are carried out at my work place and by my clients. When I was casually discussing my passion with my relative, he immediately recommended Excel Goodies to me for doing this course.
Now I am really thankful to him. I strongly recommend Excel Goodies to those who have a passion to master their Excel skills and to venture into VBA Automation, and I am planning to put my son who is a budding CMA Professional into this course. All the very best to all prospective students and Thanks to Mr.Sami & Mr.Sairam and Excel Goodies for giving me a nice learning experience.
Excelgoodies surprises me on how well they cater their programs so perfectly structured and carried out. Cannot ask for better. The programs very well co-ordinated and tailor-tweaked along the course to ensure the best is delivered. Strongly recommend excelgoodies!
Awesome and Structured well professionalled Centre I have seen so far.. the way they organized each sessions was fantastic. I'm very impressed with the vision you guys having against the training program..
Mr.Sami and Mr.Sai thank you so much for your time and patience with us..I'm lucky that I had completed my course in 2019 and starting 2020 with the pride of learning from Excelgoodies.. Rock On - All the best to the team.
I have taken up the VB course during Jan 2019 in ExcelGoodies(EG) - I will strongly recommend Working Professional/Finance Students to take it up the course here in ExcelGoodies. EG is highly professional in terms of conducting trainings, coaching and guiding people in right direction.
My Special kudos to Sami/Sai sir for the wonderful coaching style/techniques followed throughout the 3 months course. Until i joined the course i felt like VB is coding language which Non-Engineering students cannot understand but Sami sir break the assumption and made it clear that anyone can learn VB if they really aspire to learn it.
Thanks once again !!!! Looking forward to opt many course in future in EG (Ex: Power BI, Advance Excel Techniques etc).
My training experience was good... Both the trainers are very knowledgeable as well as very kind... I am a commerce graduate but they have trained me very well with my small amount of excel knowledge.... Whenever I asked coding related clarifications, they helped me immediately... Thanks to Sai and Sami sir..
Mr. Sami/Sai I believe that you have great mastery and expertise in Excel and VBA automation. You have an art in breaking up complex principles into simple and understandable teaching methods.
Excelgoodies has enhanced my skills and taken me to a all new level. I trust you will support me in completing my project. I would surely refer this institute to my colleagues.
Contact Us
Excelgoodies Software Private Limited
No.56, 1 & 2 Floor, North Boag Road,
T-Nagar, Chennai - 17
Tel: +91 9176633248
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
Microsoft T-SQL
MS-SQL Integrated Services
Python
Microsoft Excel VBA
MS-Excel
Power Query
