|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/visual-basic-for-applications-the-complete-course/
课程评论:没有评论
【课程名称】Visual Basic for Applications - Excel VBA - The full course 【课程概述】 本课程是关于使用Microsoft Excel的Visual Basic for Applications (VBA)进行应用程序开发的全面课程。课程内容包括200多个视频,每个视频都由在为各种规模企业(小型、中型及大型)开发MS Excel或MS Access应用程序方面拥有丰富经验的专家制作。这些专家曾作为顾问、经理和内部流程教练,创建了复杂的工具来构建报告结构和管理业务流程。 本课程将从基础概念讲起,逐步引导您掌握使用Excel VBA构建自己应用程序的原理。您将深入理解面向对象编程的概念,消除对编程代码的恐惧感。通过学习,您将能够从数据库或其他文件中检索数据,并将其呈现在Excel文件中。此外,您还将学会创建自动化程序,用于数据格式化、信息显示,以及制作复杂的报告和图表。扩展版本将包含可以直接应用于实际工作和办公流程的真实案例。
The course is composed of more than 200 videos. Each lesson is composed of one of more videos. The videos are created by experts developing applications using Visual Basic for Application (VBA) for MS Excel or MS Access for small, middle and large companies as consultants and as managers and coach for internal processes. These experts have created complex tools to create the reporting structure and manage the business processes. An extended version will include also real examples to be used directly in working and office processes.You will learn from the basic concepts to the principles to build your own applications in Excel using VBA.You will understand and digest the concept of object oriented programming and remove your barriers from being scared to see programming code.You will be able to retrieve data from databases or other files and present them in Excel files.You will create automated procedure to format data, display information and create complex reports and graphs.