Project Based Excel VBA with Business Examples

Project Based Excel VBA with Business Examples
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.78 GB | Duration: 5h 0mLearn Excel VBA quickly and efficiently with plenty of projects as practice

What you’ll learn
Write 10+ VBA programs to automate your daily tasks
Master VBA fundamentals
Create dynamic Excel templates
Send emails from Outlook and Gmail
Automate saving templates as PDFs
Interact with multiple Excel files
PDF form filling
Automate web browsers and Selenium
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
Requirements
Microsoft Excel
Description
This course is geared towards Excel users who want to increase their coding skills by learning real world business examples. If you have no coding experience, this course teaches the basics of VBA programming (loops, if statements, modules and more). Building onto this, you will learn how to create useful VBA programs to automate your daily tasks.

Projects covered:

Write 10+ VBA programs to automate your daily tasks

Master VBA syntax & fundamentals for beginners

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. Let’s begin!

Who this course is for:
Excel users looking to learn VBA coding, while learning real-world business examples
Business professionals who’d like to simplify & automate their work flow
For beginners, there is a fundamentals section
Data analysts and web scrapers