Forecasting methods for Excel

Joannes Vermorel

Lokad delivers an advance forecasting technology, but for those who may just needing simple stuff, we have published a short guide about forecasting in Excel.

It is meant to be as simple as possible, and show what can be done with Excel in terms of forecasting - using linear regression or exponential fitting, through trendlines or the excel analysis toolpack (ATP).

It should allow small businesses, retailers or manufacturers, to easily perform a basic forecast of sales and demand.

It also gives useful advices about how to optimally use Excel, use comments and name your files and worksheets.