Advanced Business Analytics: Excel Optimization & Simulation

本课程是 Business Analytics with Excel 专项课程 的一部分

位教师： Joseph W. Cutrone, PhD

4,419 人已注册

包含在 Coursera Plus • 了解更多 中

54 条评论

您将获得的技能

Risk Analysis

Business Modeling

Analytics

Simulation and Simulation Software

Business Analytics

Resource Allocation

Model Optimization

Data-Driven Decision-Making

您将学习的工具

Microsoft Excel

要了解的详细信息

添加到您的领英档案

5 项作业

了解顶级公司的员工如何掌握热门技能

积累特定领域的专业知识

向行业专家学习新概念

获得对主题或工具的基础理解

通过实践项目培养工作相关技能

获得可共享的职业证书

该课程共有5个模块

This course equips learners with advanced skills in building and analyzing models using Excel to solve real-world business problems.

Participants will learn to optimize decision-making processes using Solver, conduct sensitivity analysis to refine model outcomes, and apply advanced integer programming techniques to tackle complex scenarios.

The course also covers sophisticated methods for solving assignment and transportation problems and introduces simulation techniques to analyze uncertainty and variability in decision-making.

By the end of this course, learners will have the tools to enhance efficiency, improve resource allocation, and drive strategic decisions using Excel’s powerful modeling and analytical capabilities.

What sets this course apart is its focus on actionable insights and practical, hands-on applications of advanced techniques, ensuring students are prepared to address challenges across a range of industries.

Whether optimizing operations, solving logistical challenges, or preparing for uncertainty, this course provides essential skills for making confident, data-driven decisions.

Prerequisite knowledge of basic Excel functions and foundational analytics is recommended.

In this module, we do a quick review of how to model business problems in Excel and how to solve for them using Solver.

涵盖的内容

6个视频 9篇阅读材料 1个作业

NCAA T-Shirt Vendor • 15分钟

Quality Sweater Company • 20分钟

Diaz Coffee • 18分钟

Veerman Furniture • 14分钟

Investment Portfolio Optimization • 16分钟

Production Planning • 19分钟

Excel Basics • 10分钟

NCAA T-Shirt Vendor • 5分钟

What-If Analysis • 10分钟

Quality Sweater Company • 5分钟

Linear Programming • 5分钟

Diaz Coffee • 5分钟

Veerman Furniture • 5分钟

Investment Portfolio Optimization • 5分钟

Production Planning • 5分钟

Computer Center Scheduling • 60分钟

We have learned about how to formulate linear programming problems and how to solve them using Excel Solver.In this module, we will learn about sensitivity analysis.So far in all of our models, we assumed that we know every coefficient with certainty.

This unfortunately is hardly the case in real life.Sensitivity analysis allows us to quickly check whether our optimal solution changes when certain parameters change.For example, what if you were not able to receive as much supply as predicted?Would your optimal solution change?

How much profit would you expect to lose?By the end of this module, you will know how to answer questions like these.

涵盖的内容

5个视频 3篇阅读材料 1个作业

B&N Bookstore • 17分钟

Sensitivity Analysis: Variables Table • 23分钟

Sensitivity Analysis: Constraints Table • 10分钟

Sensitivity Analysis: Using Both Tables Together • 13分钟

Using Sensitivity Analysis: Portfolio Example • 20分钟

B&N Bookstore • 5分钟

Sensitivity Analysis Summary • 10分钟

Using Sensitivity Analysis: Portfolio Example • 10分钟

Sensitivity Analysis Assessment • 45分钟

In this module, we dive into the powerful technique of integer programming, a branch of optimization that requires decision variables to be whole numbers, making it particularly valuable for real-world business decisions.

Unlike linear programming, integer programming is essential when dealing with constraints that require discrete decisions, such as determining the number of products to manufacture, selecting projects within budget limits, or optimizing logistics and workforce scheduling.

Using Excel's Solver, you'll learn how to model and solve advanced integer programming problems.This module will equip you with a versatile and widely applicable skill set, helping you approach complex decisions with confidence and precision.

涵盖的内容

6个视频 8篇阅读材料 1个作业

Integer Programming: Princess Brides • 11分钟

Mixed Integer Problem: Bolsa de Café • 13分钟

Binary Investment Decision • 16分钟

Aviate Airlines • 8分钟

Purchasing with Price Breaks using Linking Variables • 18分钟

FDN Catering Company • 13分钟

Integer Programming Review • 10分钟

