In this course, learners will complete several VBA projects. It is highly recommended that learners first take "Excel/VBA for Creative Problem Solving, Part 1" and "Excel/VBA for Creative Problem Solving, Part 2". This course builds off of skills learned in those two courses. This is a project-based course. Therefore, the projects are quite open-ended and there are multiple ways to solve the problems. Through the use of Peer Review, other learners will grade learners' projects based on a grading rubric.
提供方
课程信息
22,736 次近期查看
可灵活调整截止日期
根据您的日程表重置截止日期。
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
第 3 门课程（共 3 门）
高级
完成时间大约为16 小时
英语（English）
字幕：阿拉伯语（Arabic）, 法语（French）, （欧洲人讲的）葡萄牙语, 意大利语, 越南语, 德语（German）, 俄语（Russian）, 英语（English）, 西班牙语（Spanish）
可灵活调整截止日期
根据您的日程表重置截止日期。
可分享的证书
完成后获得证书
100% 在线
立即开始，按照自己的计划学习。
第 3 门课程（共 3 门）
高级
完成时间大约为16 小时
英语（English）
字幕：阿拉伯语（Arabic）, 法语（French）, （欧洲人讲的）葡萄牙语, 意大利语, 越南语, 德语（German）, 俄语（Russian）, 英语（English）, 西班牙语（Spanish）
提供方
科罗拉多大学波德分校
CU-Boulder is a dynamic community of scholars and learners on one of the most spectacular college campuses in the country. As one of 34 U.S. public institutions in the prestigious Association of American Universities (AAU), we have a proud tradition of academic excellence, with five Nobel laureates and more than 50 members of prestigious academic academies.
授课大纲 - 您将从这门课程中学到什么
完成时间为 1 小时
Getting Started
This first module introduces the course and provides some background material. Paid learners have access to the course files, which are unlocked when you complete the "Unlock Quiz".
完成时间为 1 小时
2 个视频 （总计 7 分钟）, 4 个阅读材料, 1 个测验
完成时间为 4 小时
Easy Projects: Lesson Choices
完成时间为 4 小时
13 个视频 （总计 87 分钟）, 2 个阅读材料, 2 个测验
完成时间为 4 小时
Intermediate Projects: Lesson Choices
完成时间为 4 小时
19 个视频 （总计 127 分钟）, 2 个阅读材料, 2 个测验
完成时间为 3 小时
Monte Carlo Simulation
All learners are required to complete the Monte Carlo simulation, which is intermediate in difficulty.
完成时间为 3 小时
10 个视频 （总计 79 分钟）, 1 个阅读材料, 1 个测验
审阅
来自EXCEL/VBA FOR CREATIVE PROBLEM SOLVING, PART 3 (PROJECTS)的热门评论
由 SA 提供Jul 2, 2021
This is one of the best courses I have take so far. Real problem solving projects make this part (part 3) challenging as well as exciting. It sets you up for taking challenges of your own projects.
由 DC 提供Sep 27, 2018
Projects were enjoyable and challenging. Instructor is excellent -- does a great job of explaining the material and interacting with learners. Content very relevant to real-world projects.
由 VV 提供Oct 14, 2018
The course was really good. It helped me gain knowledge about the various aspects of excel which had been untouched by me. It has helped me in my professional endeavours too. Thank You
由 XS 提供Apr 11, 2020
Best course on how to use Excel/Vba for solving engineering and management problems. Applying Monte carlo simulation to practical problems has never been easier before taking this course.
关于 Excel/VBA for Creative Problem Solving 专项课程
This Specialization is for learners wishing to dramatically change the way that they use Excel spreadsheets by unleashing the power to automate and optimize spreadsheets using Visual Basic for Applications (VBA). The first two courses will teach learners the basics of VBA through the use of dozens of educational screencasts and a series of quizzes and in-application programming assignments. Finally, in Part 3 of the course, learners will complete 3 "real world" and somewhat open ended projects, which are graded through peer review.
常见问题
我什么时候能够访问课程视频和作业？
我订阅此专项课程后会得到什么？
有助学金吗？
还有其他问题吗？请访问 学生帮助中心。
