Johns Hopkins University
Business Analytics with Excel: Elementary to Advanced
Johns Hopkins University

Business Analytics with Excel: Elementary to Advanced

Taught in English

Some content may not be translated

364,649 already enrolled

Course

Gain insight into a topic and learn the fundamentals

Joseph W. Cutrone, PhD

Top Instructor

4.8

(2,003 reviews)

Intermediate level

Recommended experience

23 hours to complete
3 weeks at 7 hours a week
Flexible schedule
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

23 quizzes

See how employees at top companies are mastering in-demand skills

Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 6 modules in this course

The purpose of this course is to expose you to a variety of problems that can be solved using management science methods and modelled in Excel. In this course, we start from the basics of spreadsheet design and work our way up to broader mathematical optimization modelling. Many airlines, banks, and technology companies could not operate today as they do without the skills and techniques taught in this course. In this first module, we begin by introducing a relatively simple example of a mathematical model which we will use as our platform to build off of for more complicated applications later in the course. Many problems used in the video lectures come from the text Business Analytics: Data Analysis & Decision Making by Albright & Winston (Cengage Learning, 2014), ISBN 1285965523

What's included

3 videos6 readings1 quiz1 discussion prompt

We are now ready to introduce more complexity to our spreadsheet models. Since everyone comes from different Excel backgrounds, we will review some basic functions and features as well as more advanced techniques. This module covers more of the modelling process and includes some of the less-well known, but particularly helpful, Excel functions and tools that are available. Remember though that this course's objective is not to be a "how-to" of Excel. Instead, the focus and intent is to use these features to provide insights into real business problems.

What's included

2 videos5 readings4 quizzes1 discussion prompt

In this module the modeling concept of estimating relationships between variables by curve fitting, or regression analysis, is used to solve realistic business problems. Different regression curves are introduced and a mathematical analysis of which curve is best to help defend the model is presented. This allows not only an understanding of the techniques of modelling but also the rational behind which model to use.

What's included

2 videos6 readings5 quizzes1 discussion prompt

In this module we introduce spreadsheet optimization, one of the most powerful and flexible methods of quantitative analysis. The specific type of optimization presented here is linear programming (LP) which is used in all types of organizations to solve a wide variety of problems. As you will see through the examples presented in this course, LP is used in problems of labor scheduling, inventory management, advertising, finance, transportation, staffing, and many others. The goal of this module is to introduce you to the basic elements of LP, the types of problems it can solve, and how to model an LP problem in excel.

What's included

4 videos7 readings5 quizzes1 discussion prompt

This module provides even more examples of problems that can be modeling using linear programming (LP), in particular Transportation and Assignment problems. The basic transportation problem is concerned with finding the best (usually the least cost) way to distribute the good from sources such as factories, to final destinations such as retail outlets. The assignment problem involves finding the best (usually the least cost) way to assign individuals or pieces of equipment to projects or jobs on a one-to-one basis. Using Solver, we will take advantage of the special structure of these LP problems to find the best solutions to complex business problems in an efficient way.

What's included

4 videos4 readings3 quizzes1 discussion prompt

This module presents yet another subset of important mathematical linear programming models that arise when some of the basic assumptions of an LP model are made more or less restrictive. For example, restricting the decision variables to be whole numbers leads to the process of Integer Programming. Restricting the decision variables to be either 0 or 1 leads to binary programming. Lastly, we will see how the skills in this course can be used to solve more complex problems that involve nonlinear models.

What's included

5 videos10 readings5 quizzes

Instructor

Instructor ratings
4.8 (888 ratings)
Joseph W. Cutrone, PhD

Top Instructor

Johns Hopkins University
20 Courses433,002 learners

Offered by

Recommended if you're interested in Business Essentials

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 2003

4.8

2,003 reviews

  • 5 stars

    80.19%

  • 4 stars

    16.87%

  • 3 stars

    1.73%

  • 2 stars

    0.34%

  • 1 star

    0.84%

AS
5

Reviewed on Sep 30, 2023

AO
5

Reviewed on Oct 14, 2023

SD
4

Reviewed on Apr 6, 2024

New to Business Essentials? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions