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

Business Analytics with Excel: Elementary to Advanced

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.

Status: Data Modeling
Status: Resource Allocation
IntermediateCourse23 hours

Featured reviews

CM

5.0Reviewed May 29, 2024

Great examples and well structured course, nicely presented. As someone who has used Excel for a number of years, I learnt some new techniques and enjoyed refreshing my skills.

SR

5.0Reviewed Jul 23, 2024

Good course to follow if you are interested in expand your knowledge in excel data analysis, especially focusing on business analytics. Lectures and resource materials are very clear and helpful.

MA

5.0Reviewed Sep 10, 2023

relevant and practical , never thought excel is this powerful .. Great teacher too . Well organized and skilled to explain what is thought to be too complex to understand ..great job

AS

4.0Reviewed Jul 15, 2024

Excel itself is easy, but it’s not easy to understand, for example. This is the most difficult issue that I faced. The course focuses on financial and business parts, and I am a an engineer

LP

5.0Reviewed Nov 11, 2023

As a student majoring in marketing, I also find this course very helpful and easy to understand. I comprehend the material after each lesson, and I am able to complete assignments.

AA

5.0Reviewed Jul 27, 2024

It's an amazing course for business analytics equally valuable for beginners as well as for intermediate learners. Some of the advance learning will improve your skills to next step.

SD

4.0Reviewed Apr 6, 2024

Amazing course to support business decisions through statistics and data validation. Includes almost all the essential skills required to run and understand a business. Loved it.

KD

5.0Reviewed Sep 27, 2024

Very helpfull, this course literally open my eyes about business analytics with excel. The video tutorial very clear and easy to catch, and the other student also very interactive

EM

5.0Reviewed Sep 28, 2025

it is great. From the lessons to the tests it is super comprehensible and straight forward. Anyone looking to learn how to better use excel in a buisness enviroment, this is it.

MB

4.0Reviewed Jul 19, 2024

Excellent, I was not able to solve the excel from what if analysis because I only have my phone to practice on so, many of the options where not available but I understood all the concepts.

AM

5.0Reviewed Jun 6, 2023

I am very grateful to opt this course. Each module of this course are symmetrical and very module connected to each other and it is easy for all to understand and perform the task as mentioned.

RG

5.0Reviewed Jul 1, 2023

If you thrive to excel, and need to upskill yourself, please enrol. The study material was simple to understand, yet allowed to inculcate the learnings into my domain of business.

All reviews

Showing: 20 of 1,004

Stacie Scattergood
2.0
Reviewed Feb 8, 2024
Ma A
5.0
Reviewed Sep 11, 2023
Nhật Nguyễn Minh
1.0
Reviewed May 25, 2023
Pratham Vasishta
5.0
Reviewed May 5, 2023
Krishan
3.0
Reviewed May 8, 2023
Rahul Gupta
5.0
Reviewed Jul 2, 2023
Shivam Verma
2.0
Reviewed May 6, 2023
Ashish Mehra
5.0
Reviewed Jun 7, 2023
Obaidullah Syed
1.0
Reviewed Jun 18, 2023
ELMEHDI
1.0
Reviewed Oct 6, 2023
Ramesh Baskaran
5.0
Reviewed Apr 16, 2023
Linda Phan
5.0
Reviewed Nov 11, 2023
Samuel Eshete
5.0
Reviewed Jun 5, 2023
Abe Minto
5.0
Reviewed May 26, 2023
Nick Fuca
3.0
Reviewed Jun 10, 2023
Warren Rushby
2.0
Reviewed Mar 28, 2024
M E
5.0
Reviewed Apr 22, 2023
Seamus McGonigal
1.0
Reviewed Sep 29, 2024
Jiya
1.0
Reviewed Jun 9, 2024
Diana Maria Dias Marques
5.0
Reviewed Sep 3, 2023