Complete Web Automation with Excel VBA from Udemy

What's inside

Learning objectives

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
Show more
Show less

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
Show more
Show less

Syllabus

Introduction - Getting Started & Setup

Introduction to the course and Downloadable files.

*See why Selenium is a gazillion times better than traditional ways of controlling web sites.

Getting FAST Help and Other Freebies with Excel Ninjas Group

Here's how to get set up with Selenium with Excel.

This document is to help those who have had trouble after attempting the installation. These tips will get you patched up and on your way!

Basic Control of a New Instance of Your Browser

Opening a Web Page with Multiple Browsers (2 Methods)

Web Elements 101 - Type in Textbox and Click Search Button (ID,Name Selectors)

HTML Overview - Popular Tags and Attributes

Strategies - "Tag"

Awful-Valentine Site Expired, But We Downloaded It!

Strategies - "Class"

Exercise 02a - Question

Exercise 02a - Answer

Strategies - "LinkText"

Looking At Attributes - More Than Just TEXT!

Strategies - "PartialLinkText"

Strategies - "CSS Selectors" Intro

How to Install a Chrome Extension

CSS Selector Helper for Chrome

CSS Selector Tool - ChroPath and Technical Demonstration

BONUS - ChroPath Serious Upgrades - Now Called SelectorsHub

BONUS - Set Value versus SendKeys To TextBox

BONUS - Create or Change Any Attribute Using Javascript

BONUS - New Change Attribute Custom Function and Huge Demo

Set Attributes With JavaScript Easily!

Advanced Find With XPath

Introduction to XPath

XPath Helper Tool

ChroPath with XPath for Relative and Absolute Reference Types

XPath Function - Contains()

XPath Function - Text()

XPath Function - AND, OR

XPath Function - Starts-With()

XPath - Axes

XPath Function - Last()

Selecting a Specific Index for XPath Query!

Exercise 03a - Question

Exercise 03a - Answer

More XPath Resources

Selenium VBA Code Snippets - Chapter 1-3

Working With Multiple Elements At Once

Working With a Group Of Elements (FindElements)

Looping Through a Set of Elements, Declaration Tips

Grab the Text For Each Element Into A List

Grabbing All Attribute Values into a List

Add, Remove or Change an Element from a List

Get Count of List Items or Web Elements

Remove Duplicates Elements from List

Sorting Your List

Importing Items to Excel Directly!

Looping Through a List of Attributes for a Set of Elements

Wikipedia, get all links, then visit the 10th link after sorting

Wikipedia, get all links, then visit the 10th link after sorting!

Finding Elements within an Element

You've Found the Element! Now What?

Find the Active Element

Understanding the 'By' Object

Does The Element Exist Using 'By' Object

Does Element Exist Using WebElement Object (2 Ways!)

Value, Tagname, Text & Css Properties

Specialty Text Variations

Discover Whether Element is Displayed, Enabled, Present, Selected...

Pagination - Clicking Next Until You Reach the Last Page

Element Position and Size

Scrolling Element Into View

Regular Expression Patterns!

Return Text Based on Regular Expression (RegEx)

Automatically Download File to Custom Folders with SetPreference()

SetPreference Extra example!

Built In Comparison Operators

Assert vs Verify

Equals Comparison Operator

Not Equals

Contains

Custom Error Messages

Matches & NotMatches

Fail, False and True

Selenium VBA Code Snippets - Chapter 4-6

Control Clicks and Keystrokes Like a Boss!

Click, Click and Hold, Release, Right Click & Double Click

SendKeys and Keys Modifiers

KeyDown, KeyUp

Exercise 07a - Question

Exercise 07a - Answer

DragAndDrop - Swapping Elements, Better with JavaScript

DragAndDrop - Element Disappears Once Dropped

DragAndDrop - Dragging Text Programmatically

DragAndDrop - Dragging File for Upload Programmatically

Hover MenuItem and Click On Submenu Item

Clear Out Text Entry Element

Timeouts and Waits

TimeOuts and Wait DEFAULTS

Basic Wait Command

Exercise 08a - Question

Exercise 08a - Answer

Finding Elements With a Custom TimeOut Duration

Wait Until Element is Displayed

Wait For Specific Text or a Specific Attribute to Appear!

Wait For CSS Special Value to Appear or Change

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches web automation using Microsoft Excel VBA, a tool not often used for this purpose

Ideal for individuals with an intermediate understanding of Excel and a desire to expand their automation skills

Suitable for professionals who frequently engage in repetitive online tasks and seek to enhance their efficiency

Provides learners with hands-on lab exercises to solidify their understanding and reinforce the lessons learned

Emphasizes locating and manipulating web elements using a variety of strategies, providing learners with a comprehensive approach to web automation

Might require additional prerequisite knowledge in some advanced topics such as XPath and Regular Expressions, which could pose a challenge for complete beginners

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Complete Web Automation with Excel VBA with these activities:

Activate Microsoft Excel

Show steps

Ensure that you have a deep understanding of locating and utilizing basic Excel functions, including the formula builder.

Browse courses on Microsoft Excel

Show steps

Open Microsoft Excel
Locate and open the Formula Builder
Practice using basic Excel functions, such as SUM, AVERAGE, and COUNT

Excel VBA Programming Basics

Show steps

Develop a strong foundation in Excel VBA programming to prepare for the complex concepts covered in the course.

Browse courses on Excel VBA

Show steps

Create a new VBA module in Excel
Write simple VBA code to perform basic tasks, such as displaying messages and manipulating data
Debug and test your VBA code

Selenium WebDriver Tutorial

Show steps

Gain a comprehensive understanding of Selenium WebDriver's capabilities for web automation, setting you up for success in the course.

