web analytics

Excel/VBA for Creative Problem Solving Specialization

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.

Applied Learning Project

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.

Course Information

Estimated Time: Approximately 4 months to complete Suggested pace of 4 hours/week

Difficulty: Beginner

Free

Enroll

Course Information

Estimated Time: Approximately 4 months to complete Suggested pace of 4 hours/week

Difficulty: Beginner