Share Description
In this course, you will :
- Discover how to use Excel VBA can be used for a variety of tasks other than Excel.
- By the end of the course, you will have all of the scripts and knowledge needed to build VBA programmes from the ground up.
- Learning how to write VBA code will enable you to automate many Excel tasks, saving you time.
Syllabus :
- 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
