For historical volatility, calculate the daily return from the prices for a given time period. In Excel, use the STDEV() function on the daily returns over a certain time period to compute historical volatility.
For implied volatility, you need to use an option pricing model to back the implied volatility out, given all other parameters.