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 28-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 2 weeks, 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 2 weeks, 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.

Ideal For:

Analysts & MIS Professionals

Looking to automate repetitive tasks and enhance reporting efficiency.

Finance & Accounting Professionals

Wanting to streamline financial models, reconciliations, and data processing.

Business & Data Analysts

Seeking to build advanced Excel automation solutions for data transformation and analysis.

Excel Power Users

Ready to move beyond formulas and leverage VBA for custom automation.

IT & Operations Teams

Needing to optimize workflows and eliminate manual processes.

A snapshot of what you'll be learning in 2-weeks.

Course Syllabus Overview

VBA Programming

Duration – 4 Hours

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

Duration – 6 Hours

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

Duration – 4 Hours

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 MS-Office Applications

Duration – 4 Hours

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

System Requirements

System Requirements:

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

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

A working webcam is required to participate in online sessions. Please ensure it is functional and positioned properly for clear visibility.
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.

Advanced Automation courses – now available.

Take Automation to the Next Level

Business Process Automation

The Future of Process Automation.

Power Apps | Power Automate | VBA & Python

View Details ➝

Taught by Microsoft Certified Trainers

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

Specialist Certification

Certification: 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

Level : SPECIALIST

Certificate Code : EG-SPL-002

Eligibility:

On clearing post-training assessment.

Shareable certificate

Add to your LinkedIn profile

Training Schedule

01:00 PM to 03:00 PM ET

Limited Seats. Registration Closing Soon

Have Questions?

Tel:

+1 650 491 3131

Email:

support@excelgoodies.com

Projects & Assignments

What's included?

28 hours of live instructor-led training
90+ real-world VBA scenarios
7 large-scale VBA automation case studies
VBA Developer Certificate (project-based)
30 days of post-training email support

Upcoming Cohort

Starts On

Time

Course Fee

$499

Tel: +1 650 491 3131

FAQs

If you miss a session, we provide class notes and exercises to help you catch up. Additionally, you can attend the same session in a future batch (subject to availability).

Yes! The course starts from scratch and gradually moves to advanced automation techniques, making it suitable for both beginners and experienced Excel users.

We accept credit/debit cards, wire transfers, and corporate invoices for employer-sponsored payments.

No! The course starts from scratch and gradually progresses to advanced automation techniques, making it beginner-friendly.

Yes, but some advanced VBA features work best on Windows. While most concepts apply to both platforms, Windows users get the full VBA functionality.

No, VBA is built into Excel and does not require separate installation. However, enabling macros might require admin rights in corporate environments.

Yes! We provide corporate invoices for employer-sponsored payments. You can either use a company card or request an invoice to forward to your finance team for processing. These options are available at the Sign-Up form.

Yes! We offer corporate discounts for teams of 5 or more enrolling together. We also provide customized corporate training tailored to your organization's needs.

We do not provide a participation/course completion certificate. However, the VBA Developer/Specialist Certificate is awarded only upon successful completion of a real-time project, which can be taken up from your workplace.

Yes! To earn the VBA Developer/Specialist Certificate, you must successfully complete a real-world automation project.

This is a live, instructor-led course with real-time coding, hands-on exercises, and Q&A discussions, ensuring a highly engaging learning experience.

You can retake sessions from a future batch (subject to availability), but full course re-enrollment may require an additional fee.

Unlike pre-recorded courses, this is a live, interactive program with hands-on learning and direct access to expert instructors.

See all frequently asked questions

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, MCP, MEE, MOS

30,000+

Students Trained

18+

Year of Experience

4.9

Reviews

Mr. Sami is an exceptionally accomplished and certified Microsoft Trainer, possessing extensive expertise in the fields of Finance, HR, and Information Technology. With an impressive 14-year tenure in the industry, he has successfully trained and empowered over 23,000 professionals, and the number continues to grow.

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.

Government Institutions We've Worked With.

Trusted by Government Entities

