Learn Excel VBA with Real World Business Examples

Udemy Learn Excel VBA with Real World Business Examples

Register & Get access to index
iWb1Vdu.jpg


This course is for Excel users who want to increase their coding skills by learning real world examples.

What you'll learn​

  • Learn the fundamentals of Excel VBA coding
  • Create dynamic Excel templates (i.e. invoices, statements, notices, etc.)
  • Send emails with attachments from Outlook and Gmail
  • Automate saving templates as PDFs
  • Automate Internet Explorer and Chrome (using Selenium) for web tasks, form filling, data scraping
  • Interact with APIs & web scrape using HTTP requests
  • Interact with multiple Excel files
  • PDF form filling (i.e. tax documents, etc.)
  • Parse text in a PDF
  • Dynamically split and merge PDFs
  • Learn about HTML, JSON and XML
  • Loop through files in a folder
  • Mass rename or copy files
Show less


Requirements​

  • Familiarity with Microsoft Excel.
  • Demonstration is done with Excel 2016 but the techniques work with any version of Excel.
  • Excel on Windows (many techniques will work on mac, but I will not be able to support you).

Description​

This course is geared towards Excel users who want to increase their coding skills by learning real world examples. Whether you are a beginner or know how to code, this is a great & practical course for you!
Things you'll learn:
  • Learn the fundamentals of Excel VBA coding
  • Create dynamic Excel templates (i.e. invoices, statements, notices, etc.)
  • Automate saving templates as PDFs
  • Send emails with attachments from Outlook and Gmail
  • Automate Internet Explorer and Chrome (using Selenium) for web tasks, form filling, data scraping
  • Interact with APIs & web scrape using HTTP requests
  • Interact with multiple Excel files
  • PDF form filling (i.e. tax documents, etc.)
  • Parse text in a PDF
  • Dynamically split and merge PDFs
  • Learn about HTML, JSON and XML
  • Loop through files in a folder
  • Mass rename or copy files
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. Please see a few examples of what you'll learn in the course video.
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. Let's begin!

Who this course is for:​

  • Excel users looking to learn VBA coding, while learning real-world business examples
  • For beginners, there is a fundamentals section
  • Business professionals who'd like to simplify & automate their work flow
  • Data analysts and web scrapers
Author
TUTProfessor
Downloads
24
Views
505
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from TUTProfessor