К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Advanced Business Analytics: Excel Optimization & Simulation · LearnSpace
Назад в каталог
courseraБизнес

Advanced Business Analytics: Excel Optimization & Simulation

Курс от Johns Hopkins University
Уровень не указан≈ 14.1 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

Model OptimizationBusiness AnalyticsBusiness ModelingMicrosoft ExcelSimulation and Simulation SoftwareResource AllocationTransportation OperationsDecision MakingAnalyticsOperations ResearchRisk ModelingStatistical MethodsAnalysisRisk AnalysisBusiness OperationsProcess OptimizationData-Driven Decision-Making

Программа курса

5 модулей · 62 учебных материалов

01Modeling in Excel: Elementary to Advanced16 материалов

Elementary Examples

Excel BasicsЧтениеNCAA T-Shirt VendorЧтениеNCAA T-Shirt VendorВидеоWhat-If AnalysisЧтение

Учитесь у экспертов

Joseph W. Cutrone, PhD

Associate Teaching Professor and Director of Online Programs

Advanced Business Analytics: Excel Optimization & Simulation
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 14.1 ч

5 модулей

Язык: Английский

Субтитры: Узбекский, Пушту, Дари, Казахский

Часть программы вашего университета
Quality Sweater CompanyЧтение
Quality Sweater CompanyВидео

Intermediate Examples

Linear ProgrammingЧтениеDiaz CoffeeЧтениеDiaz CoffeeВидеоVeerman FurnitureЧтениеVeerman FurnitureВидео

Advanced Examples

Investment Portfolio OptimizationЧтениеInvestment Portfolio OptimizationВидеоProduction PlanningЧтениеProduction PlanningВидео

Assessment: Modeling with Excel

Computer Center SchedulingЗадание
02Sensitivity Analysis9 материалов

Excel Review: Data Tables and Uncertain Demand

B&N BookstoreЧтениеB&N BookstoreВидео

Sensitivity Report Analysis

Sensitivity Analysis SummaryЧтениеSensitivity Analysis: Variables TableВидеоSensitivity Analysis: Constraints TableВидеоSensitivity Analysis: Using Both Tables TogetherВидео

Sensitivity Analysis: Solved Example

Using Sensitivity Analysis: Portfolio Example ЧтениеUsing Sensitivity Analysis: Portfolio ExampleВидео

Sensitivity Analysis Assessment

Sensitivity Analysis AssessmentЗадание
03Advanced Integer Programming15 материалов

Excel Review: Intermediate Integer Programming

Integer Programming ReviewЧтениеInteger Programming: Princess BridesЧтениеInteger Programming: Princess BridesВидеоMixed Integer Problem: Bolsa de CaféЧтениеMixed Integer Problem: Bolsa de CaféВидеоBinary Investment DecisionЧтениеBinary Investment DecisionВидео

Advanced Examples

Aviate AirlinesЧтениеAviate AirlinesВидеоPurchasing with Price BreaksЧтениеPurchasing with Price Breaks using Linking VariablesВидеоFDN Catering CompanyЧтениеFDN Catering CompanyВидео

Integer Programming Assessment

Integer Programming AssessmentЗаданиеAssessment SolutionЧтение
04Advanced Transportation Problems11 материалов

Review of Transportation and Assignment Problems

Transportation and Assignment ProblemsЧтениеTransportation Problem Excel TemplateВидеоMLB Umpire AssignmentЧтениеMLB Umpire AssignmentВидео

Intermediate Examples

Swim Team AssignmentЧтениеSwim Team AssignmentВидео

Advanced Examples

Bonner ElectronicsЧтениеBonner ElectronicsВидеоShortest Path Network FlowЧтениеShortest Path Network FlowВидео

Transportation and Assignment Assessment

Transportation and Assignment AssessmentЗадание
05Simulation11 материалов

First Examples of Simulation in Excel

Harry's Auto TiresЧтениеHarry's Auto TiresВидеоHiggens Plumbing & HeatingЧтениеHiggens Plumbing & HeatingВидео

Intermediate Examples

Queueing Theory SimulationЧтениеQueueing Theory SimulationВидеоDowntown Bookstore SimulationЧтениеDowntown Bookstore SimulationВидео

Advanced Examples

GE Stock Simulation AnalysisЧтениеGE Stock Simulation AnalysisВидео

Simulation Assessment

Simulation AssessmentЗадание