Build Real-World Solutions During the Course

The Excelgoodies Difference

We Spot Trends Before They Become Industry Standards

The analytics industry moves fast. We move faster. We constantly update our courses to match the latest industry needs, so you’re always learning what’s in demand—before everyone else.

Learn What Matters, Not Just What’s Trending

BI & Analytics isn’t about knowing one tool—it’s about knowing how to use the right tools together. Our courses don’t just teach software; they teach end-to-end reporting, automation, and cloud-driven analytics workflows—exactly what businesses need.

Tech-Enabled Learning,
Zero Hassles

Forget scattered emails and outdated PDFs. Our AI-powered student portal keeps everything in one place—live classes, assignments, progress tracking, instructor feedback, invoices, and instant support—so you stay focused on learning.

Real Projects, Real Experience, Real Confidence

No more theory-only learning—you’ll walk out of our courses with proven expertise in the tools and techniques hiring managers want.

Corporate Training

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

Get you team BI ready, today.

Mr. Perrie Smith

Business Associate

+1 650 491 3131

support@excelgoodies.com

Prove you're human: Type the code shown.

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

Esteemed Clientele

Thousands Trained. Here’s What They Say.

Total Reviews 2080k

Average Rating

4.5

Quotes icon Overall really enjoyed the course. Nice balance between demos, guided practice and independent practice. I really enjoyed the exercises where criteria was displayed and we had 20 minutes to build it up. Content felt very heavy on dashboard creation with an accelerated run thru PowerQuery material in the last several days; I think this could be a bit more balanced. My company had 5 students with stronger use needs for automated data manipulation than db's. The SQL review on Day10 was a bit fuzzy, I couldn't quite follow the benefits or use cases where this would be relevant. I would recommend adding a 5min break to the middle of each session for biological needs; 2.5 hrs is a long shot for some folks. We spent about 5 minutes at the beginning of each lesson setting up the day's folder structure, copying over data sets, etc. Could eliminate this and replace with a break if the overall folder structure was distributed with data sets already loaded in place at start of course. I.e. send zipped structure with folders for Days 1-10, each containing the ""Project X - Dashboard"" subfolders with Sales.Data.csv, etc, already saved in place. Thanks for the experience! looking forward to applying the knowledge! Quotes icon

Delaney Sullivan | Finance Transformation Project Manger | American Tower | United States (Power BI Training)

Quotes icon I had a little experience with Power BI prior to the class. The information given greatly expanded my knowledge and I am excited to put the knowledge to use. Sami's instructions were very easy to follow and he made sure to answer everyone's questions. The only issue I had with the course was with the students not the instructor or course itself. It was a bit frustrating when some of the students were not prepared (especially not having the system requirements installed) and we had to wait for them to download materials or software. Sami handled it professionally but it took away time that could have been used for training. Overall, I am very please with what I have learned and will be looking into taking the Full Stack BI training. Thank You, Iris Bradshaw Quotes icon

Iris Bradshaw | Data Analyst | Qnnect | United States (Power BI Training)

Quotes icon I liked the pace and content of this introduction to Power BI. The instructor was able to quickly troubleshoot most issues that people had, although some problems did stall the pace quite a bit at times (participants really should have a strong Excel skillset and ability to manage files). Perhaps on a daily basis before the training , a quick 'setup' email would be helpful (which folders to create and which files to copy) so that everyone could set themselves up ahead of time. (Or include day-by-day setup instructions in the content zip file with this info.) On another note, I would like to have spent more time on publishing and refreshing published reports (and the Power BI workspace) instead of the SQL server mini course. As it was, though, the lessons we learned in this training will be almost immediately applied and the results should be very helpful to people in my organization looking for dashboard summaries of their data. Thank you. Quotes icon

Michele Sabatino | Data Analytics Manager | Harbor Health | United States (Power BI Training)

Quotes icon Sami did a great job introducing the basics of Power BI through instruction and hands-on learning. This is a good course for a complete beginner, and would probably benefit some early intermediate students as well. My only complaint would be the amount of time needed to troubleshoot so many students' technical issues. We probably spend 40% of the total class time with Sami troubleshooting. It's not a knock on Sami or the course. Maybe a slightly smaller class would make it a little easier. Quotes icon

Zane Kinsey | Business Controller | Pacific Power Group | United States (Power BI Training)

Quotes icon This training was great! I've been working with Power BI for a little while now but was mostly self-taught so it was nice to learn some best practices for the way to do things. Also good to learn more about DAX and Power Query. Thank you Sami! Quotes icon

Michael Morrison | Platform Analyst | Cross First Bank | United States (Power BI Training)

Thousands Trained. Here’s What They Say.

Delaney Sullivan

Power BI Training

Finance Transformation Project Manger

American Tower

United States

Overall really enjoyed the course. Nice balance between demos, guided practice and independent practice. I really enjoyed the exercises where criteria was displayed and we had 20 minutes to build it up. Content felt very heavy on dashboard creation with an accelerated run thru PowerQuery material in the last several days; I think this could be a bit more balanced. My company had 5 students with stronger use needs for automated data manipulation than db's. The SQL review on Day10 was a bit fuzzy, I couldn't quite follow the benefits or use cases where this would be relevant. I would recommend adding a 5min break to the middle of each session for biological needs; 2.5 hrs is a long shot for some folks. We spent about 5 minutes at the beginning of each lesson setting up the day's folder structure, copying over data sets, etc. Could eliminate this and replace with a break if the overall folder structure was distributed with data sets already loaded in place at start of course. I.e. send zipped structure with folders for Days 1-10, each containing the ""Project X - Dashboard"" subfolders with Sales.Data.csv, etc, already saved in place. Thanks for the experience! looking forward to applying the knowledge!

Iris Bradshaw

Power BI Training

Data Analyst

Qnnect

United States

I had a little experience with Power BI prior to the class. The information given greatly expanded my knowledge and I am excited to put the knowledge to use. Sami's instructions were very easy to follow and he made sure to answer everyone's questions. The only issue I had with the course was with the students not the instructor or course itself. It was a bit frustrating when some of the students were not prepared (especially not having the system requirements installed) and we had to wait for them to download materials or software. Sami handled it professionally but it took away time that could have been used for training. Overall, I am very please with what I have learned and will be looking into taking the Full Stack BI training. Thank You, Iris Bradshaw

Michele Sabatino

Power BI Training

Data Analytics Manager

Harbor Health

United States

I liked the pace and content of this introduction to Power BI. The instructor was able to quickly troubleshoot most issues that people had, although some problems did stall the pace quite a bit at times (participants really should have a strong Excel skillset and ability to manage files). Perhaps on a daily basis before the training , a quick 'setup' email would be helpful (which folders to create and which files to copy) so that everyone could set themselves up ahead of time. (Or include day-by-day setup instructions in the content zip file with this info.) On another note, I would like to have spent more time on publishing and refreshing published reports (and the Power BI workspace) instead of the SQL server mini course. As it was, though, the lessons we learned in this training will be almost immediately applied and the results should be very helpful to people in my organization looking for dashboard summaries of their data. Thank you.

Zane Kinsey

Power BI Training

Business Controller

Pacific Power Group

United States

Sami did a great job introducing the basics of Power BI through instruction and hands-on learning. This is a good course for a complete beginner, and would probably benefit some early intermediate students as well. My only complaint would be the amount of time needed to troubleshoot so many students' technical issues. We probably spend 40% of the total class time with Sami troubleshooting. It's not a knock on Sami or the course. Maybe a slightly smaller class would make it a little easier.

Michael Morrison

Power BI Training

Platform Analyst

Cross First Bank

United States

This training was great! I've been working with Power BI for a little while now but was mostly self-taught so it was nice to learn some best practices for the way to do things. Also good to learn more about DAX and Power Query. Thank you Sami!

Google Reviews

Jackson Yu, Medpoint Management

I recently completed the Power BI training, and it was an excellent learning experience. The course was well-structured, covering everything from basic visualization techniques to advanced DAX functions. The instructor was highly knowledgeable and explained complex concepts in a clear and practical manner.

Mariah Mayhew, Financial Analyst

Sami was a great instructor. He took the time to make sure everyone could follow along and understand the material. While I already had experience with Power BI prior to this course, it was still a great refresher. If you're new to Power BI this is a great course to take!

Regina King, Accounting Manager

Sami, our trainer, was really good. He was very thorough in explaining concepts as well as navigating the user interface. He kept a good pace while ensuring that nobody was left behind . I recommend this course.

Industry Insights

VBA

VBA for Project Management: Automating Task Tracking

VBA

5 things you can do to Optimize your VBA Macro

VBA

VBA for Web Development: Creating Dynamic Web Pages

Industry Insights

VBA

VBA for Project Management: Automating Task Tracking

VBA

5 things you can do to Optimize your VBA Macro

VBA

VBA for Web Development: Creating Dynamic Web Pages

APPLICATION DEADLINE

Registration Closes
on .

+1 650 491 3131

support@excelgoodies.com

Prove you're human: Type the code shown.

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

+1 650 491 3131

support@excelgoodies.com

Compare Power BI Bootcamp to Similar Courses

For Automation Masters

Business Process Automation PRO (Hybrid)

Compare

Course on Microsoft Power Platform

Full Stack BI& Automation (On Cloud)

Power BI | Power Apps | Power Automate | SQL (Query & Programming)

Compare

Compare Now

Select one or more checkboxes

Fill-in the details.

Business Professionals

Techno-Business Professionals

Technology Professionals

Excel VBA Programming for Automation

Program Overview

Training Schedule

Pre-Requisite

Course Fee

Work Smarter, Not Harder: Transform Your Workflow with VBA

Tools You'll Learn

Data Analysis Tool

Microsoft Excel

Automation & Scripting Tool

Excel VBA

In just 2 weeks, you'll be able to:

In just 2 weeks, you'll be able to:

Ideal For:

Course Syllabus Overview

VBA Programming

Overview

Programming Fundamentals Using VBA

Running Code

VBA Automation using Excel

Programming & Automating with Excel Objects

Code Automation Concepts via Excel Automation

Developing User Interface

VBA Forms

Working with MS-Office Applications

Sending Emails & Reading Incoming Emails using Outlook Objects

System Requirements

Take Automation to the Next Level

Taught by Microsoft Certified Trainers

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

Few of the VBA Projects done by our students

Specialist Certification

Certification: VBA Developer

Training Schedule

Projects & Assignments

What's included?

Upcoming Cohort

Course Fee

FAQs

What if I miss a session?

Is this course suitable for beginners?

What payment methods do you accept?

Do I need prior coding experience?

Can Mac users take this course?

Do I need admin rights to use Excel VBA?

Can my employer sponsor my enrollment?

Do you offer corporate discounts?

Will I receive a certificate after completing the course?

Is the project required to earn the VBA Specialist Certificate?

How interactive are the sessions?

Can I retake the course if needed?

How does this course compare to online tutorials?

Build Real-World Solutions During the Course

Key Skills You'll Master

About The Trainer

Trusted by Government Entities

The Excelgoodies Difference

Corporate Training

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

Get you team BI ready, today.

Esteemed Clientele

Thousands Trained. Here’s What They Say.

Thousands Trained. Here’s What They Say.

Google Reviews

Industry Insights

Industry Insights

Registration Closes on .

Compare Power BI Bootcamp to Similar Courses

Excel VBA Programming
for Automation

Work Smarter, Not Harder:
Transform Your Workflow with VBA

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

Registration Closes
on .