Latest Courses
Python programming Bible - From Beginner to AdvancedCheck course
Learn Pro Advanced Python ProgrammingCheck course
Javascript Certification practice using HTML5 , HTML, CSS3Check course
JavaScript for BeginnersCheck course
Data Science, Deep Learning and Machine Learning with PythonCheck course
Learning Path: Java: Natural Language Processing with JavaCheck course
Cloud Migration on AWS and Microsoft AzureCheck course
Cyber Security: Mastering Linux SecurityCheck course
Data Science:Hands-on Covid-19 Data Analysis & VisualizationCheck course
Python programming Bible - From Beginner to AdvancedCheck course
Learn Pro Advanced Python ProgrammingCheck course
Javascript Certification practice using HTML5 , HTML, CSS3Check course
JavaScript for BeginnersCheck course
- 86% Complete Web Automation with Excel VBA

Complete Web Automation with Excel VBA

$94.99 $12.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare
8.5/10 (Our Score)
Product is rated as #16 in category Excel

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 !

Instructor Details

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 ot-so-Advanced-but-Awesome Excel VBA. The things that make people hire you - that make you irresistable and irreplacable. Building REAL Programs, Advanced Reporting and Data Analysis. Dashboards and live data. Automation. My main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems and change Real Lives.

Specification: Complete Web Automation with Excel VBA

Duration 9.5 hours
Year 2020
Level Intermediate
Certificate Yes
Quizzes No

14 reviews for Complete Web Automation with Excel VBA

4.6 out of 5
11
2
1
0
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Avatar

    Joshua Davis

    Well delivered manageable segments with easy to follow steps and resource materials

    Helpful(0) Unhelpful(0)You have already voted this
  2. Avatar

    Poovaragavan

    It’s so good for learning automation.

    Helpful(0) Unhelpful(0)You have already voted this
  3. Avatar

    Bhushan Raderam

    Nice exactly what i was looking for

    Helpful(0) Unhelpful(0)You have already voted this
  4. Avatar

    Connor Skelton

    Lots of material in this course. Definetly suggest intermediate level of VBA knowledge required in order to link topics and ideas better. Only negative, is that some of the websites are outdated and can be difficult to follow.

    Helpful(0) Unhelpful(0)You have already voted this
  5. Avatar

    Tom Donnelly

    Awesome course. Gives me the exact tools I was looking for. Instructor is energetic, enthusiastic and engaging. Knows his stuff and communicates it well.

    Helpful(0) Unhelpful(0)You have already voted this
  6. Avatar

    Victor Guarnieri

    My code didnt work

    Helpful(0) Unhelpful(0)You have already voted this
  7. Avatar

    Carlos Catalao

    Very good. Very simple.

    Helpful(0) Unhelpful(0)You have already voted this
  8. Avatar

    Didier Boullery

    J’ai appris tout ce dont j’avais besoin. Merci, tr s bon retour sur investissement.

    Helpful(0) Unhelpful(0)You have already voted this
  9. Avatar

    Jose J Acevedo De La Ossa

    GOOD

    Helpful(0) Unhelpful(0)You have already voted this
  10. Avatar

    Ts

    stuff, easy solution

    Helpful(0) Unhelpful(0)You have already voted this
  11. Avatar

    Victoria

    Great course! Explained a lot about Selenium and what you can do to QA sites and extract that data out. Similar to Daniel’s other VBA courses, he keeps a good pace and goes through a lot of the fine details, from beginner to advanced. Enjoyed the examples and exercises. Thanks again!

    Helpful(0) Unhelpful(0)You have already voted this
  12. Avatar

    Mazher Khan

    found everything which we need to know about Selenium… Thank you! very good explanation.

    Helpful(0) Unhelpful(0)You have already voted this
  13. Avatar

    John Robinson

    This is a very thorough course which steps through the use of Selenium Basic with some clear and well explained examples. Materials are kept up to date to recognise issues and changes in websites

    Helpful(0) Unhelpful(0)You have already voted this
  14. Avatar

    Heetae KIM

    Truly helpful for my work… now i’m working on my automation project and it gave me insight about how to achieve what i want. Thank you.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Complete Web Automation with Excel VBA
    Complete Web Automation with Excel VBA

    $94.99 $12.99

    Price tracking

    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare