|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advance-ms-excel-vba-for-beginner-to-advanced/
课程评论：没有评论
**课程名称：** 高级 Excel VBA：从入门到精通 **课程概述：** 本课程旨在帮助您系统学习 Microsoft Excel VBA，从基础知识到高级应用。通过一系列项目驱动的学习，您将建立坚实的 Excel 宏和 VBA 工作基础。课程内容循序渐进，每个项目都将引入新的概念，从基础的自动化任务构建，最终达到能够创建完全自定义的 VBA 项目来自动化复杂 Excel 任务。 您将首先学习如何使用宏录制器创建简单宏，然后深入学习 Excel VBA，构建更具动态性和健壮性的解决方案。每项项目都提供可下载的练习文件，并配有详细的视频讲解和 PDF 参考资料。 **课程将带领您完成的项目示例包括：** * 自动化工作表标题的放置和格式设置。 * 通过输入框 (Input Boxes) 和消息框 (Message Boxes)与用户互动，获取宏的运行参数。 * 清理多个 Excel 工作表，为数据报告做好准备。 * 基于多个工作表的数据创建汇总报告，并将数据复制到主报告工作表中。 * 自动化创建 Excel 公式以汇总报告数据。 * 使用 VBA 用户窗体 (User Forms)。 * 从外部文本文件导入数据。 通过完成这些项目，您将掌握关键的 Excel VBA 编程概念，并学会识别和应用最佳实践来创建高效的 Excel 宏。
Do you looking for learning MS Excel VBA from basic to advanced? than you are in right place. During this course you will build a foundation of working with Excel Macros and VBA. This foundation will be built as you engage and participate in project based Excel Macro/VBA exercises, detailed throughout the lectures within this course. Each of the projects will build upon one another, introducing a new concept each time, starting with the basic building blocks of automating any task within Excel and ending with a fully customized Excel VBA project that will automate a series of Excel tasks.As you engage and participate in this course, you will be introduced to the wonders of creating simple Macros through the Macro Recorder and then quickly take you into the world of Excel VBA where you will experience building a more dynamic, robust experience for yourself and your peers.Each project contains exercise files that you can download and use to complete the assigned Excel Macro/VBA projects. The course also contains detailed instructions through the video lectures as well as a series of PDF documents that you can reference as you complete the projects.Below are a few samples of the projects you will complete by enrolling and participating in this course.Automate placing and formatting a title on a worksheetInteract with the users of your Macros through Input and Message boxes in order to receive input on how a Macros should workCleaning up multiple Excel Worksheets and prepare the data to be reported onCreate a report based on multiple sets of data found within multiple Excel Worksheets, copying data from one Worksheet into the Master Report WorksheetAutomate the creation of Excel Formulas to SUM data up in your ReportWorking with Excel VBA User FormsImporting Data from External Text FilesEach of these projects will direct you through key Excel VBA programming concepts and direct you to identify and use best practices in creating Excel Macros.
