What you'll learn

Master Excel VBA fundamentals - modules, functions, loops, if statements, sub routines and more

Write 10+ VBA business programs from start to finish

Learn how VBA can interact with Excel, sending emails, automate web browsers, web scraping, PDF form filling and more

Automate your work with Excel VBA and save

Learn real VBA code that I've used as a CPA accountant and programmer

Reduce manual routine tasks to the click of a button

Description

My name is Yuri. I have been a CPA accountant and programmer for over seven years. This course teaches you VBA programming using business examples. The course starts with a VBA fundamentals section for bners. You'll master modules, functions, loops, if statements, sub routines and more. Building on the fundamentals, you'll write 10+ VBA programs from scratch.

VBA programs you'll write

Create dynamic Excel templates - Automatically hide / un-hide rows. Instantly feed in new data

Automate saving templates as PDFs - Your program will save PDFs into a folder that you specify

Send emails with attachments - Send emails from both Outlook and Gmail

Automate web tasks - Automate Internet Explorer and Chrome to fill in web forms, click buttons, loop webpages, extract data

Interact with APIs & web scrape - Ping an API, retrieve web data and parse information into Excel. No browser required

Interact with multiple Excel files - Open and update separate Excel files from your program

Loop through files in a folder - Learn two techniques to loop through files in a folder

Mass rename or copy files - Rename or copy files in bulk

PDF form filling - Complete fillable PDF forms using Excel data

Parse text in a PDF - Find words in a PDF file

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

Many employers will reimburse continuing education courses. Let's b!

Who this course is for:

Excel users looking to learn VBA coding, while learning real-world business examples

For bners, there is a fundamentals section

Business professionals who'd like to simplify & automate their work flow

Data analysts and web scrapers




DOWNLOAD
uploadgig.com


rapidgator.net


ddownload.com