Monthly Subscription Starting at AED 99 + VAT

Business Analytics with Excel: Elementary to Advanced
  • Level Professional
  • Duration 23 hours
  • Course by Johns Hopkins University
  • Offered by

About

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.

Modules

Getting Started

    • 2 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Introduce Yourself

2 Readings

  • Course Information
  • Spam Posts on Discussion Forums

Introduction to Spreadsheet Models

    • 2 Videos
    • 2 Readings
Show info about module content

2 Videos

  • Warm-Up - Creating a Budget in Excel
  • NCAA T-Shirt Vendor

2 Readings

  • NCAA T-Shirt Vendor
  • Formatting, Formulas, and Functions

Creating Tables and Charts

    • 1 Videos
    • 2 Readings
Show info about module content

1 Videos

  • Woodworks Bookshelf Co.

2 Readings

  • Woodworks Bookshelf Co.
  • References, Tables, and Charts

Module 1 Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Introduction to Excel

Modeling Profit and the Break-Even Point

    • 1 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Haute Dog

1 Videos

  • Quality Sweater Company

3 Readings

  • Quality Sweater Company
  • Goal Seek and One-Way Data Tables
  • The Break-Even Point

Modeling Uncertain Demand

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Copy Shop

1 Videos

  • B&N Bookstore

2 Readings

  • B&N Bookstore
  • Two-Way Data Tables and More Functions

Module 2 Assessment

    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • What-If Analysis in Excel
  • Self-Evaluation for What-If Analysis

1 Discussions

  • What-If Analysis and Uncertainty (Quality Sweater Company)

Modeling Demand and Price

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Exercise Equipment Company

1 Videos

  • The 19th Hole

2 Readings

  • The 19th Hole
  • Trendlines and Conditional Formatting

Modeling Net Present Value

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Net Present Value

1 Videos

  • NPV Example: Gopher Drugs

2 Readings

  • Gopher Drugs
  • Modeling Net Present Value

Module 3 Assessment

    • 1 Discussion
    • 2 Assignment
Show info about module content

2 Assignment

  • Decision Analysis through Regression and NPV
  • Self Evaluation for Decision Analysis

1 Discussions

  • Decision Analysis through Regression (The 19th Hole)

Midcourse Project

    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Model Set-Up - Bluejay Natural Gas

2 Readings

  • Midcourse Project
  • Sample Model - Bluejay Natural Gas

Introduction to Linear Programming

    • 1 Videos
    • 4 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Intro to Linear Programming

1 Videos

  • Campaign Marketing

4 Readings

  • What Is Linear Programming?
  • Adding Solver to Excel
  • Campaign Marketing
  • Using Solver for LP Problems

LP and Net Profit

    • 1 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Furniture Company

1 Videos

  • PC Tech Company

1 Readings

  • PC Tech Company

LP and Investment Allocation

    • 1 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Feed Mix

1 Videos

  • Investment Allocation

1 Readings

  • Investment Allocation

LP and Transportation

    • 1 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Bus Company

1 Videos

  • Busing Problem

1 Readings

  • Busing Problem

Module 4 Assessment

    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Linear Programming

1 Discussions

  • LP and Uncertainty (Investment Allocation)

Transportation Problems

    • 2 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Construction Projects

2 Videos

  • Transportation Problem Excel Template
  • Alternative Excel Template

1 Readings

  • Transportation Problems

Assignment Problems

    • 2 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • College Professors

2 Videos

  • New Hire Assignments
  • MLB Umpire Assignment

3 Readings

  • New Hire Assignments
  • Assignment Problems
  • MLB Umpire Assignment

Module 5 Assessment

    • 1 Discussion
    • 1 Assignment
Show info about module content

1 Assignment

  • Transportation and Assignment Problems

1 Discussions

  • Identifying Transportation and Assignment Problems

Integer Programming

    • 2 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Art Posters

2 Videos

  • Princess Brides
  • Bolsa de Café

3 Readings

  • Princess Brides
  • Bolsa de Café
  • Integer Programming in Solver

Binary Integer Programming

    • 1 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Horizon Wireless

1 Videos

  • Binary Investment Decision

2 Readings

  • Binary Investment Decision
  • Binary Integer Programming with Solver

Nonlinear Programming

    • 2 Videos
    • 3 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Baseball Stadium

2 Videos

  • Portfolio Variance
  • Motorcross Snowmobiles

3 Readings

  • Portfolio Variance
  • Motorcross Snowmobiles
  • Nonlinear Programming with Solver

Module 6 Assessment

    • 1 Assignment
Show info about module content

1 Assignment

  • Integer Programming and Nonlinear Programming

Final Project

    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Project Selection at Bluejay Natural Gas

2 Readings

  • Final Project
  • Solution- Bluejay Natural Gas Project Selection

Auto Summary

"Business Analytics with Excel: Elementary to Advanced" is a comprehensive course designed for professionals in the Business & Management domain. Led by Coursera, it focuses on equipping learners with analytical frameworks for decision-making using Excel. Covering Linear and Integer Optimization, Decision Analysis, and Risk modeling, the course emphasizes problem formulation, model optimization, and result interpretation. Spanning 1380 minutes, it offers Starter and Professional subscription options. Ideal for managers and professionals, this course enhances quantitative decision-making skills through practical, real-world applications.

Joseph W. Cutrone, PhD
Instructor

Joseph W. Cutrone, PhD