You need to have the zero-coupon yield curve information to calculate forward rates, even in Microsoft Excel.

Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.