Have Questions? 
help@excelvbaisfun.com
Excel Ninja Pro
All Access

[et_pb_section fb_built="1" custom_padding_last_edited="on|tablet" _builder_version="4.4.7" background_color="#F5F5F5" custom_padding="||0px||false|false" custom_padding_tablet="||0px||false|false" custom_padding_phone=""][et_pb_row column_structure="1_2,1_2" disabled_on="off|off|off" _builder_version="4.4.7" width="90%" width_tablet="" width_phone="100%" width_last_edited="on|phone" max_width="90%" custom_margin="-42px||||false|false" custom_padding="22px||0px||false|false" module_alignment_tablet="" module_alignment_phone="center" module_alignment_last_edited="on|phone"][et_pb_column type="1_2" disabled_on="off|off|off" _builder_version="4.4.7" custom_padding="76px||||false|false"][et_pb_text disabled_on="on|on|on" _builder_version="4.4.7" header_font="Roboto|900|||||||" header_text_align="left" header_text_color="#d61f2c" header_font_size="64px" header_line_height="80px" header_4_text_align="left" disabled="on"]

Complete Web Automation with Excel VBA

[/et_pb_text][et_pb_text disabled_on="on|on|on" _builder_version="4.4.7" header_text_align="left" header_3_font="Roboto|500|||||||" header_3_text_align="center" header_3_text_color="#000000" header_3_font_size="28px" header_3_line_height="35px" header_4_text_align="left" custom_margin="||9px|||" disabled="on"]

Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency!

[/et_pb_text][et_pb_text disabled_on="on|on|on" _builder_version="4.4.7" header_text_align="left" header_4_font="Roboto|700|||||||" header_4_text_align="left" header_4_text_color="#1a1a1a" header_4_font_size="22px" header_4_line_height="28px" custom_margin="||12px|||" disabled="on"]

Online course

[/et_pb_text][et_pb_text disabled_on="on|on|on" _builder_version="4.4.7" text_font="Libre Baskerville|600|||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" header_text_align="left" header_4_text_align="left" disabled="on"]

By Dan Strong, Owner @ ExcelVbaIsFun

Course length: ~9.5h

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.4.7"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/06/aa-bl-IMG_7655.png" title_text="aa-bl-IMG_7655" align_tablet="" align_phone="center" align_last_edited="on|phone" disabled_on="off|on|on" _builder_version="4.4.7" max_width="85%" filter_saturate="0%" filter_brightness="115%"][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.4.7" width="90%" max_width="90%" custom_margin="-42px||||false|false" custom_padding="22px||0px||false|false"][et_pb_column type="1_2" _builder_version="4.4.7" custom_padding="76px||||false|false"][et_pb_text _builder_version="4.4.7" header_font="Roboto|900|||||||" header_text_align="left" header_text_color="#1a1a1a" header_font_size="64px" header_line_height="80px" custom_margin="||10px|||" header_text_align_tablet="center" header_text_align_phone="" header_text_align_last_edited="on|tablet" header_font_size_tablet="51px" header_font_size_phone="45px" header_font_size_last_edited="on|phone" header_line_height_tablet="" header_line_height_phone="21.5px" header_line_height_last_edited="on|phone"][/et_pb_text][et_pb_text _builder_version="4.4.7" header_font="Roboto|900|||||||" header_text_align="left" header_text_color="#d61f2c" header_font_size="64px" header_line_height="80px" header_4_text_align="left" header_text_align_tablet="center" header_text_align_phone="" header_text_align_last_edited="on|tablet" header_font_size_tablet="50px" header_font_size_phone="45px" header_font_size_last_edited="on|phone" header_line_height_tablet="48.6px" header_line_height_phone="54.2px" header_line_height_last_edited="on|tablet"]

Complete Web Automation with Excel VBA

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_text_align="left" header_3_font="Roboto|500|||||||" header_3_text_align="left" header_3_text_color="#000000" header_3_font_size="28px" header_3_line_height="35px" header_4_text_align="left" custom_margin="||9px|||" custom_margin_tablet="" custom_margin_phone="-29px||11px||false|false" custom_margin_last_edited="on|phone" custom_padding_tablet="" custom_padding_phone="0px||0px||false|false" custom_padding_last_edited="on|phone" header_3_text_align_tablet="center" header_3_text_align_phone="" header_3_text_align_last_edited="on|tablet" header_3_font_size_tablet="25px" header_3_font_size_phone="25px" header_3_font_size_last_edited="on|phone" header_3_letter_spacing_tablet="" header_3_letter_spacing_phone="" header_3_letter_spacing_last_edited="on|phone" header_3_line_height_tablet="17.2px" header_3_line_height_phone="33.3px" header_3_line_height_last_edited="on|tablet"]

Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency!

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_text_align="left" header_4_font="Roboto|700|||||||" header_4_text_align="left" header_4_text_color="#1a1a1a" header_4_font_size="22px" header_4_line_height="28px" custom_margin="||12px|||" custom_margin_tablet="" custom_margin_phone="-12px||||false|false" custom_margin_last_edited="on|phone" header_4_text_align_tablet="center" header_4_text_align_phone="" header_4_text_align_last_edited="on|tablet" header_4_font_size_tablet="19px" header_4_font_size_phone="23px" header_4_font_size_last_edited="on|phone" header_4_line_height_tablet="25.8px" header_4_line_height_phone="" header_4_line_height_last_edited="on|tablet"]

