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: Business Process Modeling
Status: Data Modeling
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.

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.

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.

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

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.

LD

5.0Reviewed Sep 25, 2024

Excellent!!! The teaching methods , the videos, the reading materials were of the highest quality. The quizzes were difficult, but worth it. I really enjoyed the course. Thank You.

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.

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.

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.

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.

AS

4.0Reviewed Jun 24, 2023

It is a really well organized course. I got to learn a lot . Will watch through it again if required . Enjoyed the practical learning which always helps in better understanding of the topic . Thanks !

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.

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