|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/use-excel-vba-macros-automate-chemical-engineering-work-tasks/
课程评论：没有评论
**课程名称：** 使用VBA自动化任务（面向化学工程师） **课程概述：** 本课程旨在帮助学员摆脱繁琐、重复的手动任务，提高工作效率，减少错误。通过学习Excel VBA宏，您可以实现任务自动化，节省宝贵时间，并将精力集中在更具思考性的工作上。 **课程内容：** * **Excel开发者工具与宏基础：** 了解Excel开发者工具栏，学习如何录制和编写宏。 * **核心编程概念：** 掌握数据类型、条件判断、循环结构和函数等基本编程原理。 * **Excel对象模型：** 深入理解Excel提供的对象，包括工作簿、工作表和单元格，学习如何通过代码访问和操作Excel文件。 * **实际应用与自动化：** * 基于用户输入的Excel输入框显示数据。 * 根据需求格式化和分组表格，并将其添加到不同的工作表中。 * 将外部工作表链接到主工作表，并根据用户在特定单元格的输入进行数据关联。 * 创建自定义函数，可在Excel公式中使用。 * 实现文件间数据的自动复制。 * 批量处理文件：创建新目录、生成所需格式的文件、从每个文件中复制数据到对应的新文件中，并将新文件保存为PDF格式。这一切都可通过一个按钮点击完成。 **学习方式：** 课程将采用循序渐进的教学方式，详细演示代码编写过程，并提供解决常见错误的指导和测试结果的方法，确保学员在应用宏之前能够充分验证其有效性。 **期待在课程中与您相见！**
So maybe you have many repetitive tasks that you are doing manually. These are consuming a lot of time, and are prone to mistakes. If this is the case, then this course is for you.What if we can automate our tasks? This would save us a lot of time, reduce the probability of making mistakes or even eliminate it, and shall let us focus on tasks that need more thinking. This can be done using Excel VBA macros.So through this course, we see: What the Excel developer ribbon looks like, and how to record or write a macro.Main programming concepts, such as data types, conditions, loops, and functions.Discover Excel objects, which are the main interface Excel gives us to access its workbook files and worksheets up to cells.Then we shall start the real fun, we shall start applying the above concepts to create macros that can automate tasks. Examples may be more related to chemical engineering tasks, but the concept still applies to tasks related to any field.With a button click, we shall: Display data based on user input on Excel Input BoxSee how to group tables in the format we need and add them to different sheets.Add external sheets to our Excel calculation and link them with the main sheet depending on the user input on specific cells.Create custom functions that can be used as an Excel formulaCopy data from a file to another automaticallyApply the previous point on a bulk of files, where we shall: Create a new directoryGenerate files format we needCopy data from each file to the corresponding new fileSave the new file as pdfAll this with a button click.Through the course, we shall write code step by step, we shall see errors and how to solve them, and how to test the results before applying the macros.Hope to see you in the course!!