Online course

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Libre Baskerville|600|||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" header_text_align="left" header_4_text_align="left" custom_margin="||7px|||" custom_padding="0px||36px||false|false" text_font_size_tablet="" text_font_size_phone="" text_font_size_last_edited="on|tablet" text_orientation_tablet="center" text_orientation_phone="" text_orientation_last_edited="on|tablet"]

By Dan Strong, Owner @ ExcelVbaIsFun

Course length: ~9.5h

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.4.7"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/06/aa-bl-IMG_7655.png" title_text="aa-bl-IMG_7655" src_tablet="" src_phone="" src_last_edited="on|tablet" align_tablet="center" align_phone="" align_last_edited="on|tablet" disabled_on="on|off|off" _builder_version="4.4.7" max_width="85%" custom_padding="32px||0px||false|false" custom_padding_tablet="0px||0px||false|false" custom_padding_phone="" custom_padding_last_edited="on|tablet" filter_saturate="0%" filter_brightness="116%"][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.4.7"][et_pb_row _builder_version="4.4.7" width="55%" width_tablet="80%" width_phone="" width_last_edited="on|tablet" custom_padding="||0px|||"][et_pb_column type="4_4" _builder_version="4.4.7"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="||||false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="center" header_2_text_align_phone="left" header_2_text_align_last_edited="on|tablet" header_2_font_size_tablet="38px" header_2_font_size_phone="27px" header_2_font_size_last_edited="on|phone" header_2_line_height_tablet="35.7px" header_2_line_height_phone="" header_2_line_height_last_edited="on|tablet" locked="off" custom_padding__hover_enabled="off|desktop"]

Description

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Libre Baskerville||||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" text_font_size_tablet="13px" text_font_size_phone="" text_font_size_last_edited="on|tablet" text_line_height_tablet="26px" text_line_height_phone="" text_line_height_last_edited="on|tablet" text_orientation_tablet="left" text_orientation_phone="" text_orientation_last_edited="on|tablet"]

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 LIFETIME ACCESS to the course videos, including updates, BONUS videos and lectures as they come out and any future source code and workbooks – Yours to keep – FREE.

All students will receive LIFETIME ACCESS to ask me any questions about the materials in the FORUM section – as well as chat with other students and help each other. 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!

[/et_pb_text][et_pb_text module_id="introvideo" _builder_version="4.4.7" header_2_font="Roboto|700|||||||" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" header_2_text_align_tablet="" header_2_text_align_phone="" header_2_text_align_last_edited="on|tablet" header_2_font_size_tablet="48px" header_2_font_size_phone="28px" header_2_font_size_last_edited="on|phone" header_2_line_height_tablet="" header_2_line_height_phone="16.6px" header_2_line_height_last_edited="on|phone"]

Introduction video (3 min)

[/et_pb_text][et_pb_video src="https://vimeo.com/365325971/2df069af6a" _builder_version="4.4.7" width="80%" width_tablet="100%" width_phone="" width_last_edited="on|tablet" module_alignment="center" module_alignment_tablet="center" module_alignment_phone="" module_alignment_last_edited="on|tablet"][/et_pb_video][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="0px||||false|false" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="center" header_2_text_align_phone="" header_2_text_align_last_edited="on|tablet" header_2_font_size_tablet="38px" header_2_font_size_phone="26px" header_2_font_size_last_edited="on|tablet" header_2_line_height_tablet="" header_2_line_height_phone="32px" header_2_line_height_last_edited="on|phone"]

What you'll learn

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Libre Baskerville||||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" ul_font="Libre Baskerville|300|||||||" ul_text_color="rgba(24,39,57,0.94)" ul_font_size="16px" ul_line_height="26px" custom_padding="|||94px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" ul_text_align_tablet="left" ul_text_align_phone="left" ul_text_align_last_edited="on|tablet" ul_font_size_tablet="16px" ul_font_size_phone="" ul_font_size_last_edited="on|tablet"]

  • 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

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="center" header_2_text_align_phone="left" header_2_text_align_last_edited="on|tablet" header_2_font_size_tablet="34px" header_2_font_size_phone="24px" header_2_font_size_last_edited="on|phone" header_2_line_height_tablet="" header_2_line_height_phone="36px" header_2_line_height_last_edited="on|phone" locked="off" header_2_line_height__hover_enabled="on|desktop"]

Requirements

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Libre Baskerville||||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" ul_font="Libre Baskerville|300|||||||" ul_text_color="rgba(24,39,57,0.94)" ul_font_size="16px" ul_line_height="26px" custom_padding="|||94px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" ul_font_size_tablet="" ul_font_size_phone="" ul_font_size_last_edited="on|phone" locked="off"]

  • You should already have Microsoft Excel (version 2003, 2007, 2010, 2013 or 2016). Obviously the newer the better, but VBA works the same in all versions. It's just that newer versions have more options, thus more VBA Commands to control those options.
  • Very very basic Excel skills needed for this course. IF you know Basic to Intermediate Excel VBA, you can surely find more ways to utilize this info, but is not required as I explain everything in detail.

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="center" header_2_text_align_phone="left" header_2_text_align_last_edited="on|tablet" header_2_font_size_tablet="38px" header_2_font_size_phone="27px" header_2_font_size_last_edited="on|phone" header_2_line_height_tablet="35.7px" header_2_line_height_phone="" header_2_line_height_last_edited="on|tablet" locked="off" custom_padding__hover_enabled="off|desktop"]

Who this course is for:

