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: Regression Analysis
Status: Financial Modeling
IntermediateCourse23 hours

Featured reviews

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.

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

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.

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.

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.

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.

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.

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 !

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.

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.

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