|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/intro-to-linear-programming-with-excel/
课程评论：没有评论
**课程总结：Excel Solver 入门 (2个完整案例 + 方法论)** 本课程全面介绍了线性规划，包括其定义、背景知识和应用场景。通过两个完整的实际案例，演示如何使用 Microsoft Excel 的 Solver 插件来解决线性规划问题。 **课程大纲：** * **第一讲：引言** * Excel 中的线性规划：课程概述与应用场景 * 讲师简介 * **第二讲：启用 Solver 插件** * 如何在 Microsoft Excel 中启用 Solver 插件以进行线性优化。 * **第三讲：什么是线性规划？** * 线性规划的构成要素和求解线性优化问题的通用框架。 * **第四讲：线性规划的应用示例** * 介绍线性规划的常用应用场景。 * **第五讲：图解识别线性规划的最优解** * 通过图解方式，讲解如何确定线性规划中的可行解和最优解。 * **第六讲：线性规划示例 1 - "考试" (优化分数)** * 以一个优化学业考试分数的实际问题为例，进行讲解。 * **第七讲：线性规划示例 2 - "Stanley's 玻璃"** * 通过 "Stanley's 玻璃" 的案例，进一步实践线性规划的求解。 **学员要求：** * 能够使用 Microsoft Excel。 * 具备学习意愿。
This course gives an overview of linear programming (definition, background, use cases) and then shows how to solve a linear program using Microsoft Excel through 2 complete examples. Below is a complete outline of the course:Lecture 1: Introduction: Linear programming in Excel - course overview + use casesQuick introduction + our backgroundsLecture 2: Enabling Solver add-on for linear optimizationEnabling Solver add-on in MS ExcelLecture 3: What is linear programming?What linear programming is comprised of, and the general framework of solving for a linear optimization.Lecture 4: Examples of when to use linear programmingLecture 5: How to identify optimal solutions in linear programming graphicallyWe will walk you through determining feasible and optimal solutions in linear programming given a graph.Lecture 6: Linear programming example 1 - 'taking a test' (optimizing score)Test score optimization problem (our first example)Lecture 7: Linear programming example 2 - 'Stanley's glass'Students joining this course should have access to MS Excel, and a willingness to learn!