Integer Programming: Princess Brides • 5分钟

Mixed Integer Problem: Bolsa de Café • 5分钟

Binary Investment Decision • 5分钟

Aviate Airlines • 5分钟

Purchasing with Price Breaks • 5分钟

FDN Catering Company • 5分钟

Assessment Solution • 10分钟

Integer Programming Assessment • 60分钟

In this module, you will dive into the fascinating world of optimization and decision-making to tackle real-world logistical and operational challenges.

Explore how businesses assign tasks efficiently, transport goods cost-effectively, and manage complex networks of supply and demand.

You will learn to build mathematical models that represent these problems and master powerful optimization techniques.

Discover how to evaluate solutions for feasibility and optimality, and transform mathematical results into strategic insights for decision-making in Excel using Solver.

By the end of this module, you’ll have the skills and confidence to address complex business challenges and add significant value to organizational operations.

涵盖的内容

5个视频 5篇阅读材料 1个作业

Transportation Problem Excel Template • 14分钟

MLB Umpire Assignment • 8分钟

Swim Team Assignment • 8分钟

Bonner Electronics • 8分钟

Shortest Path Network Flow • 11分钟

Transportation and Assignment Problems • 10分钟

MLB Umpire Assignment • 10分钟

Swim Team Assignment • 5分钟

Bonner Electronics • 5分钟

Shortest Path Network Flow • 5分钟

Transportation and Assignment Assessment • 60分钟

In all of the optimization problems we studied, we assumed that the values of the parameters were known exactly.We tried to study the impact of uncertainty in our parameters through sensitivity analysis.

While sensitivity analysis is useful, it cannot capture large deviations or simultaneous changes to many parameters.In this module, we will learn a new modelling tool called simulation.

Simulation is a powerful technique used to model and analyze complex systems, especially when uncertainty and variability are key factors.In this module, we will explore how to use Excel to build simulations that aid in decision-making and risk analysis in business contexts.

By learning to implement simulations in Excel, you will gain practical skills that can be applied to a variety of business analytics problems, including financial forecasting, inventory management, and project scheduling.

涵盖的内容

5个视频 5篇阅读材料 1个作业

Harry's Auto Tires • 11分钟

Higgens Plumbing & Heating • 7分钟

Queueing Theory Simulation • 15分钟

Downtown Bookstore Simulation • 15分钟

GE Stock Simulation Analysis • 10分钟

Harry's Auto Tires • 5分钟

Higgens Plumbing & Heating • 5分钟

Queueing Theory Simulation • 5分钟

Downtown Bookstore Simulation • 5分钟

GE Stock Simulation Analysis • 5分钟

Simulation Assessment • 60分钟

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。

在社交媒体和绩效考核中分享。

位教师

提供方

从 Business Essentials 浏览更多内容

J Johns Hopkins University Business Analytics with Excel: Intermediate to Advanced 课程 状态：免费试用 免费试用

J Johns Hopkins University Business Analytics with Excel 专项课程 状态：免费试用 免费试用

U University of Minnesota Advanced Models for Decision Making 课程 状态：免费试用 免费试用

J Johns Hopkins University Business Analytics with Excel: Elementary to Advanced 课程 状态：免费试用 免费试用

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

学生评论

54 条评论

5 星 94.44%

4 星 5.55%

3 星 0%

2 星 0%

1 星 0%

显示 3/54 个

已于 Apr 17, 2025审阅

The complicated material presented was explained exceptionally well and will permit the students to gain many valuable skills in Excel.

已于 Sep 15, 2025审阅

Perfect, however, some parts of the courses were the same as another course available on Coursera with the same instructor.

已于 Jun 29, 2025审阅

This course has been very educative and well articulated. Credits to the professor for the very good job in the well articulated explanations.

是什么让您今天来到 Coursera？

开始我的职业生涯

改变我的职业生涯

在我目前的岗位上成长

拓展工作外领域

通过订阅解锁 10,000 多门课程的访问权限 开始试用

通过在线学位推动您的职业生涯 获取世界一流大学的学位 - 100% 在线 探索学位

加入全球超过 4,700 家选择 Coursera for Business 的公司 了解更多

常见问题

When will I have access to the lectures and assignments?

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course.Eligible learners may also have the option to start with a Free Trial.Some courses may also offer a Full Course, No Certificate option.

This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.

What will I get if I subscribe to this Specialization?

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.

Is financial aid available?

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.

更多问题

提供助学金， 了解详情