In this video, I will show you how to calculate ratios in Microsoft Excel. Learn how to leverage Excel's versatile range of functions and formulas to compute ratios effortlessly. Whether you're comparing student performance, financial metrics, or any other dataset, understanding ratios is a game-changer. I will show you two different methods of calculating ratios in Excel. The first one is using the GCD function and then I will show you how to use the TEXT and SUBSTITUTE functions to get the same results.

0:00 Introduction
0:36 Using the GCD function to calculate a ratio
2:55 How to use the TEXT and SUBSTITUTE Functions for creating ratios