Complete Web Automation with Excel VBA (Udemy.com)
Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency!
Created by: Daniel Strong
Produced in 2021
What you will learn
- 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 (R
Quality Score
Overall Score : 94 / 100
Course Description
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 theres 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.
Youll 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 well 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).
Youll receive 100% of the source code, downloadable materials and course workbooks instantly, yours to keep FOREVER. In addition, youll 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!
Who this course is 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.
Instructor Details
- 4.7 Rating
134 Reviews
Daniel Strong
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 - tha
More courses by Daniel Strong
More excel courses
Excel Dynamic Arrays - Beginner to Expert (Microsoft 365) (2021)
4.9 (216 Reviews)
Provider: Udemy
Time: 7h
$11.99
Visually Stunning Microsoft Excel Dynamic Dashboard Course (2021)
4.9 (193 Reviews)
- Provider: Udemy
- Time: 7h
$11.99
Microsoft Excel Complete Excel Guide (Excel 2007 2021) (2021)
4.9 (62 Reviews)
- Provider: Udemy
- Time: 21h
$11.99
Reviews
- Video Duration:
9.5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
