|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/master-microsoft-excel-macros-and-vba-with-5-simple-projects/
课程评论：没有评论
Coursera 课程“掌握 Microsoft Excel 宏和 Excel VBA” 本课程旨在帮助您学习如何通过 Excel 宏和 VBA 自动化日常任务，从而掌控 Microsoft Excel。 本课程将为您打下坚实的 Excel 宏和 VBA 工作基础。您将通过一系列项目练习来学习，每个项目都建立在前一个项目的基础上，引入新的概念。课程将从最基础的自动化任务开始，最终您将能够完成一个高度定制化的 Excel VBA 项目，自动化一系列 Excel 任务。 您将从使用宏录制器创建简单的宏开始，然后深入学习 Excel VBA，以构建更具动态性、更强大的自动化体验。课程提供可下载的练习文件，并辅以详细的视频讲解和 PDF 文档。 您将完成的项目包括： * 自动化工作表标题的放置和格式化 * 使用输入框和消息框与宏用户交互 * 清理多个 Excel 工作表并准备数据以供报告 * 根据多个工作簿中的数据创建报告 * 自动化创建 Excel 公式以汇总数据 * 使用 Excel VBA 用户窗体 * 从外部文本文件导入数据 通过这些项目，您将掌握关键的 Excel VBA 编程概念，并学会识别和应用最佳实践。立即报名 enrol，让 Excel 为您工作！
Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016 Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA. 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 Files Each 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. So, don't lose another moment performing Excel tasks manually. Enroll now and learn how you can get Microsoft Excel to your work for you.
