We may earn an affiliate commission when you visit our partners.
Course image
Daniel Strong

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.

Read more

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

All students will receive 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.

Enroll now

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

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.

Read more
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

Save this course

Save Complete Web Automation with Excel VBA to your list so you can find it easily later:
Save

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
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
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
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
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
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.

Reading list

We've selected nine books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Complete Web Automation with Excel VBA.
Is perfect for those looking to automate web testing with Selenium WebDriver. It covers all the basic concepts of WebDriver and takes you through a series of practical, hands-on exercises. It good reference book for the course.
Great resource for those who want to learn how to use Selenium for web testing. It covers all the basics of Selenium, as well as how to use it for testing a variety of web applications.
Comprehensive guide to web automation with Selenium WebDriver. It covers everything from the basics of WebDriver to advanced topics such as working with different browsers, handling dynamic web elements, and using WebDriver with different programming languages. A more useful as additional reading than as a current reference.
A comprehensive and well-respected guide to software testing that covers a wide range of topics including test planning, test design, and test execution.
A classic guide to writing effective Java code that provides a wealth of practical advice and best practices.
A comprehensive and easy-to-follow guide to Java programming that is suitable for beginners and experienced programmers alike.
A beginner-friendly introduction to Java programming that provides a solid foundation for understanding the concepts of object-oriented programming.
Great way to learn the basics of Java. It is written in a fun and engaging style, and it covers all the essential concepts of Java. A useful reference tool.
Provides a cookbook of recipes for Selenium WebDriver with C#. It covers topics such as setting up your environment, writing automated tests, and debugging tests. The book also includes a number of examples to help readers get started with Selenium.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Complete Web Automation with Excel VBA.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser