This course is part of the Excel/VBA for Creative Problem Solving Specialization

4.9
stars
419 ratings

Charlie Nuttelman

21,671 already enrolled

Offered By

Excel/VBA for Creative Problem Solving SpecializationUniversity of Colorado Boulder

About this Course

15,646 recent views

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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 3 of 3 in the

Excel/VBA for Creative Problem Solving Specialization

Advanced Level

Approx. 16 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Coursera Labs

Includes hands on learning projects.

Learn more about Coursera Labs

Course 3 of 3 in the

Excel/VBA for Creative Problem Solving Specialization

Advanced Level

Approx. 16 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.84/5 (95 Ratings)

Charlie Nuttelman

Senior Instructor

Chemical and Biological Engineering

350,640 Learners

6 Courses

Offered by

University of Colorado Boulder

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Content Rating97%(1,216 ratings)

Week1

Week 1

2 hours to complete

Getting Started

2 hours to complete

2 videos (Total 7 min), 7 readings, 1 quiz

Week2

Week 2

4 hours to complete

Easy Projects: Lesson Choices

4 hours to complete

13 videos (Total 87 min), 2 readings, 2 quizzes

13 videos

Introduction to the currency converter project4mHow to run a data query8mInitializing the combo boxes and today's date8mImporting data from the currency website using proper date format10mPlotting the last 30 days10mIntroduction to the Geography Toolbox project3mAll about the "Geography Toolbox - STARTER.xlsm" file6mHow to populate the first set of combo boxes7mHow to populate the second set of combo boxes8mHow to utilize the combo box selections6mHow to calculate the distance between two points knowing latitude and longitude5mExpectations for input validation and error handling1mHow to unhide and hide sheets3m

2 readings

Currency Converter - Problem Statement10mGeography Toolbox - Problem Statement10m

Week3

Week 3

4 hours to complete

Intermediate Projects: Lesson Choices

4 hours to complete

19 videos (Total 127 min), 2 readings, 2 quizzes

19 videos

Introduction to the Ultimate Organizer project7mA demonstration of the Ultimate Organizer7mHow to add a category7mHow to add a new record, Part 18mHow to add a new record, Part 23mHow to reveal hidden labels and text boxes9mHow to add an icon to the Quick Access Toolbar to run your user form3mIntroduction to the Regression Toolbox project4mIntroduction to the "Regression Toolbox - STARTER.xlsm" file1mAll about simple linear regression8mAll about general linear regression11m(OPTIONAL): All about multilinear regression9mMatrix approach to regression, Part 16mMatrix approach to regression, Part 27mA more complex example of the matrix approach to regression6mUsing Excel’s matrix functions in VBA code5mWhat is adjusted R-squared?6mCalculating adjusted R-squared4mPlotting experimental data and model predictions in VBA4m

2 readings

Ultimate Organizer - Problem Statement10mRegression Toolbox - Problem Statement10m

Week4

Week 4

3 hours to complete

Monte Carlo Simulation

3 hours to complete

10 videos (Total 79 min), 1 reading, 1 quiz

10 videos

Introduction to Monte Carlo simulation9mMonte Carlo cookie example9mHow to output a random variable that follows a certain distribution3mThe uniform distribution5mThe discrete distribution6mThe normal distribution5mThe triangular distribution7mThe Beta-PERT distribution9mHow to apply a VBA user form to a Monte Carlo simulation13mAn overview of the profitability analysis spreadsheet8m

1 reading

Monte Carlo Simulation Problem Statement10m

Reviews

4.9

140 reviews

5 stars
88.54%
4 stars
8.83%
3 stars
2.14%
2 stars
0.23%
1 star
0.23%

TOP REVIEWS FROM EXCEL/VBA FOR CREATIVE PROBLEM SOLVING, PART 3 (PROJECTS)

by KOApr 13, 2021

Great course! Well designed assignments to test knowledge. Great lecturer with clear communication.

Definitely picked up some VBA skills from this course.

by AMOct 28, 2018

All the spcialization is absolutely amazing, you will not only learn how to make impressive tools in excel VBA, but also a lot of other things!

by SBJun 2, 2020

Thank you dear instructor. It was fantastic to be part of this specialization. I strongly recommend this course any who wants to learn Excel VBA.

by IAJul 7, 2020

This is an interesting course to polish VBA skills into usable worksheets and Excel Apps!

100% Recommended!

View all reviews

About the Excel/VBA for Creative Problem Solving Specialization

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.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

Excel/VBA for Creative Problem Solving, Part 3 (Projects)

About this Course