Classbaze

Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Complete Web Automation with Excel VBA

Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency!
4.3
4.3/5
(870 reviews)
6,657 students
Created by

9.6

Classbaze Grade®

10.0

Freshness

8.4

Popularity

9.7

Material

Fill Out Web Forms Dynamically
Platform: Udemy
Video: 10h 1m
Language: English
Next start: On Demand

Best Excel VBA classes:

Classbaze Rating

Classbaze Grade®

9.6 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness

10.0 / 10
This course was last updated on 6/2022.

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Popularity

8.4 / 10
We analyzed factors such as the rating (4.3/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Material

9.7 / 10
Video Score: 9.1 / 10
The course includes 10h 1m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 6 hours 20 minutes of 125 Excel VBA courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

13 articles.
28 resources.
0 exercise.
0 test.

In this page

About the course

Using a website has become part of everyday life in both work and play. Many of us spend hours a day scouring the web or filling out tedious forms online for work!
But what if we can automate these processes that steal our precious time away from us? Introducing “Complete Web Automation with Excel VBA” course. In this jam-packed, progressive course, I share over eight hours of secrets to using the popular website testing program called Selenium, ( previously only available using complicated web languages such as JavaScript or PHP). This free tool is now available to all Microsoft Excel users, but there’s very little documentation for how to use it unless you are a web developer.
Throughout the course, I take you through all the undocumented processes, enabling you to locate and interact with any element on a webpage using a variety of strategies, from basic text & attribute searches to Advanced strategies such as XPath, CSS Selectors, and Regular Expression (RegEx) functionalities.
You’ll learn how to fill out web forms dynamically, navigate web pages intuitively, and extract and manipulate data to increase efficiency.
Once you understand how to find an element (or group of elements), you’ll learn to evaluate whether elements are hidden, enabled or disabled, visible, selected, checked or unchecked, and then we’ll show you how to completely control mouse and keyboard commands and positioning. Then we’ll learn how and when to trigger macros with precision using “Timeouts and Waits”!
In addition to basic navigation, I’ll show you how to Open, Access and Toggle multiple tab Windows, how to resize, re-position and auto-scroll your browser window as well as use login techniques with set credentials. You’ll be able to deal with pop-ups, alerts, notifications and Frames like an expert. I’ll even show you the secrets of controlling the clipboard, saving screenshots to your Excel file or even taking all or parts of online tables into your spreadsheets automatically. Finally, I’ll take you through drop down menus and working with list boxes to complete your WebDriver mastery.
The course comes loaded with several examples in each section, including several engaging and challenging exercises to help you solidify what you’ve learned (with solution videos immediately following).
You’ll receive 100% of the source code, downloadable materials and course workbooks instantly, yours to keep FOREVER. In addition, you’ll receive LIFETIME ACCESS to the course videos, including updates, BONUS videos and lectures as they come out and any future source code and workbooks – Yours to keep – FREE.
All students will receive LIFETIME ACCESS to ask me any questions about the materials in the FORUM section – as well as chat with other students and help each other. As always, this is backed by a 30 day 100% No questions asked refund as well.
So Stop wasting your time with tedious online tasks when you can automate your online workflow Today!
Order “Complete Web Automation with Excel VBA” course Now!

What can you learn from this course?

✓ Locate elements using Basic Strategies (ID, Name, Tag, Class)
✓ Search for Links using Link Text or Partial Link Text!
✓ Master XPath Location strategies and functions for hard to pinpoint elements
✓ Deal with Popups, Alerts, Notifications and Frames like a boss!
✓ Utilize Attributes to unearth embedded content
✓ Pinpoint elements using Relative or Absolute Xpath
✓ Learn the secret benefits of CSS Selectors
✓ View and Parse inner html document information
✓ Use free extensions and tools to locate best Xpath or CSS Selectors
✓ Capture Groups of Elements into Arrays, Lists or Straight to Excel!
✓ Sort and Remove Duplicates from a List Object
✓ Locate all sub elements of a div, table, or larger parent element
✓ Determine if element Exists, is Enabled, Hidden, Selected, Checked or Unchecked
✓ Evaluate hidden CSS Properties, such as ‘width’, ‘background color’, etc
✓ Understand Regular Expression (RegEx) patterns and using pattern matching
✓ Get element Position and Size and Scroll element into View when necessary
✓ Create custom error messages to evaluate comparison (Equality, Contains, NotEquals, Matches, Fail…)
✓ Discern the difference between Assert and Verify operators
✓ Programmatically hover, click, click and hold, release, right click and double click with the Mouse
✓ Send Keyboard combination presses as well as regular word character presses to the browser
✓ Drag and Drop elements or text to another area or drag files for Upload programmatically
✓ Control Timeouts and Wait default settings for PageLoad, Element searches and Server timeouts
✓ Delay execution until controls are Visible, Enabled, Text is displayed or changed, Checkboxes/Optionbuttons are selected
✓ Wait for CSS special values change or meet conditions
✓ Log In using set credentials to site
✓ Test for the presence of Dialog popups
✓ Navigate with Basic Web Controls – Back, Forward, Reload, Close Driver, Close Single page, Urls
✓ Save and Load specific user profile for WebDriver execution
✓ Enter and Exit specific embedded Frame controls and their html content
✓ Open, Access and toggle multiple tabs/windows and Select by Index, Title or Window Handle
✓ Resize and Position Browser window to user specifications
✓ Save Screenshot of Browser, Web Element(s), or entire Desktop to Excel or to a file
✓ Copy Image directly to Excel OR to Clipboard
✓ Change image dimensions and resize
✓ Compare multiple image files, generating an image of differences
✓ Cast image elements into ActiveX Image Control on worksheet or Userform!
✓ Convert Web-Table into TableElement Object and manipulate as array or directly to Excel
✓ Extract specific Web-Table column(s) instead of whole table!
✓ Dynamically select one or more Dropdown or Listbox options programmatically or using mouse clicks
✓ Deselect all options or explore ‘Options’ collection and properties

What you need to start the course?

• You should already have Microsoft Excel (version 2003, 2007, 2010, 2013 or 2016). Obviously the newer the better, but VBA works the same in all versions. It’s just that newer versions have more options, thus more VBA Commands to control those options.
• Very very basic Excel skills needed for this course. IF you know Basic to Intermediate Excel VBA, you can surely find more ways to utilize this info, but is not required as I explain everything in detail.

Who is this course is made for?

• This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for controlling websites. No prior programming knowledge is needed.

Are there coupons or discounts for Complete Web Automation with Excel VBA ? What is the current price?

The course costs $17.99. And currently there is a 82% discount on the original price of the course, which was $99.99. So you save $82 if you enroll the course now.
The average price is $16.6 of 125 Excel VBA courses. So this course is 8% more expensive than the average Excel VBA course on Udemy.

Will I be refunded if I'm not satisfied with the Complete Web Automation with Excel VBA course?

YES, Complete Web Automation with Excel VBA has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any financial aid for this course?

Currently we could not find a scholarship for the Complete Web Automation with Excel VBA course, but there is a $82 discount from the original price ($99.99). So the current price is just $17.99.

Who will teach this course? Can I trust Daniel Strong?

Daniel Strong has created 10 courses that got 17,454 reviews which are generally positive. Daniel Strong has taught 131,940 students and received a 4.5 average review out of 17,454 reviews. Depending on the information available, we think that Daniel Strong is an instructor that you can trust.
Excel Instructor/Programmer
Hi! My name is Daniel and i’m 31. I’ve lived most my life in Missouri, United States. I’ve been using Excel since my early teens, and very early on realized that I absolutely love it. After working on various projects in my spare time for years, improving the lives of those that used my programs, I knew this was more than just a hobby for me; it’s my passion. A few years back, I got my first opportunity to program in Excel, but when I landed the job I was asked to re-write my predecessor’s coded programs with fancy databases and automated Crystal reports! I found my Excel skills somewhat lacking. I HAD TO LEARN VBA! I studied and studied what I could online and in books, but I wasn’t able to learn much that way. I had to dive into my first project for months and months – basically just teaching myself and “figuring it out”. I realized that if only someone was out there teaching Excel VBA like Mike Girvin (ExcelIsFun) taught Excel, making everything simple and visual – then Anyone could learn VBA! I started a YouTube channel, mostly for myself as a reference tool, but people started to bite. People flooded my inbox with questions and comments that I was literally changing their lives for the better. My passion is and always has been teaching, and I’ve turned thousands of people into Excel programmers. Now, with Udemy, I’m going to teach the good stuff – the stuff I kept secret; the Advanced and “not-so-Advanced-but-Awesome” Excel VBA. The things that make people hire you – that make you irresistable and irreplacable. Building REAL Programs, Advanced Reporting and Data Analysis. Dashboards and live data. Automation. My main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems and change Real Lives.
Browse all courses by on Classbaze.

9.6

Classbaze Grade®

10.0

Freshness

8.4

Popularity

9.7

Material

Platform: Udemy
Video: 10h 1m
Language: English
Next start: On Demand

Classbaze recommendations for you