|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/save-your-time-with-excel-userform/
课程评论：没有评论
《Excel UserForm 智能数据收集》课程旨在教授如何利用Excel UserForm这一免费工具，简化和优化数据收集、决策及报告流程。课程不侧重抽象的VBA编程练习，而是通过趣味性的案例研究，帮助学习者理解VBA代码在实际场景中的应用，并鼓励通过重用提供的示例代码来学习。 课程内容涵盖： * 介绍典型的数据收集-决策-报告流程。 * 通过一个趣味性竞赛量化UserForm的优势。 * 讲解UserForm的工作机制。 * 通过案例学习如何在UserForm中添加输入项。 * 探讨如何在UserForm中处理图像。 * 将UserForm中的信息写入Excel。 * 通过案例学习如何添加第二个UserForm并重用代码。 * 演示如何从Excel数据生成PowerPoint报告。 * 通过案例实践将数据发送到PowerPoint幻灯片的技巧。 此外，课程还提供额外内容（BONUS），包括： * 数据归档/保存到SharePoint库。 * 起草Outlook邮件。 * 提供“设定强大目标”的模板。 总而言之，这是一门实用性强、内容简洁的课程，为需要提升工作效率、简化数据处理流程，但又不强制要求即时在线协作的用户，提供了一个简单而有效的解决方案。它能帮助您在一个集中的界面中处理信息，提高工作效率，并确保收集到“干净”的数据。
[UPDATED April 2020]SHORT Summary:Check out several examples of Office Automation using Excel UserForm. Apply these ideas in real life situations.***This course explains how simple and free Excel UserForm can be used to improve work with very basic and simple excel workbook:UserForm provides the advantage to have all relevant information in one place that helps to concentrate on task and be productive when dealing with information.UserForm allows customization of data entry to make sure users would collect 'clean' data Course is not focused to teach basics of the VBA coding by doing abstract coding exercises. Focus is made on understanding on how VBA code is applied for this particular situation. Learn coding by re-using provided examples in fun case studies.Ready-to-use templates could be used as is e.g. personal goal tracking templateThe course plan will be the following: Introducing you to the typical data collection - decision - reporting situationUnderstanding and quantifying advantage of UserForm using a funny competitionUnderstand "mechanics" of UserForm Case study on adding inputs to the UserForm How to deal with Images in UserForm Write information from UserFormCase study to add second UserForm and reuse the code How to create reports in PowerPoint from Excel data Case study to practice sending data to the PowerPoint slideBONUS: Archiving/Saving to SharePoint LibraryDrafting Outlook EmailsTemplate 'Set Powerful Goals'In the summary, this relatively short course is providing very simple solution that can be applied for easier data collection, decision making and reporting. In cases where instant online collaboration is not required but we want to be efficient - then this course will very likely be capable to solve the problem