Browse courses on Selenium WebDriver

Show steps

Follow a structured tutorial on Selenium WebDriver
Build a basic web automation script using Selenium WebDriver

Three other activities

Expand to see all activities and additional details

Show all six activities

XPath Practice Exercises

Show steps

Refine your ability to locate web elements using XPath, ensuring accurate and efficient automation scripts.

Browse courses on Xpath

Show steps

Solve a series of XPath practice exercises
Apply XPath expressions in your own web automation scripts

Web Automation Project

Show steps

Put your skills to the test by developing a comprehensive web automation project that automates a real-world scenario, solidifying your learning.

Browse courses on Web Automation

Show steps

Define the scope and objectives of your project
Design and implement your web automation solution using Selenium WebDriver
Test and refine your project to ensure accuracy and efficiency

Contribute to Selenium WebDriver

Show steps

Deepen your understanding of Selenium WebDriver's inner workings by contributing to its open-source project, fostering collaboration and enhancing your knowledge.

Browse courses on Selenium WebDriver

Show steps

Identify potential areas for contribution within the Selenium WebDriver project
Propose a change or feature to the Selenium WebDriver community
Implement and test your contribution

Career center

Learners who complete Complete Web Automation with Excel VBA will develop knowledge and skills that may be useful to these careers:

Web Developer

A Web Developer uses a variety of programming languages and web technologies to design and create websites. The Complete Web Automation with Excel VBA course from [website name] can help you get started in this field by teaching you the basics of web development, including HTML, CSS, and JavaScript. You'll also learn how to use Selenium, a popular web automation tool, to test and debug websites.

See salaries and explore the career path for Web Developer

Quality Assurance Analyst

A Quality Assurance Analyst tests software and websites to ensure that they meet quality standards. The Complete Web Automation with Excel VBA course from [website name] can be useful for those interested in becoming a Quality Assurance Analyst. The course will teach you how to use Selenium, a popular web automation tool, to test and debug websites.

See salaries and explore the career path for Quality Assurance Analyst

Web Designer

A Web Designer creates the visual layout and user interface for websites. The Complete Web Automation with Excel VBA course from [website name] can be useful for those interested in becoming a Web Designer. The course will teach you the basics of web design, including HTML, CSS, and JavaScript.

See salaries and explore the career path for Web Designer

Software Engineer

A Software Engineer designs, builds, and tests computer software. The Complete Web Automation with Excel VBA course from [website name] can be useful for those interested in becoming a Software Engineer. The course will help you build a foundation in web development and teach you how to use Selenium, a popular web automation tool.

See salaries and explore the career path for Software Engineer

IT Support Specialist

An IT Support Specialist provides technical support to users of computer systems and software. The Complete Web Automation with Excel VBA course from [website name] can be useful for those interested in becoming an IT Support Specialist. The course will teach you the basics of web development and how to use Selenium, a popular web automation tool.

See salaries and explore the career path for IT Support Specialist

Data Analyst

A Data Analyst collects, processes, and analyzes data to identify trends, patterns, and insights. The Complete Web Automation with Excel VBA course from [website name] can be useful for those interested in becoming a Data Analyst. The course will teach you how to use Excel VBA to automate data collection and analysis tasks, which can save you time and improve your efficiency.

See salaries and explore the career path for Data Analyst

Business Analyst

A Business Analyst analyzes business processes and systems to identify opportunities for improvement. The Complete Web Automation with Excel VBA course from [website name] can be useful for those interested in becoming a Business Analyst. The course will teach you the basics of web development and web automation, which can help you better understand how businesses use technology.

See salaries and explore the career path for Business Analyst

Project Manager

A Project Manager plans, organizes, and executes projects. The Complete Web Automation with Excel VBA course from [website name] can be useful for those interested in becoming a Project Manager. The course will teach you how to use Excel VBA to automate project management tasks, which can save you time and improve your efficiency.

See salaries and explore the career path for Project Manager

Data Scientist

A Data Scientist uses statistical and computational methods to analyze data and extract insights. The Complete Web Automation with Excel VBA course from [website name] can be useful for those interested in becoming a Data Scientist. The course will teach you how to use Excel VBA to automate data collection and analysis tasks, which can help you save time and improve your efficiency.

See salaries and explore the career path for Data Scientist

Systems Analyst

A Systems Analyst designs, implements, and maintains computer systems. The Complete Web Automation with Excel VBA course from [website name] can be useful for those interested in becoming a Systems Analyst. The course will teach you the basics of web development and web automation, which can help you better understand how computer systems work.

See salaries and explore the career path for Systems Analyst

Computer Support Specialist

A Computer Support Specialist provides technical support to users of computer systems and software. The Complete Web Automation with Excel VBA course from [website name] may be useful for those interested in becoming a Computer Support Specialist.

See salaries and explore the career path for Computer Support Specialist

Technical Writer

A Technical Writer creates and maintains technical documentation. The Complete Web Automation with Excel VBA course from [website name] may be useful for those interested in becoming a Technical Writer.

See salaries and explore the career path for Technical Writer

Database Administrator

A Database Administrator manages and maintains databases. The Complete Web Automation with Excel VBA course from [website name] may be useful for those interested in becoming a Database Administrator.

See salaries and explore the career path for Database Administrator

Network Administrator

A Network Administrator manages and maintains computer networks. The Complete Web Automation with Excel VBA course from [website name] may be useful for those interested in becoming a Network Administrator.

See salaries and explore the career path for Network Administrator

Information Security Analyst

An Information Security Analyst protects computer systems and networks from unauthorized access and use. The Complete Web Automation with Excel VBA course from [website name] may be useful for those interested in becoming an Information Security Analyst.

See salaries and explore the career path for Information Security Analyst