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

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

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

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

Business Analytics with Excel: Elementary to Advanced

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

О курсе

A leader in a data driven world requires the knowledge of both data-related (statistical) methods and of appropriate models to use that data. This Business Analytics class focuses on the latter: it introduces students to analytical frameworks used for decision making though Excel modeling. These include Linear and Integer Optimization, Decision Analysis, and Risk modeling. For each methodology students are first exposed to the basic mechanics, and then apply the methodology to real-world business problems using Excel. Emphasis will be not on the "how-to" of Excel, but rather on formulating problems, translating those formulations into useful models, optimizing and/or displaying the models, and interpreting results. The course will prepare managers who are comfortable with translating trade-offs into models, understanding the output of the software, and who are appreciative of quantitative approaches to decision making. Business analytics makes extensive use of data and modeling to drive decision making in organizations. This class focuses on introducing students to analytical frameworks used for decision making to make sense of the data, starting from the basics of Excel and working up to advanced modeling techniques.

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

Microsoft ExcelSpreadsheet SoftwareBusiness AnalyticsRegression AnalysisMathematical ModelingFinancial ModelingStatistical MethodsResource AllocationTransportation OperationsRisk ModelingBusiness ModelingPredictive AnalyticsRisk ManagementDecision IntelligenceOperations ResearchBusiness AnalysisData ModelingRisk AnalysisStatistical AnalysisProcess Optimization

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

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

01Introduction to Excel: Basics and Best Practices12 материалов

Getting Started

Course InformationЧтениеSpam Posts on Discussion ForumsЧтениеIntroduce YourselfОбсуждение

Introduction to Spreadsheet Models

Warm-Up - Creating a Budget in Excel

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

Joseph W. Cutrone, PhD

Associate Teaching Professor and Director of Online Programs

Business Analytics with Excel: Elementary to Advanced
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 23.4 ч

6 модулей

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

Субтитры: Арабский, Французский, Бенгальский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Видео
NCAA T-Shirt VendorЧтение
NCAA T-Shirt Vendor Видео
Formatting, Formulas, and FunctionsЧтение

Creating Tables and Charts

Woodworks Bookshelf Co.ЧтениеWoodworks Bookshelf Co.ВидеоExcel as Your Business Decision PartnerDIALOGUEReferences, Tables, and ChartsЧтение

Module 1 Assessment

Introduction to ExcelЗадание
02What-If Analysis in Excel12 материалов

Modeling Profit and the Break-Even Point

Quality Sweater CompanyЧтениеQuality Sweater CompanyВидеоGoal Seek and One-Way Data TablesЧтениеThe Break-Even PointЧтениеHaute DogЗадание

Modeling Uncertain Demand

B&N BookstoreЧтениеB&N BookstoreВидеоTwo-Way Data Tables and More FunctionsЧтениеCopy ShopЗадание

Module 2 Assessment

What-If Analysis and Uncertainty (Quality Sweater Company)ОбсуждениеWhat-If Analysis in ExcelЗаданиеSelf-Evaluation for What-If AnalysisЗадание
03Decision Analysis through Regression and NPV14 материалов

Modeling Demand and Price

The 19th HoleЧтениеThe 19th HoleВидеоTrendlines and Conditional FormattingЧтениеExercise Equipment CompanyЗадание

Modeling Net Present Value

Gopher DrugsЧтениеNPV Example: Gopher DrugsВидеоModeling Net Present ValueЧтениеNet Present ValueЗадание

Module 3 Assessment

Decision Analysis through Regression (The 19th Hole)ОбсуждениеDecision Analysis through Regression and NPVЗаданиеSelf Evaluation for Decision AnalysisЗадание

Midcourse Project

Midcourse ProjectЧтениеModel Set-Up - Bluejay Natural GasЗаданиеSample Model - Bluejay Natural GasЧтение
04Linear Programming17 материалов

Introduction to Linear Programming

What Is Linear Programming?ЧтениеAdding Solver to ExcelЧтениеCampaign MarketingЧтениеCampaign MarketingВидеоUsing Solver for LP ProblemsЧтениеIntro to Linear ProgrammingЗадание

LP and Net Profit

PC Tech CompanyЧтениеPC Tech CompanyВидеоFurniture CompanyЗадание

LP and Investment Allocation

Investment AllocationЧтениеInvestment AllocationВидеоFeed MixЗадание

LP and Transportation

Busing ProblemЧтениеBusing ProblemВидеоBus CompanyЗадание

Module 4 Assessment

LP and Uncertainty (Investment Allocation)ОбсуждениеLinear ProgrammingЗадание
05Transportation and Assignment Problems12 материалов

Transportation Problems

Transportation Problem Excel TemplateВидеоAlternative Excel TemplateВидеоTransportation ProblemsЧтениеConstruction ProjectsЗадание

Assignment Problems

New Hire AssignmentsЧтениеNew Hire AssignmentsВидеоAssignment ProblemsЧтениеMLB Umpire AssignmentЧтениеMLB Umpire AssignmentВидеоCollege ProfessorsЗадание

Module 5 Assessment

Identifying Transportation and Assignment ProblemsОбсуждениеTransportation and Assignment ProblemsЗадание
06Integer Programming and Nonlinear Programming21 материалов

Integer Programming

Princess BridesЧтениеPrincess BridesВидеоBolsa de CaféЧтениеBolsa de CaféВидеоInteger Programming in SolverЧтениеArt PostersЗадание

Binary Integer Programming

Binary Investment DecisionЧтениеBinary Investment DecisionВидеоBinary Integer Programming with SolverЧтениеHorizon WirelessЗадание

Nonlinear Programming

Portfolio VarianceЧтениеPortfolio VarianceВидеоMotorcross SnowmobilesЧтениеMotorcross SnowmobilesВидеоNonlinear Programming with SolverЧтениеBaseball StadiumЗадание

Module 6 Assessment

Integer Programming and Nonlinear ProgrammingЗадание

Final Project

Final ProjectЧтениеProject Selection at Bluejay Natural GasЗаданиеSolution- Bluejay Natural Gas Project SelectionЧтениеNext CourseЧтение