Solving Business Problems with Spreadsheet Modeling

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.

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