Learn Excel VBA with Real World Business Examples

Learn Excel VBA with Real World Business Examples

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 5 Hours | 1.77 GB

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

Hello! My name is Yuri. I have been a CPA accountant and programmer for over seven years. This course teaches you VBA programming using business examples. The course starts with a VBA fundamentals section for beginners. You’ll master modules, functions, loops, if statements, sub routines and more. Building on the fundamentals, you’ll write 10+ VBA programs from scratch.

VBA programs you’ll write

  • Create dynamic Excel templates – Automatically hide / un-hide rows. Instantly feed in new data
  • Automate saving templates as PDFs – Your program will save PDFs into a folder that you specify
  • Send emails with attachments – Send emails from both Outlook and Gmail
  • Automate web tasks – Automate Internet Explorer and Chrome to fill in web forms, click buttons, loop webpages, extract data
  • Interact with APIs & web scrape – Ping an API, retrieve web data and parse information into Excel. No browser required
  • Interact with multiple Excel files – Open and update separate Excel files from your program
  • Loop through files in a folder – Learn two techniques to loop through files in a folder
  • Mass rename or copy files – Rename or copy files in bulk
  • PDF form filling – Complete fillable PDF forms using Excel data
  • Parse text in a PDF – Find words in a PDF file

Every line of code in the course includes comments, so you’re not left guessing. Also, a video is included for every coding section.

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
Table of Contents

Intro to VBA Programming and Excel Efficiency
1 Introduction
2 Lesson 1 Adding The Developer Tab
3 Video 1 Adding The Developer Tab
4 Lesson 2 Modules And Subroutines
5 Video 2 Modules And Subroutines
6 Lesson 3 Declaring Variables, MsgBox And Debug.Print
7 Video 3 Declaring Variables, MsgBox And Debug.Print
8 Lesson 4 Operators
9 Video 4 Operators
10 Lesson 5 If Statements
11 Video 5 If Statements
12 Lesson 6 Interacting With Cells
13 Video 6 Interacting With Cells
14 Lesson 7 Loops (For, For Each, Do While)
15 Video 7 Loops (For, For Each, Do While)
16 Lesson 8 Built-In VBA Functions
17 Video 8 Built-In VBA Functions
18 Lesson 9 First Programming Exercise – Highlighting Cells
19 Video 9 First Programming Exercise – Highlighting Cells
20 Lesson 10 Using Worksheet Codenames In VBA
21 Video 10 Using Worksheet Codenames In VBA
22 Lesson 11 InputBox
23 Video 11 InputBox
24 Lesson 12 With Statement
25 Video 12 With Statement
26 Lesson 13 Object Variables – Early And Late Binding
27 Video 13 Object Variables – Early And Late Binding
28 Lesson 14 Functions
29 Video 14 Functions
30 Video 15, 16, 17, 18 & 19 Excel Efficiency Tips
31 Video 15 Excel Efficiency Tips – Index + Match
32 Video 16 Excel Efficiency Tips – Re-grouping Rows Using Numbering and Filtering
33 Video 17 Excel Efficiency Tips – Select and Delete Rows that have Blank Values
34 Video 18 Excel Efficiency Tips – Using in Formulas
35 Video 19 Excel Efficiency Tips – Using SUMPRODUCT

Creating Dynamic Excel Templates Using VBA
36 Introduction
37 Lesson 20 Index + Match Using A Unique ID
38 Video 20 Index + Match Using A Unique ID
39 Lesson 21 Automated Filtering
40 Video 21 Automated Filtering

Looping Through the Template and Automated Saving to PDF
41 Introduction
42 Lesson 22 Looping Through The Template
43 Video 22 Looping Through The Template
44 Lesson 23 Automated Save To PDF
45 Video 23 Automated Save To PDF

Send PDF Templates as Email Attachments – Outlook and Gmail
46 Introduction
47 Lesson 24 Send PDF Templates As Email Attachments – Outlook
48 Video 24 Send PDF Templates As Email Attachments – Outlook
49 Lesson 25 Send PDF Templates As Email Attachments – Gmail
50 Video 25 Send PDF Templates As Email Attachments – Gmail

Automate Web Tasks, Web Form Filling, Web Data Scraping with IE & Chrome
51 Introduction
52 Video 26 Selenium Download
53 Lesson 27 Let’s Discuss HTML
54 Video 27 Let’s Discuss HTML
55 Lesson 28 Web Inspector
56 Video 28 Web Inspector
57 Lesson 29 Automate Web Tasks, Web Form Filling, Web Data Scraping With IE
58 Video 29 Automate Web Tasks, Web Form Filling, Web Data Scraping With IE
59 Lesson 30 Automate Web Tasks, Web Form Filling, Web Data Scraping With Chrome
60 Video 30 Automate Web Tasks, Web Form Filling, Web Data Scraping With Chrome

Interact with APIs – JSON, XML, HTML (Foundations of Web Scraping)
61 Introduction
62 Lesson 31 How To Find A Website’s API
63 Video 31 How To Find A Website’s API
64 Lesson 32 Let’s Discuss JSON
65 Video 32 Let’s Discuss JSON
66 Lesson 33 Using An API Tester
67 Video 33 Using An API Tester
68 Lesson 34 Downloading VBA Libraries, So We Can Work With JSON
69 Video 34 Downloading VBA Libraries, So We Can Work With JSON
70 Lesson 35 Grab JSON From An API, Then Parse The Data
71 Video 35 Grab JSON From An API, Then Parse The Data
72 Lesson 36 Grab XML From An API, Then Parse The Data
73 Video 36 Grab XML From An API, Then Parse The Data
74 Lesson 37 Grab HTML From A Website, Then Parse The Data (No Browser)
75 Video 37 Grab HTML From A Website, Then Parse The Data (No Browser)
76 Lesson 38 Grabbing Cookies From A Website
77 Video 38 Grabbing Cookies From A Website

Interact with Multiple Excel Files
78 Introduction
79 Video 39 Interact With Multiple Excel Files Video

Loop Through Files in a Folder, then Rename
80 Introduction
81 Video 40 Loop Through Files In A Folder, Then Rename Video

Fill in PDFs from Excel, Split PDFs, Merge PDFs
82 Introduction
83 Lesson 41 Loop Through Text In A PDF File, Then Save A PDF Using A Found Word
84 Video 41 Loop Through Text In A PDF File, Then Save A PDF Using A Found Word
85 Lesson 42 Merge PDFs Via VBA
86 Video 42 Merge PDFs Via VBA
87 Lesson 43 Automate Fillable PDFs – Fill In 1099 Forms
88 Video 43 Automate Fillable PDFs – Fill In 1099 Forms

Homepage