Solving Business Problems with Spreadsheet Modeling (Coursera)

Offered by Howard University,
Solving Business Problems with Spreadsheet Modeling (Coursera)

In this course, learners will be introduced to the capstone project and how to use advanced Data Analysis Tools to build spreadsheet models to solve a real-world business problem. In addition, learners will learn how to perform Correlation Analysis and Sensitivity Analysis using Microsoft Excel.

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

This course is part of the Business Problem Solving Specialization.

Syllabus

Introduction to Capstone and Correlation Analysis
This module introduces learners to the final project and describes how to perform correlation analysis to help make informed business decisions.

Sensitivity Analysis
This module explains how to perform sensitivity analysis using Microsoft Excel and provides business problem examples to practice.

Final Project
This module outlines the specifications for the final project. A sample business problem is also provided with step-by-step instructions.

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

Related Courses

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
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
Optimization for Decision Making (Coursera) Coursera
University of Minnesota

Optimization for Decision Making (Coursera)

In this data-driven world, companies are often interested in knowing what is the "best" course of action, given the data. For example, manufacturers need to decide how many units of a product to produce given the estimated demand and raw material availability? Should they make all the products in-house or buy some from a third-party to meet the demand? Prescriptive Analytics is the branch of analytics that can provide answers to these questions. It is used for prescribing data-based decisions.

Nov 9th 2026
4 Weeks
Process Data from Dirty to Clean (Coursera) Coursera
Google

Process Data from Dirty to Clean (Coursera)

This is the fourth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you’ll continue to build your understanding of data analytics and the concepts and tools that data analysts use in their work. You’ll learn how to check and clean your data using spreadsheets and SQL as well as how to verify and report your data cleaning results. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.

Nov 3rd 2026
5-12 Weeks
Excel Power Tools for Data Analysis (Coursera) Coursera
Macquarie University

Excel Power Tools for Data Analysis (Coursera)

Welcome to Excel Power Tools for Data Analysis. In this four-week course, we introduce Power Query, Power Pivot and Power BI, three power tools for transforming, analysing and presenting data. Excel's ease and flexibility have long made it a tool of choice for doing data analysis, but it does have some inherent limitations: for one, truly "big" data simply does not fit in a spreadsheet and for another, the process of importing and cleaning data can be a repetitive, time-consuming and error-prone.

Nov 9th 2026
4 Weeks
Data Visualization with Advanced Excel (Coursera) Coursera
PwC

Data Visualization with Advanced Excel (Coursera)

In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek.

Nov 9th 2026
4 Weeks
Statistics and Data Analysis with Excel, Part 2 (Coursera) Coursera
University of Colorado Boulder

Statistics and Data Analysis with Excel, Part 2 (Coursera)

This course is meant to be a direct continuation of "Statistics and Data Analysis with Excel, Part 1." Therefore, it is not recommended to take Part 2 unless you've also taken Part 1. Building on the topics learned in Part 1 of the course (probability, probability mass and density functions, the normal and standard normal distributions), this course dives into a more applied side of statistics.

Nov 16th 2026
5-12 Weeks
Work Smarter with Microsoft Excel (Coursera) Coursera
Microsoft

Work Smarter with Microsoft Excel (Coursera)

This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Excel. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required.

Nov 9th 2026
5-12 Weeks
Ask Questions to Make Data-Driven Decisions (Coursera) Coursera
Google

Ask Questions to Make Data-Driven Decisions (Coursera)

This is the second course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. You’ll build on your understanding of the topics that were introduced in the first Google Data Analytics Certificate course. The material will help you learn how to ask effective questions to make data-driven decisions, while connecting with stakeholders’ needs. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources.

Nov 3rd 2026
4 Weeks
Google Sheets - Advanced Topics (Coursera) Coursera
Google Cloud

Google Sheets - Advanced Topics (Coursera)

This course builds on some of the concepts covered in the earlier Google Sheets course. In this course, you will learn how to apply and customize themes In Google Sheets, and explore conditional formatting options. You will learn about some of Google Sheets’ advanced formulas and functions. You will explore how to create formulas using functions, and you will also learn how to reference and validate your data in a Google Sheet.

Nov 16th 2026
1 Week
Excel Modeling for Professionals: Best Practices & Pitfalls (Coursera) Coursera
Delft University of Technology,Erasmus University Rotterdam

Excel Modeling for Professionals: Best Practices & Pitfalls (Coursera)

Through this course learners will gain the tools to decide whether or not Excel is the right software to use. They will learn how to set up good input data, format correctly, and the importance of good documentation. Learners will gain the ability to discern between different functions, to understand the pitfalls and strengths of commonly used functions, and to apply correct functions to their excel models. Those that follow the course will also gain understanding of logical spreadsheet structure, graphs and reporting, and protection and hidden information in Excel, and users will learn how to apply these things to their own models.

Nov 9th 2026
4 Weeks