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: Complex Problem Solving
Status: Predictive Analytics
IntermediateCourse23 hours

Featured reviews

RP

5.0Reviewed Aug 29, 2023

Great course with lots of real world business problems to practice from. Gave an indepth understanding of MS Excel and how to formulate business problems into spreadsheet models.

AY

5.0Reviewed Jun 21, 2024

Great course, Learn & apply my learning through the course is a great methods of learning. Midcourse & final assessment were great, it depicts the real world use case scenario.

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.

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

AS

5.0Reviewed Sep 30, 2023

Well guided course with gradually increasing difficulty level, yet explained in a lucid way. Next level (advanced) level courses are awaited from the faculty whose has immense knowledge of subject.

AO

5.0Reviewed Oct 14, 2023

I learnt how to analyze data, especially with some functions that I never knew existed on excel. Overall, it was a great experience, and I was able to learn at my own pace.

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.

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.

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.

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.

BU

4.0Reviewed Aug 21, 2023

I found this course very interesting and enlightening. I learnt a whole lot of new things and especially with regards analyzing business thoughts that are put down as statements and words.

ZJ

5.0Reviewed Feb 18, 2024

Muy recomendado para aplicar formulas y funciones en excel pero a casos de negocios o empresariales, además de obtener resultados concisos, te ayuda a reflexionar y a fortalecer el pensamiento lógico.

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