Excel VBA Programming For Beginners: Quickly Learn To Code!

Automate Excel, dynamic templates, send emails, form filling, web scraping, Selenium. Master Microsoft Excel VBA!

4.60 (115 reviews)
Udemy
platform
English
language
Microsoft
category
4,248
students
5 hours
content
Jul 2022
last update
$84.99
regular price

What you will learn

Learn the fundamentals of VBA

Automate mundane Excel tasks

Create dynamic templates using Excel VBA

Automate filling out forms using Excel data

Send emails with attachments from Outlook and Gmail

Use Selenium for web automation and web scraping

Ping APIs to pull in large quantities of data into Excel

Using a single VBA script, populate and update several Excel files at the same time

Description

Everything you need to know in order to save time in Excel!

This course covers VBA fundamentals, automating mundane Excel tasks, creating dynamic templates, sending emails, form filling, and using Selenium for web scraping and web automation.

WHAT WILL YOU LEARN?

  • Learn the fundamentals of VBA

  • Automate mundane Excel tasks

  • Create dynamic Excel templates using Excel VBA

  • Automate filling out forms using Excel data

  • Send emails with attachments from Outlook and Gmail

  • Use Selenium for web automation and web scraping

  • Ping APIs to pull in large quantities of data into Excel

  • Using a single VBA script, populate and update several Excel files at the same time

  • And there's more...

This course will show you how to swiftly tackle complex VBA problems in Excel. The examples are all business-focused, so you can understand how to be more productive in the real world.

EXERCISE FILES AND Q&A

While watching the video lectures, you can download the exercise files that are included in each session. Put what you've learnt into practice using the exercise files.

As you improve your VBA skills, there is a Q&A part of the course where you may engage with me and ask any questions you have.

JOIN RIGHT NOW!

You will get the expertise and confidence to automate your Excel experience, saving you time and money, when you take this Excel VBA course.

Screenshots

Excel VBA Programming For Beginners: Quickly Learn To Code! - Screenshot_01Excel VBA Programming For Beginners: Quickly Learn To Code! - Screenshot_02Excel VBA Programming For Beginners: Quickly Learn To Code! - Screenshot_03Excel VBA Programming For Beginners: Quickly Learn To Code! - Screenshot_04

Content

Intro to VBA Programming and Excel Efficiency

Introduction
Adding the Developer Tab
Adding the Developer Tab Video
Modules and Subroutines
Modules and Subroutines Video
Declaring Variables, MsgBox and Debug.Print
Declaring Variables, MsgBox and Debug.Print Video
Operators
Operators Video
If Statements
If Statements Video
Interacting With Cells
Interacting With Cells Video
Loops (For, For Each, Do While)
Loops (For, For Each, Do While) Video
Built-in VBA Functions
Built-in VBA Functions Video
First Programming Exercise - Highlighting Cells
First Programming Exercise - Highlighting Cells Video
Using Worksheet Codenames in VBA
Using Worksheet Codenames in VBA Video
InputBox
InputBox Video
With Statement
With Statement Video
Object Variables - Early and Late Binding
Object Variables - Early and Late Binding Video
Functions
Functions Video
Excel Efficiency Tips
Excel Efficiency Tips Video - Index + Match
Excel Efficiency Tips Video - Re-grouping Rows Using Numbering and Filtering
Excel Efficiency Tips Video - Select and Delete Rows that have Blank Values
Excel Efficiency Tips Video - Using * in Formulas
Excel Efficiency Tips Video - Using SUMPRODUCT

Creating Dynamic Excel Templates Using VBA

Introduction
Index + Match Using a Unique ID
Index + Match Using a Unique ID Video
Automated Filtering
Automated Filtering Video

Looping Through the Template and Automated Saving to PDF

Introduction
Looping Through the Template
Looping Through the Template Video
Automated Save to PDF
Automated Save to PDF Video

Send PDF Templates as Email Attachments - Outlook and Gmail

Introduction
Send PDF Templates as Email Attachments - Outlook
Send PDF Templates as Email Attachments - Outlook Video
Send PDF Templates as Email Attachments - Gmail
Send PDF Templates as Email Attachments - Gmail Video

Automate Web Tasks, Web Form Filling, Web Data Scraping with Internet Explorer &