[/et_pb_text][et_pb_text _builder_version="4.4.7" ul_font="Libre Baskerville|300|||||||" ul_text_color="rgba(24,39,57,0.94)" ul_font_size="16px" ul_line_height="26px" custom_padding="|||94px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" ul_font_size_tablet="" ul_font_size_phone="" ul_font_size_last_edited="on|phone" locked="off"]

  • This Excel course is for anyone who wants to learn Automation secrets in Excel VBA for controlling websites. No prior programming knowledge is needed.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.4.7" background_enable_color="off" positioning="none" custom_padding="0px||0px||false|false"][et_pb_row _builder_version="4.4.7" custom_padding="||12px|||"][et_pb_column type="4_4" _builder_version="4.4.7"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="0px||||false|false" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="0px||0px|0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="28px" header_2_font_size_last_edited="on|phone" locked="off" custom_padding__hover_enabled="off|desktop"]

Don't just take our word for it…

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_3,1_3,1_3" use_custom_gutter="on" _builder_version="4.4.7" positioning="none" module_alignment="center" custom_css_main_element="overflow:;"][et_pb_column type="1_3" _builder_version="4.4.7" background_color="#ffffff" custom_padding="10px|10px|39px|10px|false|false" animation_style="slide" border_radii="on|5px|5px|5px|5px" border_width_all="1px" border_color_all="#dddddd" box_shadow_style="preset2" border_color_all__hover_enabled="on|desktop" border_color_all__hover="#e02b20"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/Portrait_Placeholder200.png" alt="scott keenan review" title_text="Portrait_Placeholder200" align="center" _builder_version="4.4.7" width="42%" border_radii="on|118px|118px|118px|118px"][/et_pb_image][et_pb_text _builder_version="4.4.7" header_4_font="Roboto|900|||||||" header_4_text_align="center" header_4_text_color="#1a1a1a" header_4_font_size="22px" header_4_line_height="28px" custom_margin="||8px|||"]

Jahyun K.

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Roboto||||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" custom_padding="||22px|||"]

This course gave me tremendous ideas and help my work. Now I used in my real work and make automation such as opening internal websites that I want to log in and go to correct sub pages.

Usually, I needed to open 4 different pages for processing each requirement and I had to proceed login and go to proper sub web pages. However, now I don't have to do such a boring process. Just click buttons I made, it guides me to work right away going through full automation function.

I am very very happy to reduce my time and boring repeated jobs. I strongly recommend this course to everyone who wants to automate their work between Excel vba with Selenium and Web browser.

I strongly recommend this course to operational workers(Managers/Process Assistants).

[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.4.7" background_color="#ffffff" custom_padding="10px|10px|80px|10px|false|false" animation_style="slide" border_radii="on|5px|5px|5px|5px" border_width_all="1px" border_color_all="#dddddd" box_shadow_style="preset2" border_color_all__hover_enabled="on|desktop" border_color_all__hover="#e02b20"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/Portrait_Placeholder200.png" title_text="Portrait_Placeholder200" align="center" _builder_version="4.4.7" width="42%" border_radii="on|118px|118px|118px|118px"][/et_pb_image][et_pb_text _builder_version="4.4.7" header_4_font="Roboto|900|||||||" header_4_text_align="center" header_4_text_color="#1a1a1a" header_4_font_size="22px" header_4_line_height="28px" custom_margin="||8px|||"]

Peter S.

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Roboto||||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" custom_padding="||9px|||"]

...this is A+ content.

It's a bit of a crime that when you Google something like "webscrape Excel VBA" you still get a ton of results with the old and useless Microsoft Internet Controls reference.

Excel brings a powerful UI, and despite its many failings, VBA brings a true rapid prototyping capability, and the VBE provides a really convenient debugging environment. Together, that's why the Excel paradigm is still going strong after three decades. I love Python, but web automation with Excel+VBA is so easy, and so powerful that, I have to confess, I'd rather scrape with Excel+VBA.

These videos are paced well. Not too fast, not too slow. Dan does a great job with the selectors. And, I'm pretty amazed, answers questions individually.

This is an exceptional course. Definitely a strong 5 star rating.

Clear and progressive examples. Well done.

[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.4.7" background_color="#ffffff" custom_padding="10px|10px|80px|10px|false|false" animation_style="slide" border_radii="on|5px|5px|5px|5px" border_width_all="1px" border_color_all="#dddddd" box_shadow_style="preset2" border_color_all__hover_enabled="on|desktop" border_color_all__hover="#e02b20"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/Portrait_Placeholder200.png" title_text="Portrait_Placeholder200" align="center" align_tablet="" align_phone="center" align_last_edited="on|phone" _builder_version="4.4.7" width="42%" border_radii="on|118px|118px|118px|118px"][/et_pb_image][et_pb_text _builder_version="4.4.7" header_4_font="Roboto|900|||||||" header_4_text_align="center" header_4_text_color="#1a1a1a" header_4_font_size="22px" header_4_line_height="28px" custom_margin="||8px|||"]

Marcos L.

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Roboto||||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" custom_margin="||-7px|||"]

This course of Selenium Basic over VBA Excel with Daniel Strong is awesome. Huge material inside. Videos are smooth and very detailed, Daniel Strong has huge comprehension of the matter and has an excellent technical vocabulary and easy speech for students like me that has English as the second language... Daniel Strong has done a 10 out of 10 course. Keep up the good work.

Surely, I finished this class better than I had started (professionally speaking).

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.4.7" custom_padding="0px|||||"][et_pb_row _builder_version="4.4.7" width="55%" width_tablet="87%" width_phone="" width_last_edited="on|tablet"][et_pb_column type="4_4" _builder_version="4.4.7"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="0px||||false|false" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="0px||0px|0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="28px" header_2_font_size_last_edited="on|phone" locked="off" custom_padding__hover_enabled="off|desktop"]

Skills you should have before taking this course…

[/et_pb_text][et_pb_text _builder_version="4.4.7" ul_font="Libre Baskerville|300|||||||" ul_text_color="rgba(24,39,57,0.94)" ul_font_size="16px" ul_line_height="26px" custom_margin="||-19px|||" custom_margin_tablet="" custom_margin_phone="||0px||false|false" custom_margin_last_edited="on|phone" custom_padding="|||94px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" ul_font_size_tablet="" ul_font_size_phone="15px" ul_font_size_last_edited="on|phone" locked="off"]

  • A bit of VBA experience helps, but I will take you through all the lessons with full examples, so you can pick up and practice the lessons even if you're new.
  • You don't need any experience with Selenium as I'll guide you through each idea and exercise!

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.4.7" background_color="#F2F2F2"][et_pb_row column_structure="1_2,1_2" custom_padding_last_edited="on|tablet" _builder_version="4.4.7" width="54%" width_tablet="70%" width_phone="" width_last_edited="on|tablet" custom_padding_tablet="0px||0px||false|false" custom_padding_phone=""][et_pb_column type="1_2" _builder_version="4.4.7"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" header_2_text_align_tablet="center" header_2_text_align_phone="" header_2_text_align_last_edited="on|tablet" header_2_font_size_tablet="53px" header_2_font_size_phone="" header_2_font_size_last_edited="on|tablet"]

About

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#d61f2c" header_2_font_size="40px" header_2_line_height="50px" custom_margin="-19px|||||" header_2_text_align_tablet="center" header_2_text_align_phone="" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="41px" header_2_font_size_phone="37px" header_2_font_size_last_edited="on|tablet"]

Dan Strong

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Libre Baskerville|300|on||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px"]

Dan Strong is a renowned software instructor and efficiency solutions specialist and the Founder at ExcelVbaIsFun and Strong Software Solutions where he teaches report generation, data analysis, automation and numerous other I.T. skills. He posesses an exceptional ability to simplify complex topics and engages learners with an infectious passion for automation and technology.

Author of multiple international best-selling courses with over 125K students from 192 countries. He regularly publishes free training to 90K+ YouTube followers and at excelvbaisfun.com.

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.4.7"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/06/aa-bl-IMG_7655.png" title_text="aa-bl-IMG_7655" align_tablet="center" align_phone="" align_last_edited="on|tablet" _builder_version="4.4.7" custom_padding="120px||0px||false|false" custom_padding_tablet="50px||0px||false|false" custom_padding_phone="0px||0px||false|false" custom_padding_last_edited="on|phone" filter_saturate="0%" filter_brightness="115%" border_radii="off|||300px|300px"][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.4.7" custom_padding="0px||0px||false|false"][et_pb_row custom_padding_last_edited="on|tablet" _builder_version="4.4.7" width="55%" width_tablet="100%" width_phone="" width_last_edited="on|tablet" custom_padding="||||false|false" custom_padding_tablet="0px||0px||false|false" custom_padding_phone="" module_alignment_tablet="center" module_alignment_phone="" module_alignment_last_edited="on|tablet"][et_pb_column type="4_4" _builder_version="4.4.7"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="center" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" text_orientation="center" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="||||false|false" custom_padding_tablet="" custom_padding_phone="15px|||0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="33px" header_2_font_size_last_edited="on|phone" header_2_line_height_tablet="" header_2_line_height_phone="50.8px" header_2_line_height_last_edited="on|phone" locked="off" custom_padding__hover_enabled="off|desktop"]

Your full course curriculum

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_4_font="Roboto|900|||||||" header_4_text_align="center" header_4_text_color="#1a1a1a" header_4_font_size="22px" header_4_line_height="28px" text_orientation="center"]

Complete Web Automation with Excel VBA

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row custom_padding_last_edited="on|tablet" _builder_version="4.4.7" width="55%" width_tablet="83%" width_phone="93%" width_last_edited="on|phone" custom_padding_tablet="||0px||false|false" custom_padding_phone=""][et_pb_column type="4_4" _builder_version="4.4.7"][et_pb_toggle title="Introduction - Getting Started & Setup" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  •  Introduction and Course Download Files
  • Getting & Installing Selenium
  •  Installation Troubleshooting (skip if you don't need this!)

[/et_pb_toggle][et_pb_toggle title="Selenium Basics" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • Opening a Web Page
  • 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 - Set Value versus SendKeys To TextBox
  • BONUS - Create of Change Any Attribute Using Javascript
  • BONUS - New Change Attribute Custom Function and Huge Demo
  • Set Attributes With JavaScript Easily!

[/et_pb_toggle][et_pb_toggle title="Advanced Find With XPath" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • 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

[/et_pb_toggle][et_pb_toggle title="Working With Multiple Elements At Once" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • 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
  • Exercise 04a - Question
  • Exercise 04a - Answer
  • Finding Elements within an Element

[/et_pb_toggle][et_pb_toggle title="Element Properties, Methods and Useful Information" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • 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!

[/et_pb_toggle][et_pb_toggle title="Built In Comparison Operators" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • 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

[/et_pb_toggle][et_pb_toggle title="Mouse and Keyboard Actions" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • 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

[/et_pb_toggle][et_pb_toggle title="Timeouts and Waits" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • 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
  • Wait for Text To Appear or Change
  • WaitNotElement and By.Any
  • WaitEnabled or Wait Until Element is Displayed
  • Wait For Selection With Checkboxes and OptionButtons
  • Selenium VBA Code Snippets - Chapter 7-8

[/et_pb_toggle][et_pb_toggle title="Browser Window Control, Navigation and Focus" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • Alerts - Using Multi Options (OK and Cancel, OK Only & Text) with An Alert
  • SetCredentials Troubleshooting Tips and Authorization Dialog Popups
  • Custom Function Testing Whether Dialog Popup Is Present
  • Basic Navigation - Back, Forward, Reload, Close Driver, Close Single page, Url
  • Setting A Custom Profile For WebDriver Session
  • Add Special Arguments to Customize Browser Options - Incognito or Hidden Window
  • Special Arguments List
  • Using a Portable Version of Chrome - GoogleChromePortable
  • AddArguments Link and Examples
  • Grab Html Page Source and Text From Parent Elements
  • Exercise 09a - Question
  • Exercise 09a - Answer
  • Keep a Permanent WebDriver that Doesn't Close On Its Own
  • Frames and Frame Nagivation
  • BONUS - Frame Finder Custom Function
  • BONUS - Switch To Nested Frame Custom Function
  • Window, Tab Manipulation by Title, Index, Previous and Next
  • Accessing Window By Name, Handle
  • Close All Tabs Except Main Tab
  • Several Ways To Open a New Tab In Current Session
  • Window Sizing and Position
  • Selenium VBA Code Snippets - Chapter 9

[/et_pb_toggle][et_pb_toggle title="Image and Clipboard Manipulation" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • Save a Screenshot of Your Browser, Dispose Image in System Memory
  • Save Web Element as Image
  • Save Entire Desktop Screen as Image
  • Copy Image Directly to Excel OR To Clipboard
  • Image Dimensions and Resizing
  • Compare Two Images with CompareTo and DiffCount
  • Put Web Image Into Worksheet ActiveX Image Control
  • Load Image Into Userform Image

[/et_pb_toggle][et_pb_toggle title="Working With Tables" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • Converting a Web Table to TableElement Object and Inserting into Worksheet
  • Manipulating TableElement Data as Array onto Worksheet
  • Loop Through Elements in Specific Column Only
  • Loop Through Multiple Specific Columns Using OR Operator
  • Put Specific Columns into List Object, To Excel Easily
  • Exercise 11a - Question
  • Exercise 11a - Answer

[/et_pb_toggle][et_pb_toggle title="Selecting Options from Dropdowns and Listboxes" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • Declare SelectElement, Read and Write Dropdown Control
  • Select Using the Index Number
  • Select Using Internal Option Value
  • All About The Options Collection
  • Using The Mouse To Select Multiple Options
  • Deselecting All Options or Specific Options
  • Selenium VBA Code Snippets - Chapter 10-12
  • Exercise 12a - Question
  • Exercise 12a - Answer

[/et_pb_toggle][et_pb_toggle title="BONUS - Extra Troubleshooting Tips" open_toggle_background_color="#f4f4f4" closed_toggle_background_color="#ffffff" icon_color="#0c71c3" use_icon_font_size="on" icon_font_size="25px" _builder_version="4.4.7" title_text_color="#1a1a1a" title_font="Roboto||||||||" title_font_size="26px" title_line_height="35px" body_font="Libre Baskerville||||||||" body_text_color="rgba(24,39,57,0.94)" body_font_size="16px" body_line_height="26px" border_width_all="0px" border_width_bottom="2px"]

  • Error Loading Extension Help
  • Error Loading Extension Help - Source Code
  • BONUS LECTURE

[/et_pb_toggle][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.4.7"][et_pb_row _builder_version="4.4.7" width="55%" width_tablet="82%" width_phone="" width_last_edited="on|tablet"][et_pb_column type="4_4" _builder_version="4.4.7"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="center" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="0px||0px|0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="28px" header_2_font_size_last_edited="on|phone" locked="off" custom_padding__hover_enabled="off|desktop"]

Show off your new skills: Get a

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="center" header_2_text_color="#d61f2c" header_2_font_size="40px" header_2_line_height="50px" custom_margin="10px|||||" custom_margin_tablet="" custom_margin_phone="-41px||||false|false" custom_margin_last_edited="on|phone" custom_padding="0px||23px|66px|false|false" custom_padding_tablet="" custom_padding_phone="0px||26px|0px|false|false" custom_padding_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="27px" header_2_font_size_last_edited="on|phone" locked="off"]

certificate of completion

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Libre Baskerville|300|||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" custom_margin="-26px||||false|false" locked="off"]

Once the course is over, pass a test to earn an Excel VBA certification.

Add it to your resume, your LinkedIn profile or other professional profiles.

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Libre Baskerville|300|||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" custom_margin="-23px||||false|false" locked="off"][/et_pb_text][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/06/uepc2-1000px-cropped.png" title_text="uepc2 1000px cropped" align="center" _builder_version="4.4.7" custom_margin="9px||||false|false" custom_padding="10px||||false|false"][/et_pb_image][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.4.7" width="55%" width_tablet="" width_phone="90%" width_last_edited="on|phone" custom_padding="||16px|||"][et_pb_column type="1_2" _builder_version="4.4.7"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="30px" header_2_font_size_last_edited="on|phone" locked="off"]

The ExcelVbaIsfun guarantee:

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Roboto Slab|300|||||||" text_text_color="#000000" text_font_size="17px" text_line_height="2.4em" ul_font="Libre Baskerville||||||||" ul_text_color="rgba(24,39,57,0.94)" ul_font_size="16px" ul_line_height="26px" custom_margin="-23px||||false|false" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" ul_font_size_tablet="" ul_font_size_phone="" ul_font_size_last_edited="on|phone" locked="off" custom_padding__hover_enabled="off|desktop"]

  • 30-day no questions asked money back period
  • Use your new skills immediately as you learn.

[/et_pb_text][et_pb_text _builder_version="4.4.7" header_3_font="Roboto|900|||||||" header_3_text_color="#1a1a1a" header_3_font_size="28px" header_3_line_height="35px" header_3_font_size_tablet="" header_3_font_size_phone="25px" header_3_font_size_last_edited="on|phone"]

Lifetime Access for a one-time fee

[/et_pb_text][et_pb_wc_price product="18107" _builder_version="4.4.7" text_orientation="center"][/et_pb_wc_price][et_pb_wc_add_to_cart product="18107" show_quantity="off" show_stock="off" _builder_version="4.4.7" body_text_color="#e02b20" custom_button="on" button_text_size="30px" button_text_color="#ffffff" button_bg_color="#DA3541" button_border_color="#e02b20" text_orientation="center" hover_transition_speed_curve="ease-in-out"][/et_pb_wc_add_to_cart][et_pb_text _builder_version="4.4.7" text_font="Libre Baskerville||on||||||" text_text_color="rgba(24,39,57,0.94)" text_font_size="16px" text_line_height="26px" text_orientation="center"]

All courses come with a 30-day money back guarantee.

[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.4.7"][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/06/paypal-verifieddan.png" title_text="paypal-verifieddan" _builder_version="4.4.7"][/et_pb_image][et_pb_image src="http://excelvbaisfun.com/wp-content/uploads/2020/06/30day-guarantee.png" title_text="30day-guarantee" _builder_version="4.4.7"][/et_pb_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" custom_padding_last_edited="on|tablet" _builder_version="4.4.7" custom_margin_tablet="-53px||||false|false" custom_margin_phone="-83px||||false|false" custom_margin_last_edited="on|phone" custom_padding="0px||0px||false|false" custom_padding_tablet="0px||0px||false|false" custom_padding_phone="0px||0px||false|false"][et_pb_row _builder_version="4.4.7" custom_padding="||17px|||"][et_pb_column type="4_4" _builder_version="4.4.7"][et_pb_text _builder_version="4.4.7" header_2_font="Roboto|900|||||||" header_2_text_align="left" header_2_text_color="#1a1a1a" header_2_font_size="40px" header_2_line_height="50px" custom_margin="37px|||||" custom_margin_tablet="" custom_margin_phone="0px||||false|false" custom_margin_last_edited="on|phone" custom_padding="|||66px|false|false" custom_padding_tablet="" custom_padding_phone="|||0px|false|false" custom_padding_last_edited="on|phone" header_2_text_align_tablet="" header_2_text_align_phone="center" header_2_text_align_last_edited="on|phone" header_2_font_size_tablet="" header_2_font_size_phone="30px" header_2_font_size_last_edited="on|phone" locked="off"]

What REAL Students Are Saying...

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row use_custom_gutter="on" gutter_width="1" _builder_version="4.4.7" width="93%" max_width="2090px" custom_padding="29px|200px||200px|false|false"][et_pb_column type="4_4" _builder_version="4.4.7" custom_padding="|2.5px||5px|false|false"][et_pb_video src="https://vimeo.com/427800993/a71a84411b" thumbnail_overlay_color="rgba(0,0,0,0.6)" _builder_version="4.4.7" width="50%" module_alignment="center" custom_margin="|90px||90px|false|true"][/et_pb_video][et_pb_testimonial author="Jiyaad Naeem" portrait_url="data:image/svg+xml;base64,PHN2ZyB3aWR0aD0iNTAwIiBoZWlnaHQ9IjUwMCIgdmlld0JveD0iMCAwIDUwMCA1MDAiIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyI+CiAgICA8ZyBmaWxsPSJub25lIiBmaWxsLXJ1bGU9ImV2ZW5vZGQiPgogICAgICAgIDxwYXRoIGZpbGw9IiNFQkVCRUIiIGQ9Ik0wIDBoNTAwdjUwMEgweiIvPgogICAgICAgIDxyZWN0IGZpbGwtb3BhY2l0eT0iLjEiIGZpbGw9IiMwMDAiIHg9IjY4IiB5PSIzMDUiIHdpZHRoPSIzNjQiIGhlaWdodD0iNTY4IiByeD0iMTgyIi8+CiAgICAgICAgPGNpcmNsZSBmaWxsLW9wYWNpdHk9Ii4xIiBmaWxsPSIjMDAwIiBjeD0iMjQ5IiBjeT0iMTcyIiByPSIxMDAiLz4KICAgIDwvZz4KPC9zdmc+Cg==" quote_icon_color="rgba(0,0,0,0)" quote_icon_background_color="rgba(0,0,0,0)" portrait_width="0px" portrait_height="0px" _builder_version="4.4.7" body_text_color="#000000" body_letter_spacing="-0.5px" background_color="#ffffff" transform_translate="0px|-24px" transform_translate_linked="off" width="50%" module_alignment="center" custom_margin="|90px||90px|false|true" custom_padding="50px|67px|50px|67px|true|true" border_radii="off|||30px|30px" box_shadow_style="preset1" box_shadow_blur="80px" box_shadow_spread="-10px"]

When I was scouring online for something that will speed up what I need to do at work, finding Dan's course was like an Oasis in the desert. I immediately saw how I can shave hours of time from my workflow every week, and got more and more excited as the course went on into the many different applications. I've already started creating some automation to make sure I have the most correct data in excel for reporting and that there are no data entry mis-haps... I had no idea could be used with VBA.

Look forward to providing an update when I've automated a few projects I had in mind. Also bought a few of his other courses as I finished this one. Thanks Dan!

Edit: I have been able to automate a few tasks that were taking 2+ hours a week, and now I can run them multiple times a week which would have required 6+ hours if I did that on my own.

I'm now trying to automate the next big time suck reporting tasks I have bi-weekly. If I'm able to automate this bi-weekly report, not only will I be able to save even more time, but I can run these reports almost daily as I keep refining and it could result in 10+ hours of work saved per week since I'm not doing things manually running things multiple times. Need to learn how to schedule reports to run automatically every week now - Thank you Dan!

[/et_pb_testimonial][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.4.7" background_color="#F2F2F2"][et_pb_row _builder_version="4.4.7" width="92%" max_width="1996px" hover_enabled="0" custom_padding="||14px|||"][et_pb_column _builder_version="4.4.7" type="4_4"][dsm_typing_effect _builder_version="4.4.7" typing_effect="Amazing Features" typing_loop="off" hover_enabled="0" typing_font_size="53px" header_text_align="center"][/dsm_typing_effect][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.4.7" width="93%" max_width="1929px"][et_pb_column type="4_4" _builder_version="4.4.7"][dsm_block_reveal_text block_reveal_text="Input Text & Run Searches" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" custom_margin="||23px|||" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_perspective_image _builder_version="4.4.7" hover_enabled="0"][/dsm_perspective_image][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/input-text-and-search.gif" _builder_version="4.4.7" title_text="input text and search" block_reveal_viewport="85%" hover_enabled="0" box_shadow_style="preset2"][/dsm_block_reveal_image][dsm_block_reveal_text block_reveal_text="Scrape Web Data" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" header_text_align="right" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/scrape-data.gif" _builder_version="4.4.7" title_text="scrape data" block_reveal_viewport="85%" hover_enabled="0" align="right" box_shadow_style="preset2"][/dsm_block_reveal_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.4.7" width="93%" max_width="1929px"][et_pb_column type="4_4" _builder_version="4.4.7"][dsm_block_reveal_text block_reveal_text="Manipulate Web Elements" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" custom_margin="||23px|||" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_perspective_image _builder_version="4.4.7" hover_enabled="0"][/dsm_perspective_image][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/Selenium-Change-Attribute-Custom-Function-Demo-ExcelVbaIsFun.gif" _builder_version="4.4.7" title_text="Selenium Change Attribute Custom Function Demo ExcelVbaIsFun" block_reveal_viewport="85%" hover_enabled="0" box_shadow_style="preset2"][/dsm_block_reveal_image][dsm_block_reveal_text block_reveal_text="Image/Clipboard Manipulation" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" header_text_align="right" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/image-and-clipboard-manipulation.gif" _builder_version="4.4.7" title_text="image and clipboard manipulation" block_reveal_viewport="85%" hover_enabled="0" align="right" box_shadow_style="preset2"][/dsm_block_reveal_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.4.7" width="93%" max_width="1929px"][et_pb_column type="4_4" _builder_version="4.4.7"][dsm_block_reveal_text block_reveal_text="Fill Forms & Dynamically Wait" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" custom_margin="||23px|||" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_perspective_image _builder_version="4.4.7" hover_enabled="0"][/dsm_perspective_image][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/fill-forms-and-wait-for-controls.gif" _builder_version="4.4.7" title_text="fill forms and wait for controls" block_reveal_viewport="85%" hover_enabled="0" box_shadow_style="preset2"][/dsm_block_reveal_image][dsm_block_reveal_text block_reveal_text="Options and Selection Controls" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" header_text_align="right" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/options-and-selection-controls.gif" _builder_version="4.4.7" title_text="options and selection controls" block_reveal_viewport="85%" hover_enabled="0" align="right" box_shadow_style="preset2"][/dsm_block_reveal_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.4.7" width="93%" max_width="1929px"][et_pb_column type="4_4" _builder_version="4.4.7"][dsm_block_reveal_text block_reveal_text="Hover & Click Actions" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" custom_margin="||23px|||" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_perspective_image _builder_version="4.4.7" hover_enabled="0"][/dsm_perspective_image][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/programatically-hover-and-click.gif" _builder_version="4.4.7" title_text="programatically hover and click" block_reveal_viewport="85%" hover_enabled="0" box_shadow_style="preset2"][/dsm_block_reveal_image][dsm_block_reveal_text block_reveal_text="Change Value, Class or Any Attribute!" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" header_text_align="right" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/Selenium-Change-Attribute-Custom-Function-ExcelVbaIsFun.gif" _builder_version="4.4.7" title_text="Selenium Change Attribute Custom Function ExcelVbaIsFun" block_reveal_viewport="85%" hover_enabled="0" align="right" box_shadow_style="preset2"][/dsm_block_reveal_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.4.7" width="93%" max_width="1929px"][et_pb_column type="4_4" _builder_version="4.4.7"][dsm_block_reveal_text block_reveal_text="Navigate Pagination" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" custom_margin="||23px|||" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_perspective_image _builder_version="4.4.7" hover_enabled="0"][/dsm_perspective_image][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/pagination.gif" _builder_version="4.4.7" title_text="pagination" block_reveal_viewport="85%" hover_enabled="0" box_shadow_style="preset2"][/dsm_block_reveal_image][dsm_block_reveal_text block_reveal_text="Drag & Drop Programmatically" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" header_text_align="right" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/drag-and-drop.gif" _builder_version="4.4.7" title_text="drag and drop" block_reveal_viewport="85%" hover_enabled="0" align="right" box_shadow_style="preset2"][/dsm_block_reveal_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.4.7" width="93%" max_width="1929px"][et_pb_column type="4_4" _builder_version="4.4.7"][dsm_block_reveal_text block_reveal_text="Dialog Boxes and Popups" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" custom_margin="||23px|||" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_perspective_image _builder_version="4.4.7" hover_enabled="0"][/dsm_perspective_image][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/dealing-with-dialog-boxes-popups-and-alerts.gif" _builder_version="4.4.7" title_text="dealing with dialog boxes, popups, and alerts" block_reveal_viewport="85%" hover_enabled="0" box_shadow_style="preset2"][/dsm_block_reveal_image][dsm_block_reveal_text block_reveal_text="Window Sizing and Positioning" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" header_text_align="right" block_reveal_viewport="85%"][/dsm_block_reveal_text][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/window-sizing-and-position.gif" _builder_version="4.4.7" title_text="window sizing and position" block_reveal_viewport="85%" hover_enabled="0" align="right" box_shadow_style="preset2"][/dsm_block_reveal_image][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.4.7" width="93%" max_width="1929px"][et_pb_column type="4_4" _builder_version="4.4.7"][dsm_block_reveal_text block_reveal_text="Practical Exercises" block_reveal_delay="0.8" _builder_version="4.4.7" hover_enabled="0" block_reveal_color="#7cda24" custom_margin="||23px|||" block_reveal_viewport="85%"][/dsm_block_reveal_text][et_pb_text _builder_version="4.4.7" hover_enabled="0" custom_margin="||10px|||"]

The GIF below shows searching for only size 'M'edium and only discounted items before checking out automatically on a demo testing site!

[/et_pb_text][dsm_perspective_image _builder_version="4.4.7" hover_enabled="0"][/dsm_perspective_image][dsm_block_reveal_image src="http://excelvbaisfun.com/wp-content/uploads/2020/07/exercises-demo.gif" _builder_version="4.4.7" title_text="exercises demo" block_reveal_viewport="85%" hover_enabled="0" box_shadow_style="preset2"][/dsm_block_reveal_image][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.4.7" background_color="#1a1a1a" custom_padding="40px||40px||true|false"][et_pb_row column_structure="1_3,1_3,1_3" _builder_version="4.4.7"][et_pb_column type="1_3" _builder_version="4.4.7"][et_pb_text _builder_version="4.4.7" text_font="Roboto|700|||||||" text_text_color="rgba(255,255,255,0.93)" custom_margin="0px||0px||false|false" custom_padding="0px||0px||false|false" link_option_url="http://excelvbaisfun.com/about-us/"]

About

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Roboto|700|||||||" text_text_color="rgba(255,255,255,0.93)" custom_margin="0px||0px||false|false" custom_padding="0px||0px||false|false" link_option_url="http://excelvbaisfun.com/testimonials/"]

User Reviews

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Roboto|700|||||||" text_text_color="rgba(255,255,255,0.93)" custom_margin="0px||0px||false|false" custom_padding="0px||0px||false|false" link_option_url="http://excelvbaisfun.com/become-an-affiliate/"]

Become an Affiliate

[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.4.7" custom_padding="|||14px|false|false" border_radii="off||||" border_width_right="1px" border_color_right="rgba(255,255,255,0.54)" border_width_left="1px" border_color_left="rgba(255,255,255,0.54)"][et_pb_text _builder_version="4.4.7" text_font="Roboto|700|||||||" text_text_color="rgba(255,255,255,0.93)" custom_margin="0px||0px||false|false" custom_padding="0px||0px|0px|false|false" link_option_url="http://excelvbaisfun.com/privacy-policy/" locked="off"]

Privacy Policy

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Roboto|700|||||||" text_text_color="rgba(255,255,255,0.93)" custom_margin="0px||0px||false|false" custom_padding="0px||0px||false|false" link_option_url="http://excelvbaisfun.com/terms-conditions/" locked="off"]

Terms & Conditions

[/et_pb_text][et_pb_text _builder_version="4.4.7" text_font="Roboto|700|||||||" text_text_color="rgba(255,255,255,0.93)" custom_margin="0px||0px||false|false" custom_padding="0px||0px||false|false" link_option_url="mailto:admin@excelvbaisfun.com" locked="off"]

E-mail admin@excelvbaisfun.com

[/et_pb_text][/et_pb_column][et_pb_column type="1_3" _builder_version="4.4.7" border_color_left="rgba(255,255,255,0.77)"][et_pb_text _builder_version="4.4.7" text_font="Roboto|574857491|||||||" text_text_color="rgba(255,255,255,0.93)" custom_margin="0px||0px||false|false" custom_padding="0px||0px||false|false" link_option_url="http://excelvbaisfun.com" locked="off"]

©2013-2020 ExcelVbaIsFun

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]

Excel VBA Is Fun

We believe Excel is one of the most versatile programs out there - and learning to program and automate it makes you very valuable!

You can prevent wasted time and errors, speed up tasks and become indispensable to your organization. 

See how our trainees have gotten raises, promotions and bonuses using their Excel Automation skills while building real problem-solving programs in Excel!
LEARN MORE
Copyright © 2024 ExcelVbaIsFun
X

Forgot Password?

Join Us

0
    0
    Your Cart
    Your cart is emptyReturn to Shop
    Continue Shopping
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram