Excel/VBA for Creative Problem Solving 專項課程

Optimize Your Excel Spreadsheets With VBA。 Learn how to automate your Excel spreadsheets with Visual Basic for Applications

本專項課程介紹

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.

製作方：

3 courses

按照建議的順序或選擇您自己的順序。

項目

旨在幫助您實踐和應用所學到的技能。

證書

在您的簡歷和領英中展示您的新技能。

項目概覽

Learners will complete one easy project (chosen from two potential projects), one intermediate project (chosen from two potential projects), and a third, required Monte Carlo simulation project (intermediate in difficulty). Projects include: Real-Time Currency Converter, Geography Toolbox, Ultimate Organizer, Regression Toolbox, Monte Carlo Simulation, and Grade Manager.

課程

Beginner Specialization.: No prior experience required.

第 1 門課程
Excel/VBA for Creative Problem Solving, Part 1
計劃開課班次：Jul 23
課程學習時間
5 weeks of study, 2-4 hours/week
字幕
English
課程概述
"Excel/VBA for Creative Problem Solving, Part 1" is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their Excel spreadsheet skills by tapping into the powerful programming, automation, and customiz
您可以選擇只參加本課程。 了解更多。
第 2 門課程
Excel/VBA for Creative Problem Solving, Part 2
計劃開課班次：Jul 23
課程學習時間
4 weeks of study, 3-5 hours/week
字幕
English
課程概述
"Excel/VBA for Creative Problem Solving, Part 2" builds off of knowledge and skills obtained in "Excel/VBA for Creative Problem Solving, Part 1" and is aimed at learners who are seeking to augment, expand, optimize, and increase the efficiency of their
您可以選擇只參加本課程。 了解更多。
第 3 門課程
Excel/VBA for Creative Problem Solving, Part 3 (Projects)
當前班次：Jul 16
課程學習時間
3-4 weeks of study, 3-5 hours/week
字幕
English
課程概述
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 s
您可以選擇只參加本課程。 了解更多。

製作方

Set in one of the world's most inspiring and entrepreneurial learning environments, the University of Colorado Boulder enables each member of our community to reach their potential and to Be Boulder through an extraordinary range of challenging academic, research and service opportunities.
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.

Charlie Nuttelman
Instructor

FAQs

More questions? Visit the Learner Help Center.