Automation in Excel using Selenium framework
What you will learn
Learn how to install Selenium
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 automate sending emails, inserting data, copying data and saving it in Excel
Send emails with Attachments
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.
Content