+1 650 491 3131

Batch starts on

th

Course on Business Reporting & Process Automation

Course on Business Process Automation

Excel VBA Macro Programming

Excel VBA Macro
Programming

20-hours Course | 90-Scenarios | Live VBA Project | View Schedule

View Schedule

Program at a Glance

Total Course Duration

20-hours , 08 Sessions

Live Online (Weekdays)

Training Schedule

Course Fee

$499

Enroll Now

Course Fee

$499

Enroll Now

PRE-REQUISITE

Excel Formulas

Nested IFs, Lookups, Pivots etc.

No coding knowledge is required to join this course.

This is a 20-hour program designed for Advanced Excel users, focusing on automating routine Excel reports or processes using VBA Programming and Excel macros. The course includes 90+ small-scale scenarios, 7 case studies, and a Live VBA project (post-training) to provide hands-on experience in real-time automation.

What will I learn?

Write VBA code - that works, to automate and streamline your Excel workflows.

VBA Fundamentals

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?

Excel Report Automation

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

MS-Office Automation

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

Web Scrapping with VBA

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

System Integration using API

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?

VBA Fundamentals

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.

Excel Report Automation

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.

MS-Office Automation

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.

Web Scrapping with VBA

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.

System Integration using API

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.

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

Taught by Microsoft Certified Trainers.*

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

No recorded sessions.

Course Content Overview

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

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

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 Excel workspace simultaneously, enhancing your learning experience.

Course Fee

$ 499

What is included?

25 hours of Instructor-led training

90+ VBA Scenarios

7 large VBA automation (case studies)

30-Days post-training support (via Email)

Report Automation Specialist Certification

View Certificate

READY TO BE CERTIFIED AS A

Excel VBA Developer?

Training Schedule

Session Date Time (ET)

Live VBA Project

At Excelgoodies, we believe in practical and results-driven training. We understand that just learning in the classroom may not be enough, so we offer our trainees an amazing opportunity to work on a live VBA project from their own company post-training. This way, you can put your newly learned skills into practice and become more confident in your abilities.

And when you successfully save at least 2 hours of work per week with your newfound expertise, you'll earn the highly-coveted "Report Automation Specialist" Certificate. This recognizes your exceptional skills in automation and shows that you've truly mastered the craft.

Certifications

Report Automation Specialist using Excel VBA Programming
Eligibility:
On implementing a successful live VBA project
View Sample Certificate

Connect with Us

Mr. Perrie Smith

Business Associate

Tel: +1 650 491 3131

Email: support@excelgoodies.com

Connect us on

Few of the VBA Projects done by our students

About Your 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.

With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.

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.

Throughout his illustrious career, Mr. Sami has collaborated with esteemed organizations such as the IRS, The World Bank, Mercedez-Benz, Comcast, Standard Chartered, and ING Barings, to name just a few. His unwavering commitment to going the extra mile has earned him a stellar reputation among Excelgoodies' prominent clients.

With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.

Course Content Overview

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

25 hours of Instructor-led training

90+ VB Scenarios

7 large VBA automation (case studies)

30-Days post-training support (via Email)

Report Automation Specialist Certification

View Certificate

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

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

  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 Excel workspace simultaneously, enhancing your learning experience.

Report Automation Specialist using Excel VBA Programming

Eligibility: On implementing a successful live VBA project

Sample Certificate: View here

Training Schedule

Session Date Time (ET)

Course Fee

$499

What is included?

  • 25 hours of Instructor-led training
  • 90+ VBA Scenarios
  • 7 large VBA automation (case studies)
  • 30-Days post-training support (via Email)
  • Report Automation Specialist Certification
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.

Connect with Us

Mr. Perrie Smith

Business Associate

Tel: +1 650 491 3131

Email: inquiry_excel@excelgoodies.com

Connect us on

About Your 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.

With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.

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.

Throughout his illustrious career, Mr. Sami has collaborated with esteemed organizations such as the IRS, The World Bank, Mercedez-Benz, Comcast, Standard Chartered, and ING Barings, to name just a few. His unwavering commitment to going the extra mile has earned him a stellar reputation among Excelgoodies' prominent clients.

With his wealth of knowledge and dedication to delivering exceptional training experiences, Mr. Sami consistently exceeds the expectations of his clients and leaves a lasting impact on the professionals he trains.

Learner stories around
the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

Graph

5

2.0K

4

1.0K

3

500

2

200

1

0

Star Rating

Trainer's Expertise

Course Structure

Course Content

Assignments

Certification Process

Scott A. Reifsynder

Power BI Training

Chief Financial Officer

Nexterus

United States

This class was extremely helpful in my knowledge and growth in these database, analysis and reporting tools. I really enjoyed the hands-on approach and got lots of “goodies” out of all the classes. Your approach, repetitiveness and patience is much appreciated and sincerely helped me learn how to accomplish these important tasks. Doing these activities again and again embedded these processes into my routines while I began strategizing how to best utilize these tools in my company’s reporting and analyses. I’d be happy to consider additional classes that you offer on related, important topics to continue enhancing my skills. Thank you very much for your teaching and training methods. I am also very grateful that you provided the daily sample dashboards, instruction steps and how-to descriptions.

Wendy Flowers

Power BI Training

Financial and Business Analyst

First Light

United States

This Power BI course was an exceptional training experience. It was very fast paced -- necessary as it covered Power Pivots, Power Query, DAX, Power BI, and SQL. Sami ran the training smoothly, staying after to help individuals with questions. We also are able to schedule up to two 30-minute sessions after the end of the course for guidance on projects. Highly recommend!

Tim Palacios

Power BI Training

WFM Data Developer

World Connection

United States

This course was excellent. Sami had a systematic approach to the course curriculum which I feel is key to most if not all learning experiences. He was very knowledgeable and very quick with troubleshooting and helping support when we had any challenges with our work. I am definitely going to take more courses from Excelgoodies. If you are an IT professional or require Data Analytics for your job, this is a great course and I highly recommend it. I think my only critique is that I would have like to have more time devoted to the database side of the class, but that is just a personal preference.

Learner stories
around the world

Total Reviews

4583

Overall growth till now

Average Rating

4.9

Average rating this year

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

Contact Us

Excelgoodies Consulting, inc.

575 7th Avenue, 5th Floor

New York City, NY 10018

Tel: +1 650 491 3131

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

Micorsoft T-SQL

MS-SQL Integrated Services

Python

Microsoft Excel VBA

MS-Excel

Power Query