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

Save on skills that make you shine with 40% off 3 months of Coursera Plus. Save now

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

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

Instructor: Charlie Nuttelman

26,183 already enrolled

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

464 reviews

Advanced level

Designed for those already in the industry

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

97%

Most learners liked this course

5 modules

Gain insight into a topic and learn the fundamentals.

464 reviews

Advanced level

Designed for those already in the industry

Flexible schedule

2 weeks at 10 hours a week

Learn at your own pace

97%

Most learners liked this course

What you'll learn

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

Skills you'll gain

Tools you'll learn

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

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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

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 videos7 readings1 assignment1 discussion prompt

2 videosTotal 7 minutes

Welcome6 minutes
How to Switch Sessions of the Course1 minute

7 readingsTotal 53 minutes

Course Updates and Accessibility Support1 minute
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 87 minutes

Introduction to the currency converter project5 minutes
How to run a data query9 minutes
Initializing the combo boxes and today's date8 minutes
Importing data from the currency website using proper date format11 minutes
Plotting the last 30 days10 minutes
Introduction to the Geography Toolbox project4 minutes
All about the "Geography Toolbox - STARTER.xlsm" file7 minutes
How to populate the first set of combo boxes7 minutes
How to populate the second set of combo boxes9 minutes
How to utilize the combo box selections7 minutes
How to calculate the distance between two points knowing latitude and longitude6 minutes
Expectations for input validation and error handling2 minutes
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 127 minutes

Introduction to the Ultimate Organizer project8 minutes
A demonstration of the Ultimate Organizer8 minutes
How to add a category7 minutes
How to add a new record, Part 18 minutes
How to add a new record, Part 24 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 project5 minutes
Introduction to the "Regression Toolbox - STARTER.xlsm" file2 minutes
All about simple linear regression9 minutes
All about general linear regression12 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 regression7 minutes
Using Excel’s matrix functions in VBA code6 minutes
What is adjusted R-squared?6 minutes
Calculating adjusted R-squared5 minutes
Plotting experimental data and model predictions in VBA5 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 minutes
Monte Carlo cookie example9 minutes
How to output a random variable that follows a certain distribution4 minutes
The uniform distribution6 minutes
The discrete distribution7 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 115 minutes

Introduction to the Grade Manager Project10 minutes
Creating a new folder inside a preexisting directory8 minutes
Importing the Roster.xlsx file to a new sheet6 minutes
Creating section rosters from main roster file, Part 119 minutes
Creating section rosters from main roster file, Part 25 minutes
Initializing column headings on section roster files13 minutes
Syncing files, Part 110 minutes
Syncing files, Part 27 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 29 minutes
Adding a new grade item to all section sheets, Part 36 minutes
Search and replace tool10 minutes

1 readingTotal 10 minutes

Grade Manager - Problem Statement10 minutes

1 peer reviewTotal 60 minutes

Grade Manager60 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(109 ratings)

Charlie Nuttelman

University of Colorado Boulder

10 Courses484,468 learners

Offered by

University of Colorado Boulder

Explore more from Algorithms

Status: Free Trial
University of Colorado Boulder
Excel/VBA for Creative Problem Solving, Part 2
Course
Status: Free Trial
University of Colorado Boulder
Excel/VBA for Creative Problem Solving, Part 1
Course
Status: Free Trial
University of Colorado Boulder
Excel/VBA for Creative Problem Solving
Specialization
Status: Free Trial
University of Colorado Boulder
Everyday Excel, Part 3 (Projects)
Course

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

5 stars
88.79%
4 stars
8.62%
3 stars
1.93%
2 stars
0.43%
1 star
0.21%

Showing 3 of 464

Reviewed on Dec 17, 2023

Really enjoyed putting what I have learned from Part 1 and Part 2 into these interesting, yet career-relevant projects. Charlie is a great instructor! Friendly yet thorough

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 Jan 27, 2020

Projects are focused mainly on userforms, which was not exactly what I'd be primarily interested in. However, still good final for good series.

View more reviews

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.

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.

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.