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

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

In this course, learners will complete several VBA projects. 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.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

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.
Course 3 of 3 in the Excel/VBA for Creative Problem Solving Specialization.

Syllabus

WEEK 1
Getting Started
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".

WEEK 2
Easy Projects: Lesson Choices

WEEK 3
Intermediate Projects: Lesson Choices

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

WEEK 5
Grade Manager Project (for Honors)
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.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Exploration et production de données pour les entreprises (Coursera) Coursera
University of Illinois at Urbana-Champaign

Exploration et production de données pour les entreprises (Coursera)

Ce cours fournit un cadre analytique afin de vous aider à évaluer les problèmes clés de manière structurée. Il vous procurera également des outils afin de mieux gérer les incertitudes qui envahissent et compliquent les processus des entreprises. Plus précisément, vous serez initié(e) aux statistiques et à la manière de résumer les données. Vous découvrirez les concepts de fréquence, de loi normale, d’études statistiques, de l’échantillonnage et des intervalles de confiance.

Nov 9th 2026
4 Weeks
Mastering Excel Essentials to Enhance Business Value (Coursera) Coursera
Illinois Tech

Mastering Excel Essentials to Enhance Business Value (Coursera)

This course is designed to cater to a diverse audience, particularly those with an interest in working in dynamic environments that place a strong emphasis on data-driven, quantitative analysis. Whether you are an experienced professional seeking to enhance your skills or someone looking to pivot into a cutting-edge industry, this course provides valuable insights and knowledge to thrive in today's data-centric and rapidly evolving landscape.

Nov 9th 2026
4 Weeks
Microsoft 365 Copilot: Personal Productivity for All (Coursera) Coursera
Vanderbilt University

Microsoft 365 Copilot: Personal Productivity for All (Coursera)

Dive into the next wave of digital productivity with our course centered on Microsoft 365 Copilot. As impactful as the smartphone revolution, Microsoft 365 Copilot is poised to redefine how we approach myriad tasks, bringing the nuanced capabilities of generative AI to your fingertips. With this course, discover how to leverage this powerful assistant in your daily routine, transforming every challenge into an opportunity for excellence.

Nov 16th 2026
1 Week
Using Public Policy for Social Change (Coursera) Coursera
University of Michigan

Using Public Policy for Social Change (Coursera)

Using Public Policy for Social Change provides a comprehensive introduction to public policy and its role in addressing societal challenges, with a focus on social inequalities. You’ll explore various areas of policy work, including social welfare, public health, the environment, education, and criminal justice. Learn the fundamentals of public policy design and analysis, and how policymaking functions across all levels of government in democracies worldwide.

Nov 9th 2026
4 Weeks
Statistical Thinking for Industrial Problem Solving, presented by JMP (Coursera) Coursera
SAS

Statistical Thinking for Industrial Problem Solving, presented by JMP (Coursera)

Statistical Thinking for Industrial Problem Solving is an applied statistics course for scientists and engineers offered by JMP, a division of SAS. By completing this course, students will understand the importance of statistical thinking, and will be able to use data and basic statistical methods to solve many real-world problems.

Nov 16th 2026
5-12 Weeks
Fundamentals of Data Analysis in Excel (Coursera) Coursera
Corporate Finance Institute

Fundamentals of Data Analysis in Excel (Coursera)

Excel is the most widely used analysis tool in the world and a great starting point for diving into data analysis. In this course, you’ll apply Excel’s native tools to structure your data into spreadsheets and tables. You’ll then analyze and produce insights from that data using pivot tables. Finally, you’ll visualize those insights by building a dashboard in Excel. You’ll apply these skills using modern functionality like dynamic array formulas, linked data types, and Ideas in Excel. You’ll work hands-on with real-world scenarios, using datasets pulled from financial statements and retail sales.

Nov 16th 2026
5-12 Weeks
Business Analytics with Excel: Elementary to Advanced (Coursera) Coursera
Johns Hopkins University

Business Analytics with Excel: Elementary to Advanced (Coursera)

A leader in a data driven world requires the knowledge of both data-related (statistical) methods and of appropriate models to use that data. This Business Analytics class focuses on the latter: it introduces students to analytical frameworks used for decision making though Excel modeling. These include Linear and Integer Optimization, Decision Analysis, and Risk modeling. For each methodology students are first exposed to the basic mechanics, and then apply the methodology to real-world business problems using Excel.

Nov 16th 2026
5-12 Weeks
Data Visualization and Communication with Tableau (Coursera) Coursera
Duke University

Data Visualization and Communication with Tableau (Coursera)

One of the skills that characterizes great business data analysts is the ability to communicate practical implications of quantitative analyses to any kind of audience member. Even the most sophisticated statistical analyses are not useful to a business if they do not lead to actionable advice, or if the answers to those business questions are not conveyed in a way that non-technical people can understand. In this course you will learn how to become a master at communicating business-relevant implications of data analyses.

Nov 2nd 2026
5-12 Weeks
Problem Solving Using Computational Thinking (Coursera) Coursera
University of Michigan

Problem Solving Using Computational Thinking (Coursera)

Have you ever heard that computers "think"? Believe it or not, computers really do not think. Instead, they do exactly what we tell them to do. Programming is, "telling the computer what to do and how to do it." Before you can think about programming a computer, you need to work out exactly what it is you want to tell the computer to do. Thinking through problems this way is Computational Thinking. Computational Thinking allows us to take complex problems, understand what the problem is, and develop solutions. We can present these solutions in a way that both computers and people can understand.

Nov 9th 2026
5-12 Weeks
Business Metrics for Data-Driven Companies (Coursera) Coursera
Duke University

Business Metrics for Data-Driven Companies (Coursera)

In this course, you will learn best practices for how to use data analytics to make any company more competitive and more profitable. You will be able to recognize the most critical business metrics and distinguish them from mere data. You’ll get a clear picture of the vital but different roles business analysts, business data analysts, and data scientists each play in various types of companies. And you’ll know exactly what skills are required to be hired for, and succeed at, these high-demand jobs.

Nov 2nd 2026
4 Weeks
Basic Modeling for Discrete Optimization (Coursera) Coursera
University of Melbourne,The Chinese University of Hong Kong

Basic Modeling for Discrete Optimization (Coursera)

Optimization is a common form of decision making, and is ubiquitous in our society. Its applications range from solving Sudoku puzzles to arranging seating in a wedding banquet. The same technology can schedule planes and their crews, coordinate the production of steel, and organize the transportation of iron ore from the mines to the ports. Good decisions in manpower and material resources management also allow corporations to improve profit by millions of dollars.

Nov 9th 2026
4 Weeks
Bayesian Statistics: Techniques and Models (Coursera) Coursera
University of California, Santa Cruz

Bayesian Statistics: Techniques and Models (Coursera)

This is the second of a two-course sequence introducing the fundamentals of Bayesian statistics. It builds on the course Bayesian Statistics: From Concept to Data Analysis, which introduces Bayesian methods through use of simple conjugate models. Real-world data often require more sophisticated models to reach realistic conclusions. This course aims to expand our “Bayesian toolbox” with more general models, and computational techniques to fit them.

Nov 2nd 2026
5-12 Weeks