|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-vba-programming-course/
课程评论：没有评论
**Coursera 课程《Excel VBA 编程课程》内容摘要** 本课程面向所有希望学习 Excel VBA 的学习者，即使您没有编程经验，也能掌握 VBA 的基础知识，并能创建复杂的 Excel 应用程序和实现自动化。 课程主要侧重于实践，辅以少量理论知识，并分享作者最佳的编程技巧。您将学习如何启用开发工具、录制宏、阅读和调试宏代码、创建用户界面 (UI)、开发应用程序，以及理解 Excel VBA 中类 (Classes) 和对象 (Objects) 的使用。 课程共分为六个部分，涵盖上述所有主题。通过学习，您将亲手创建三个不同复杂度的 Excel 应用程序：生命游戏、扫雷游戏和饮食管理应用。这些项目将帮助您深入理解不同的项目开发方法和编程技术。 为了便于学习和代码比对，每节编程课程都附有 Excel 文件和代码示例，方便您跟踪学习和查找错误。
This course is dedicated to everyone who wants to learn how to use VBA in Excel. You will learn how to create complex applications and perform automations in Excel environment.In this course we will start from total basics, so you don't need any programming experience at all to participate and learn how to code in Excel.We will mostly focus on practical and just a little on theoretical aspect of programming in Excel. I will show you best programming techniques I have learnt myself.We will cover topics such as enabling developer section, recording the macro, reading the recorded code, code debugging, creating user interfaces (UI), creating applications, usage of classes and objects in excel VBA.This course is split into 6 sections in which we will discuss each of mentioned topics. We will use gained knowledge to create 3 applications in Excel.These applications will be Life Game, Minesweeper Game and Diet Application. Each of them will present different level of task complexity. By creating these applications, we will learn different project approaches and programming techniques.To each programming lesson there will be an attachment with excel file and code created in current lecture so it will be easier for you to follow along with the course and find bugs by comparing the code you have created, with the one from the course.
