330 already collected.
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 knowledge of programming to learn the basics of programming, while at the same time learning how to create useful macros with VBA in Excel.
Learn the fundamentals of Excel VBA coding
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 Excel users to automate many tasks in Excel, saving you time in the long run. Let's begin!
Udemy online courses start at $11.99
Top courses from $13.99 when you first visit Udemy.