Introduction
Selenium Download Video
Let's discuss HTML
Let's discuss HTML Video
Web Inspector
Web Inspector Video
Automate Web Tasks, Web Form Filling, Web Data Scraping with Internet Explorer
Automate Web Tasks, Web Form Filling, Web Data Scraping with IE Video
Automate Web Tasks, Web Form Filling, Web Data Scraping w Selenium (i.e. Chrome)
Automate Web Tasks, Form Filling, Data Scraping w Selenium (i.e. Chrome) Video

Interact with APIs - JSON, XML, HTML

Introduction
How to Find a Website's API
How to Find a Website's API Video
Let's Discuss JSON
Let's Discuss JSON Video
Using an API Tester
Using an API Tester video
Downloading VBA Libraries, so We Can Work With JSON
Downloading VBA Libraries, so We Can Work With JSON Video
Grab JSON From an API, Then Parse the Data
Grab JSON From an API, Then Parse the Data video
Grab XML From an API, Then Parse the Data
Grab XML From an API, Then Parse the Data video
Grab HTML From a Website, Then Parse the Data (No Browser)
Grab HTML From a Website, Then Parse the Data (No Browser) Video
Grabbing Cookies From a Website
Grabbing Cookies From a Website Video

Interact with Multiple Excel Files

Introduction
Interact with Multiple Excel Files Video

Loop Through Files in a Folder, then Rename

Introduction
Loop Through Files in a Folder, then Rename Video

Fill in PDFs from Excel, Split PDFs, Merge PDFs

Introduction
Loop Through Text in a PDF File, Then Save a PDF Using a Found Word
Loop Through Text in a PDF File, Then Save a PDF Using a Found Word video
Merge PDFs via VBA
Merge PDFs via VBA video
Automate Fillable PDFs - Fill in 1099 Forms
Automate Fillable PDFs - Fill in 1099 Forms Video

Reviews

Cindy
April 17, 2022
I only knew a little about VBA before this course. After, I feel confident creating programs to save time at my job
Wesley
April 8, 2022
Very quick and informative course, I have only used Excel for 2 years and I have wrote multiple macros and condensed data that was spread wide out into quick overviews with all the good stuff in one place. Vba is a beast to learn and even more so learn how to use it to web scrape, the last step to alot of my projects was to be able to automate the copy and paste of associate data on webpages that require you to put in time and date before providing results especially intraday data (04/10 - 18:00 to 04/11 04:30) this course has given that insight needed to code that process and I'm excited to put the finishing touches on some files that provide the users the easy one click buttons needed for instant quality results.
Tiffany
February 16, 2022
Learned a lot about VBA starting as a beginner. Using this course, I was able to create automated Excel templates.
Anurag
September 23, 2021
This course exceeded my expectations! It is extremely well-planned with engaging materials. What impressed me the most about this course is the quality of the videos, the interesting case studies, case study materials and the timely response and solution offered by tutor (Yuri) to a query. I will give this course a full 5-star review because it deserves. Thanks Yuri :)
Johnny
September 9, 2021
The document portion of the course references places to “learn more about (*topic)” but they don’t work
Yachendra
September 7, 2021
As the instructor has asked for particular feedback, let me put it out. This course is not interactive at all. The least you can do is to welcome people to your course with a video rather than a text. You can speak more actively, you can teach this with more energy. Hope this helps for your future courses.
Pamela
August 3, 2021
Sending mass emails programmatically is going to save me a lot of time. We send a lot of invoices via email at my company
Joe
July 27, 2021
It's one thing to be able to learn VBA, but it's another to learn real examples of things I can use my in job.
Jessica
July 27, 2021
Having videos of each coding section makes it easier to follow what the VBA scripts are doing. Also, having comments on each line of code is a nice touch.

Charts

Price

Excel VBA Programming For Beginners: Quickly Learn To Code! - Price chart

Rating

Excel VBA Programming For Beginners: Quickly Learn To Code! - Ratings chart

Enrollment distribution

Excel VBA Programming For Beginners: Quickly Learn To Code! - Distribution chart

Coupons

DateDiscountStatus
9/8/2021100% OFF
expired
4203158
udemy ID
7/25/2021
course created date
8/19/2021
course indexed date
Bot
course submited by