|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-automation-learn-vba-macros-from-scratch/
课程评论：没有评论
**课程名称：** Excel自动化：从零开始学习VBA和宏！ **课程概述：** 本课程专为现有的Excel用户设计，旨在通过自动化手动/重复性工作，让您的生活更简单、更智能。 **常见问题解答：** * **Q: 我从未接触过编程，也没有VBA背景，还能学会吗？** * A: 可以！本课程主要面向完全零基础的编程新手。我已成功培训了超过5000名没有编程背景的学生。 * **Q: 我学习能力不强，觉得很难理解和操作代码/编程。我能学会吗？** * A: 我认为自己是“最差的学生”。如果我能学会，您也能。 * **Q: 为什么编程/代码被认为很难？记忆力不好的人能学会吗？** * A: 任何事物，如果缺乏足够的背景知识，学习起来都会觉得困难。本课程会解释概念背后的“为什么”。我本人记忆力也不是很好，所以我确保使用简单的语言、贴切的例子，并提供充分的概念背景。 * **Q: 我会录制宏，而且做得还不错。这门课还有什么更深层次的内容？** * A: 录制宏只是学习的一部分。VBA中还有许多概念，能帮助您更智能、更高效地编写代码。本课程不仅仅围绕录制宏，更侧重于**从零开始编写宏**。我们的目标是让您充分理解代码，从而能够创建更智能的宏。具体课程内容请参考课程详情。 **核心理念：** “如果你觉得某个东西很复杂或不适合你，那常常是因为你跳过了基础，直接去学习高级概念。”——本课程致力于为每个概念提供充足的背景知识，并强调基础知识，以确保您能正确学习并能随时重现所学概念。 **课程目标：** 完成本课程后，您将能够： * 从头开始构建完整的宏。 * 编写自己的宏。 * 理解自己的宏。 * 编辑/修改宏以提高性能。 * 创建自定义用户函数。 * 在各种事件上自动执行宏。 * 将所学概念灵活应用于不同的问题。 * 开始爱上编码（如果您目前不爱的话）。 期待在课程中与您进行更多交流，祝您学习愉快！ **课程大纲：** 无
This course is built for Existing Excel users who would like to make their life more simpler and smarter by automating manual/repetitive work in Excel.FAQsQ: I've never done coding before and have no background to VBA. Can I still learn it?A: Yes, This course is mainly targeted to those who are absolutely new to coding/programming. I've trained over 5000 students with no programming background successfully. Q: I'm not a great learner, I find difficulty understanding and working with codes/programming. can I learn it?A: I consider myself as the worst student. So if I can learn it, you can too. Q: Why is coding/programming considered so difficult? Can a person with not a great memory learn it?A: Anything is difficult to remember and understand, if you do not have ample background to it, which answers the "WHYs?" of those concepts. Moreover, I'm myself the person who's not too great at memory, and that makes me ensure that I use simple language, with relatable examples and provide ample background to the concepts in my course. Q: I know how to record macros and I'm doing pretty well? What more this course has to offer?A: Recording is just one part of your learning. there are many more concepts in VBA which a person should know, to get smarter and more efficient at coding. This course doesn't revolve around recording the macros only. It focuses more on how to Write the macros from scratch. The idea is to make sure you are able to understand the codes so well, that it becomes easy for you to make more smarter macros going forward. Refer to the course contents of this course to know the details of what will be covered in this course. "If you feel something is complicated or not your cup of tea, its majorly because you tried jumping on the advanced concepts rather than absorbing the basics first" - This course is an effort to provide ample background of each concepts and stresses on the fundamental areas to ensure that you learn it correctly and can re-implement the concepts when required.After completing this course you will be able to: Build your own full fledged macros from scratchWrite your macrosUnderstand your macrosEdit/Modify your macros to improve performanceCreate your own User Defined FunctionsAuto execute Macros on Several Events.Re implement the concepts to different problemsStart Loving to code (in case you currently don't)Looking forward to having more interactions with you in the course.Happy Learning!
