Selenium Automation in Excel

Name: Selenium Automation in Excel
Rating: 4.2 (12 reviews)

Automation in Excel using Selenium framework

Created byDaniel Andrei

Last updated 8/2023

English

What you'll learn

Learn how to install Selenium
Learn Selenium framework in Excel.
Learn how to automate sending emails, inserting data, copying data and saving it in Excel
Send emails with Attachments

Course content

2 sections • 9 lectures • 1h 4m total length

Introduction and installation of Selenium6:59
Learn what is Selenium framework, how it works and how to download the resources needed to make Selenium work on your machine.
Chrome Version 115 - Announcement & Update2:57
There has been a change done to chrome browser, there is a new chrome browser only for automated testing and in this video I am going to show how to update your files to make your existing scripts work.

Google page - Part 19:24
In this lecture we will learn how to use Selenium:
How to open a browser
How to load a page in this case google.com
How to maximise the browser window
What happens when you access a page
How to access the source code of a page
How to make Selenium wait until a page loads before clicking on a element.
How to find elements and how to copy their ids, class or xpath
How to write Selenium code to find elements using the copied ids or class, or xpath and click on them.
Click on a cookie button and input text into google search engine.
Submit the search by clicking on Search button.
Amazon page - Part 28:31
In this lecture we will learn how to optimise our code to better use what Selenium has to offer and:
Learn by a real world example using the Amazon.com website
Using Selenium feature find by partial link text to click on a link to the Amazon page.
Amazon page - Part 312:09
Learn how to use Selenium with drop downs in Amazon page and how to do problem solving to achieve our target.
Amazon Page - Part 4 Copy Product Name and Price and paste it into a cell5:11
In this lesson we will get the text from a book sold on Amazon page and the price and paste it into a cell in Excel.
Gmail Emails - Part 19:09
Learn how to create a dynamic list of emails addresses to be sent via gmail.com in Excel using Selenium.
Gmail Emails Send Emails with attachments - Part 26:05
Console Selectors3:37

Requirements

No programming knowledge is needed all will be explained.

Description

Hello my name is Daniel Andrei and I will be your instructor for this Selenium course. I have graduated with a Bachelors degree in Software Engineering from England where I have studied different programming languages. I have a passion for IT and customer service.

In this course I will be teaching you how to use Selenium in Excel VB using real life examples and walking you step by step through the code I will also be explaining each VB code that we will be using so if you are a beginner this course is perfect for you.

What is Selenium?

Selenium is a open source automated testing framework, with it you can automate tasks in the browser, we will be using it in Excel VB.

Selenium supports different browsers but in this course we will use Chrome.

What you’ll learn

Learn Selenium framework in Excel.
Learn fundamentals of VBA: accessing cell values, inserting data into cells, forms, for loops, if statements, while loops.
Learn how to install Selenium
Learn how to automate sending emails with attachments, inserting data, copying data and saving it in Excel
Create interactive forms using VBA that make it easier to automate tasks in the browser.

Who this course is for:

People that want to learn about automation in Excel using Selenium framework with real life examples.

Selenium Automation in Excel

What you'll learn

Explore related topics

Course content

Introduction2 lectures • 10min

Selenium Fundamentals with Real Life Examples7 lectures • 54min

Requirements

Description

Who this course is for: