|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-web-automation-with-excel-vba/
课程评论：没有评论
课程名称：Excel VBA 完整网页自动化课程 课程概述：在现代工作与生活中，使用网站已成为日常的一部分。很多人花费大量时间在线查找信息或填写繁琐的表格。想象一下，如果我们能自动化这些耗时的过程，将为我们节省多少时间！本课程“Excel VBA 完整网页自动化课程”将为您提供一个超过八小时的进阶学习体验，教您如何利用流行的网站测试程序 Selenium（以前只能通过复杂的编程语言如JavaScript或PHP使用）。 此课程为所有Microsoft Excel用户提供了这个免费的工具，但对于非开发者而言，几乎没有相关文档可供参考。在本课程中，我将带您了解所有未文档化的流程，让您学会如何使用各种策略定位和与网页元素互动，从基本的文本和属性搜索到高级策略如XPath、CSS选择器和正则表达式功能。 您将学习如何动态填写网页表单，直观地浏览网页，并提取和处理数据以提升效率。一旦您了解如何找到一个元素（或一组元素），您将评估元素的状态并完全控制鼠标和键盘的命令与定位。我们还将学习如何精确触发宏，通过“超时和等待”来实现。 除了基本的网页导航，我将展示如何打开、访问和切换多个标签窗口，调整浏览器窗口的大小、位置和自动滚动，并使用设定凭证的登录技术。您将能够像专家一样处理弹出窗口、警告、通知和框架。我还会教您如何控制剪贴板、将截图保存到Excel文件中，或自动将在线表格的全部或部分内容导入您的电子表格中。 课程内容丰富，每节都包含多个示例，并且设有有趣的练习以巩固您所学的知识（并提供解决方案视频）。您将获得100%源代码、可下载的材料和课程手册，并享有终身访问权，包括课程视频更新、额外视频和讲座。您也可以终身在论坛部分提出问题，与其他学生互动，互相帮助。 本课程提供30天无理由退款保证，让您购买无忧。不要再浪费时间在枯燥的在线任务上，让我们今天就来自动化您的在线工作流程吧！立即报名参加“Excel VBA 完整网页自动化课程”！
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!
