Hi,

You can use FORECAST function for forecasting if you have the historic data available. Please go through the following URL for more details:

http://office.microsoft.com/en-001/e...096.aspx?CTT=1