Udemy - Learn Excel VBA With Real-World Business Examples torrent

Learn Excel VBA With Real-World Business Examples



MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 88 lectures (4h 59m) | Size: 1.53 GB
This course is for Excel users who want to increase their coding abilities with real-world examples
What you'll learn:
Learn the fundamentals of VBA coding in Excel
Learn about HTML, JSON and XML
Create dynamic Excel templates using VBA (i.e. invoices, investor statements, notices, etc.)
Interact with APIs
Automate web tasks, form filling, data scraping with Internet Explorer & Selenium (i.e. Chrome)
Automate saving templates as PDFs or Word files
Interact with multiple Excel files simultaneously
Automate file naming conventions
PDF form filling (i.e. 1099s, etc.)
Dynamically split and merge PDFs
Parse text in PDF files
Learn much more than just recording macros

Requirements
Familiarity with Microsoft Excel.
nstration is done with Excel 2016 but the techniques work with any version of Excel.
Excel on Windows (some techniques might work on mac, but I will not be able to support you).
The interacting with PDFs lessons require Adobe Acrobat. Even if you do not have Adobe Acrobat, I'd still recommend going through the lessons to learn what is possible via VBA.

Description
This course is geared towards Excel users who want to increase their coding skills by learning real-world examples you will use day-to-day. This course will not only make you more efficient, but can greatly increase your earning potential, as many professionals do not know how to code. Whether you are a beginner or know how to code, this is a great & practical course for you!

Learn the fundamentals of VBA coding in Excel