ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   HOW TO FORECAST VALUES FOR NEXT YEAR (https://www.excelbanter.com/new-users-excel/70247-how-forecast-values-next-year.html)

GOURI

HOW TO FORECAST VALUES FOR NEXT YEAR
 
I WANT TO FIND OUT SALES FIGURE AS WELL
AS BILLING AND COLLECTION
FROM
LAST 3 YEARS DATA
HOW CAN I GET SOLN.
PLS.HELP ME

Peo Sjoblom

HOW TO FORECAST VALUES FOR NEXT YEAR
 
Please don't use all caps, it's considered rude

look at the forecast function, go to ms office site and download an example
of a simple forecast, use line chart and add a trendline

--
Regards,

Peo Sjoblom

Portland, Oregon




"GOURI" wrote in message
...
I WANT TO FIND OUT SALES FIGURE AS WELL
AS BILLING AND COLLECTION
FROM
LAST 3 YEARS DATA
HOW CAN I GET SOLN.
PLS.HELP ME




All times are GMT +1. The time now is 01:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com