Can you demonstrate how to calculate on excel?

Download 3 years of daily prices for two separate stocks in Excel. You can choose any company with sufficiently long history, except the company you used for Question 1. You will form a portfolio with 30% in one stock and 70% in the other. It doesn't matter which weight you assign to which stock, other than you should perform all calculations with the same weightings. Calculate the following values: - The covariance of the two stocks - The correlation of the two stocks - The average portfolio return for the portfolio - The variance of the portfolio - The standard deviation of the portfolio