This site is powered by
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Project Based Excel VBA Course with Business Examples
Quick Course Introduction
Welcome to the Course and Course Structure (1:20)
Intro to VBA Programming and Excel Efficiency
Video 1: Adding The Developer Tab (0:45)
Video 2: Modules And Subroutines (3:56)
Video 3: Declaring Variables, MsgBox And Debug.Print (7:38)
Video 4: Operators (7:06)
Video 5: If Statements (4:48)
Video 6: Interacting With Cells (6:02)
Video 7: Loops (For, For Each, Do While) (7:32)
Video 8: Built-In VBA Functions (4:58)
Video 9: First Programming Exercise - Highlighting Cells (5:01)
Video 10: Using Worksheet Codenames In VBA (3:54)
Video 11: InputBox (2:32)
Video 12: With Statement (2:40)
Video 13: Object Variables - Early And Late Binding (5:16)
Video 14: Functions (9:31)
Videos 15, 16, 17, 18 & 19: Excel Efficiency Tips
Video 15: Excel Efficiency Tips - Index + Match (5:21)
Video 16: Excel Efficiency Tips - Re-grouping Rows Using Numbering and Filtering (1:55)
Video 17: Excel Efficiency Tips - Select and Delete Rows that have Blank Values (2:47)
Video 18: Excel Efficiency Tips - Using * in Formulas (2:22)
Video 19: Excel Efficiency Tips - Using SUMPRODUCT (4:34)
Creating Dynamic Excel Templates Using VBA
Video 20: Index + Match Using A Unique ID (2:53)
Video 21: Automated Filtering (8:03)
Looping Through the Template and Automated Saving to PDF
Video 22: Looping Through The Template (4:38)
Video 23: Automated Save To PDF (5:15)
Send PDF Templates as Email Attachments - Outlook and Gmail
Video 24: Send PDF Templates As Email Attachments - Outlook (10:30)
Video 25: Send PDF Templates As Email Attachments - Gmail (6:51)
Automate Web Tasks, Web Form Filling, Web Data Scraping with IE & Chrome
Video 26: Selenium Download (2:43)
Video 27: Let's Discuss HTML (6:23)
Video 28: Web Inspector (2:16)
Video 29: Automate Web Tasks, Web Form Filling, Web Data Scraping With IE (13:45)
Video 30: Automate Web Tasks, Web Form Filling, Web Data Scraping With Chrome (10:12)
Interact with APIs - JSON, XML, HTML (Foundations of Web Scraping)
Video 31: How To Find A Website's API (4:56)
Video 32: Let's Discuss JSON (6:13)
Video 33: Using An API Tester (4:43)
Video 34: Downloading VBA Libraries, So We Can Work With JSON (2:13)
Video 35: Grab JSON From An API, Then Parse The Data (12:05)
Video 36: Grab XML From An API, Then Parse The Data (9:23)
Video 37: Grab HTML From A Website, Then Parse The Data (No Browser) (5:44)
Video 38: Grabbing Cookies From A Website (7:34)
Interact with Multiple Excel Files
Video 39: Interact With Multiple Excel Files Video (6:04)
Loop Through Files in a Folder, then Rename
Video 40: Loop Through Files In A Folder, Then Rename Video (6:25)
Fill in PDFs from Excel, Split PDFs, Merge PDFs
Video 41: Loop Through Text In A PDF File, Then Save A PDF Using A Found Word (6:27)
Video 42: Merge PDFs Via VBA (5:16)
Video 43: Automate Fillable PDFs - Fill In 1099 Forms (4:58)
Video 22: Looping Through The Template
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock