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

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

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

Instructor: Charlie Nuttelman

What you'll learn

Create a VBA user form that will implement or solve a real world scenario or problem

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

1 assignment

Taught in English

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

Learn more about Coursera for Business

Build your subject-matter expertise

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

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 5 modules in this course

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.

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".

What's included

2 videos6 readings1 assignment1 discussion prompt

2 videosTotal 7 minutes

Welcome6 minutesPreview module
How to Switch Sessions of the Course1 minute

6 readingsTotal 52 minutes

Is this course for you?10 minutes
For Mac users10 minutes
The importance of a Course Certificate and the future of higher education10 minutes
How to get help2 minutes
Opening macro-enabled workbooks10 minutes
Course files10 minutes

1 assignmentTotal 30 minutes

Unlock Quiz30 minutes

1 discussion promptTotal 10 minutes

(OPTIONAL) What about you?10 minutes

What's included

13 videos2 readings2 peer reviews

13 videosTotal 86 minutes

Introduction to the currency converter project4 minutesPreview module
How to run a data query8 minutes
Initializing the combo boxes and today's date8 minutes
Importing data from the currency website using proper date format10 minutes
Plotting the last 30 days10 minutes
Introduction to the Geography Toolbox project3 minutes
All about the "Geography Toolbox - STARTER.xlsm" file6 minutes
How to populate the first set of combo boxes7 minutes
How to populate the second set of combo boxes8 minutes
How to utilize the combo box selections6 minutes
How to calculate the distance between two points knowing latitude and longitude5 minutes
Expectations for input validation and error handling1 minute
How to unhide and hide sheets3 minutes

2 readingsTotal 20 minutes

Currency Converter - Problem Statement10 minutes
Geography Toolbox - Problem Statement10 minutes

2 peer reviewsTotal 120 minutes

Currency Converter Grading Rubric60 minutes
Geography Toolbox Grading Rubric60 minutes

What's included

19 videos2 readings2 peer reviews

19 videosTotal 126 minutes

Introduction to the Ultimate Organizer project7 minutesPreview module
A demonstration of the Ultimate Organizer7 minutes
How to add a category7 minutes
How to add a new record, Part 18 minutes
How to add a new record, Part 23 minutes
How to reveal hidden labels and text boxes9 minutes
How to add an icon to the Quick Access Toolbar to run your user form3 minutes
Introduction to the Regression Toolbox project4 minutes
Introduction to the "Regression Toolbox - STARTER.xlsm" file1 minute
All about simple linear regression8 minutes
All about general linear regression11 minutes
(OPTIONAL): All about multilinear regression9 minutes
Matrix approach to regression, Part 16 minutes
Matrix approach to regression, Part 27 minutes
A more complex example of the matrix approach to regression6 minutes
Using Excel’s matrix functions in VBA code5 minutes
What is adjusted R-squared?6 minutes
Calculating adjusted R-squared4 minutes
Plotting experimental data and model predictions in VBA4 minutes

2 readingsTotal 20 minutes

Ultimate Organizer - Problem Statement10 minutes
Regression Toolbox - Problem Statement10 minutes

2 peer reviewsTotal 120 minutes

Ultimate Organizer60 minutes
Regression Toolbox - Peer Review60 minutes

All learners are required to complete the Monte Carlo simulation, which is intermediate in difficulty.

What's included

10 videos1 reading1 peer review

10 videosTotal 79 minutes

Introduction to Monte Carlo simulation9 minutesPreview module
Monte Carlo cookie example9 minutes
How to output a random variable that follows a certain distribution3 minutes
The uniform distribution5 minutes
The discrete distribution6 minutes
The normal distribution5 minutes
The triangular distribution7 minutes
The Beta-PERT distribution9 minutes
How to apply a VBA user form to a Monte Carlo simulation13 minutes
An overview of the profitability analysis spreadsheet8 minutes

1 readingTotal 10 minutes

Monte Carlo Simulation Problem Statement10 minutes

1 peer reviewTotal 120 minutes

Monte Carlo Simulation120 minutes

If you are really up for a challenge, complete the Grade Manager project, which is very challenging. Learners who successfully create this project will earn an Honors designation on their Course Certificate.

What's included

13 videos1 reading1 peer review

13 videosTotal 114 minutes

Introduction to the Grade Manager Project9 minutesPreview module
Creating a new folder inside a preexisting directory7 minutes
Importing the Roster.xlsx file to a new sheet6 minutes
Creating section rosters from main roster file, Part 118 minutes
Creating section rosters from main roster file, Part 24 minutes
Initializing column headings on section roster files12 minutes
Syncing files, Part 110 minutes
Syncing files, Part 26 minutes
How to create a dated backup file5 minutes
Adding a new grade item to all section sheets, Part 18 minutes
Adding a new grade item to all section sheets, Part 28 minutes
Adding a new grade item to all section sheets, Part 35 minutes
Search and replace tool9 minutes

1 readingTotal 10 minutes

Grade Manager - Problem Statement10 minutes

1 peer reviewTotal 60 minutes

Grade Manager60 minutes

Instructor

Instructor ratings

4.9 (108 ratings)

Charlie Nuttelman

University of Colorado Boulder

9 Courses436,000 learners

Offered by

University of Colorado Boulder

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.9

455 reviews

5 stars
88.57%
4 stars
8.79%
3 stars
1.97%
2 stars
0.43%
1 star
0.21%

Showing 3 of 455

Reviewed on 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.

Reviewed on Jul 28, 2020

It was really nice project required all the learning of past 2 courses. I will recommend to complete 5 Week project as well as it really help to hone your skill.

Reviewed on May 28, 2020

Such a rewarding course and specialization! You really have the ability to create something from scratch after completing this one. Thanks Mr. Nuttelman for this experience!

View more reviews