In this 1-hour long project-based course, you will learn how to compare the performance of different securities using financial statistics (normal distributions) and the Google Sheets toolkit to decide which one performed the best in terms of risk-to-return (risk-to-reward) metrics. This will teach you how basic risk management using quantitative analysis is done and is applied in calculating mean returns of the stock, variance, standard deviation, the Sharpe ratio, and Sortino Ratio.
Note: This course works best for learners who are based in the North America region. We're currently working on providing the same experience in other regions.
This course's content is not intended to be investment advice and does not constitute an offer to perform any operations in the regulated or unregulated financial market.
Status: Spreadsheet Software
Spreadsheet Software
Status: Risk Management
Risk Management
Beginner·Guided Project·2 hours
Featured reviews
5.0
·Reviewed May 9, 2020
Foundation project for Risk and Portfolio Management, also try Markowitz project on Coursera if you want to grow.
5.0
·Reviewed Aug 14, 2020
Basic concepts explained very simply with the help of Excel. Would recommend for anyone interested in finance!
5.0
·Reviewed Jul 7, 2020
A Good Course to learn how to calculate Sharpe and Sortino Ratio using Excel.
5.0
·Reviewed Jul 31, 2020
Good to Know about the Methods and Techniques behind the Stock Markets.
5.0
·Reviewed Apr 5, 2025
Great way to start a finance project of your own using different tools that was taught.
5.0
·Reviewed Oct 1, 2024
Wonderful course, practical for real life examples, and overall very useful!
4.0
·Reviewed Aug 8, 2020
It is good for someone who wants to just begin with stock analysis.
4.0
·Reviewed Jul 18, 2020
Slow paced but good, selective detail. Not sure it's worth CAD$13, should have just asked Google
4.0
·Reviewed Aug 27, 2020
Very useful and informative tools and can be used in our daily work to analyse stocks
5.0
·Reviewed Jul 14, 2020
Amazing instructor and the teaching is done without any assumptions of the student having prior knowledge, implying every detail required to understand a topic is covered.
4.0
·Reviewed Apr 29, 2020
This is great and thank you very much. I am so eager to learn more about comparing stock and returns, and portfolio & risk management.
5.0
·Reviewed Jul 30, 2020
This Course is good for Beginners and it really helps in kick starting your interest in Finance and Quantitative Analysis .
All reviews
Showing: 20 of 134
All Learners
All Stars
Most Helpful
M
Miro
1.0
·Reviewed May 31, 2020
This was such an easy and basic guided project. The instructor needs to explain some background on the topic, why do we even need to calculate these ratios and how they can help us in getting a sense of the stock movements. It would be probably helpful for people with 0 knowledge in stocks and those who have not even heard of the stocks in their lives before.
K
Kaiyue
2.0
·Reviewed Jan 17, 2021
It's not bad...
But I dont think there is anything that is really useful or worth the money I paid for it...
It only took me 30 min to finish it and there is nothing hard......
You can learn this for free in 10 mins on youtube.... Srsly!!
V
Vasundhra
1.0
·Reviewed Jun 20, 2024
the document sent on google sheets were not opening and as I tried to open it on other shared apps it showed that the file was empty
E
Eliana
1.0
·Reviewed Mar 6, 2025
the file which you are suppose to do the whole lab with is empty
S
Sai
1.0
·Reviewed Aug 12, 2020
Didn't mention why we used sharpe and sortino ratios
R
Ricardo
1.0
·Reviewed Jun 6, 2020
The videos are very very low quality!!!
K
Konstantinos
1.0
·Reviewed Jul 26, 2026
files do not work
S
Sanjay
5.0
·Reviewed Aug 6, 2020
In this 1-hour long project-based course, you will learn how to compare the performance of different securities using financial statistics (normal distributions) and the Google Sheets toolkit to decide which one performed the best in terms of risk-to-return (risk-to-reward) metrics. This will teach you how basic risk management using quantitative analysis is done and is applied in calculating mean returns of the stock, variance, standard deviation, the Sharpe ratio, and Sortino Ratio.
V
Viju
5.0
·Reviewed May 20, 2020
This course is a simple one and you have to do it yourself to understand it. It will use your Google Sheets skills to a new level, even if you are mechanically following the instructor. Don't be put off by the accent, he is as good as it gets.
S
Santiago
5.0
·Reviewed Nov 3, 2020
Amazing intro to Google Sheets/Excel. I took this after doing the Investment Management Specialization from UGeneva, and I wish I took it earlier because it really would have helped me with the Excel work.
Really recommend it to anyone.
A
Anthony
5.0
·Reviewed Aug 5, 2020
A great project for starters who wants to use Google Sheets to analyze stock returns based on Sharpe and Sortino ratios. Instructor Bekhruzbek Ochilov allows hands-on practice before moving on in his lecture.
O
Oscar
5.0
·Reviewed Jun 25, 2021
Muy bueno para familiarizarse con la construcción de los Ratios de Sharpe y Sortino. Es necesario complementar con información externa sobre la tasa libre de riesgo. Bastante práctico el curso. Recomendado.
C
Camila
5.0
·Reviewed Aug 23, 2020
The instructor explained a complex subject in a very simple and objective way, with real examples and the possibility to apply in others studies (taking the Sheets used for the course as model).
V
Venkatesh
5.0
·Reviewed Jul 25, 2020
It is a simple and easy course to understand and compare stock returns based on Sharpe and Sortino ratios. Very helpful for someone trying to understand the basics of stocks!
A
Abhinav
5.0
·Reviewed Jul 15, 2020
Amazing instructor and the teaching is done without any assumptions of the student having prior knowledge, implying every detail required to understand a topic is covered.
R
Rathinaprabhu
5.0
·Reviewed Aug 10, 2020
It was an wonderful experience and the only problem is with the desktop provided and I hope coursera will take care of it in future
S
Shradheya
5.0
·Reviewed Jul 31, 2020
This Course is good for Beginners and it really helps in kick starting your interest in Finance and Quantitative Analysis .
P
Patrick
5.0
·Reviewed Jan 7, 2023
Use of google sheets is well explained and the instructor gives clear concise details on how to perform calculations.
N
Nihar
5.0
·Reviewed May 10, 2020
Foundation project for Risk and Portfolio Management, also try Markowitz project on Coursera if you want to grow.
A
ARANYA
5.0
·Reviewed Aug 15, 2020
Basic concepts explained very simply with the help of Excel. Would recommend for anyone interested in finance!