You can calculate Ratio in Excel by using the GCD function and the Substitute function. This article is a step-by-step guide to help you.

Learn to calculate Consumer Price Index (CPI) using Excel and create its graph, please read through this article. We have discussed the prcedure extensively.

Next, have Excel run the regression on the two columns of return data you generated. Under the Data menu, the Data Analysis button allows you to select Regression.

The acid-test ratio, also known as the quick ratio, measures the liquidity of a company. Learn how to calculate acid-test ratio here.