Learn VBA to automate Excel, dynamic templates, send emails, automate web browsers, PDF form filling and more
What you’ll learn
-
Learn Excel VBA coding fundamentals (loops, if statements, modules and more)
-
Create dynamic Excel templates using VBA (invoices, statements, notices, etc.)
-
Automate web scraping & web tasks with Chrome, Selenium and Internet Explorer
-
Send emails from Outlook and Gmail with attachments
-
Automate saving numerous Excel templates as PDF or Word files
-
Populate and update multiple Excel files using a single VBA script
-
PDF form filling (tax forms, etc.)
-
Pull data from web APIs into Excel
-
Dynamically split and merge PDF files
-
Automate file naming conventions
-
Learn about HTML, JSON and XML
-
Learn much more than just recording macros
Requirements
-
Familiarity with Microsoft Excel.
-
Demonstration is done with Excel 2016 but the techniques work with any version of Excel.
Description
Take your Excel skills to the next level by learning VBA coding. Become more productive and efficient!
- Write 10+ VBA programs to automate your daily tasks
- Learn VBA fundamentals & syntax (loops, if statements, modules and more)
- Create dynamic Excel templates
- Automate saving numerous Excel templates as PDF or Word files
- Send emails with attachments from Outlook and Gmail
- Automate Chrome & Internet Explorer (using Selenium) for web tasks & web scraping
- Populate and update multiple Excel files using a single VBA script
- PDF form filling
- Pull data from web APIs into Excel
- 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
These are real VBA coding examples that I use daily as a CPA accountant and with hundreds of clients. 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.
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 Excel. By the end of the course, you will have all of the scripts and knowledge to implement VBA programs from scratch.
Don’t spend another minute performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to work for you.
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
Created by Yuri Douglas, CPA
Last updated 9/2021
English
English [Auto]
Size: 1.60 GB
https://www.udemy.com/course/excel-vba-from-beginner-to-hero-real-world-business-examples/.