|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/office-2016-integrated-solution-development/
课程评论：没有评论
课程名称：Office 2016 综合解决方案开发 课程概述：本课程旨在教授学生如何使用 VBA 开发集成的 Office 解决方案。学员将学习如何利用宏和启用宏的模板在 Microsoft Office 的不同软件应用之间传递数据，收集数据并从其他文件及用户获取输入。学生无需具备 VBA 编码的基础，课程内容将教导他们如何自定义宏创建过程中生成的代码。这些解决方案可适应并应用于现实世界的情况，包括在 Word 中进行用户驱动的调查、在 Excel 中生成数据驱动的评分表、利用 Excel 中的数据在 Word 中生成信件并保存为 Word 或 pdf 文件，以及使用 Excel 数据选择动态输入文本和图像到现有的 Word 文档中。
This course will teach students how to develop integrated Office solutions using VBA. Solutions will use macros and macro-enabled templates to pass data back and forth among different software applications within Microsoft Office, collecting data and soliciting input from other files as well as from users. Students will not need to know how to code in VBA; the curriculum will teach them how to customize the code written during macro creation. Solutions can be adapted and applied to real world situations, including user-driven surveys in Word, data-driven score sheet production in Excel, generating letters in Word using data from Excel (and saving them as Word or pdf files), and using Excel data selections to drive dynamic input of text and images into existing Word documents.
