Excel VBA: Dynamic Templates, Send Emails, Automate Browsers, PDF Form Filling, Web Scrape

Learn Excel VBA quickly and efficiently with plenty of projects as practice

Dynamic Excel Template and Send Emails
Dynamic Excel Templates + Send Emails

Learn to create dynamic Excel templates, automate saving those templates to PDF files, programmatically send emails with attachments from Outlook and Gmail.

Browser Automation and Selenium
Web Browser Automation + Selenium

Automate Internet Explorer and Chrome (using Selenium). Submit web forms, click buttons, loop through webpages, web scrape.

PDF Forming Filling
PDF Form Filling and More


PDF form filling using Excel data. Loop through text in PDF files. Merge PDFs and more. See below.

This course is geared towards beginner, intermediate and advanced Excel users who want to increase their coding skills by learning real world business examples. This course provides the information necessary for someone who has no programming experience to learn the basics of programming, while at the same time learning how to create useful Excel VBA programs.

Projects covered:

  • Write 10+ VBA programs to automate your daily tasks
  • Master Excel VBA fundamentals
  • Create dynamic Excel templates
  • Automate saving Excel templates as PDFs
  • Send emails with attachments from Outlook and Gmail
  • Automate Internet Explorer and Chrome (using Selenium) for web tasks
  • Interact with multiple Excel files
  • PDF form filling
  • Interact with APIs
  • Web scrape using HTTP requests
  • Parse text in a PDF
  • Dynamically split and merge PDFs
  • Loop through files in a folder
  • Mass rename and mass copy files
  • Learn about HTML, JSON and XML

Every line of code in the course includes comments, so you're not left guessing what each line of code does. Also, a video is included for every coding related section.

You'll learn how Excel VBA can be used for a lot of tasks beyond just with Excel. By the end of the course, you will have all of the scripts and knowledge to implement VBA programs from scratch. Learning how to write VBA code will allow you to automate many tasks in Excel, saving you time. Let's begin!

Course Curriculum


  Quick Course Introduction
Available in days
days after you enroll
  Intro to VBA Programming and Excel Efficiency
Available in days
days after you enroll
  Creating Dynamic Excel Templates Using VBA
Available in days
days after you enroll
  Looping Through the Template and Automated Saving to PDF
Available in days
days after you enroll
  Send PDF Templates as Email Attachments - Outlook and Gmail
Available in days
days after you enroll
  Automate Web Tasks, Web Form Filling, Web Data Scraping with IE & Chrome
Available in days
days after you enroll
  Interact with APIs - JSON, XML, HTML (Foundations of Web Scraping)
Available in days
days after you enroll
  Interact with Multiple Excel Files
Available in days
days after you enroll
  Loop Through Files in a Folder, then Rename
Available in days
days after you enroll
  Fill in PDFs from Excel, Split PDFs, Merge PDFs
Available in days
days after you enroll

Meet the Instructor

Excel Expert / CPA Accountant / Instructor


Hello! My name is Yuri. I have been a programmer and CPA business professional (in the private equity space) for over seven years. I have worked with hundreds of clients on Excel VBA, Python and Google Scripts projects.

Many clients have asked me for tutorials or walkthroughs of how I accomplish projects. I created this course to help make you more efficient, marketable and increase your earning potential! The combination of business and coding is very powerful. Yet, very few individuals have both skills. This course aims to bridge that gap.

I am also available for freelance coding projects at [email protected].

Pricing