Forecasting Sales Using A.I. of Excel

 FORECASTING SALES USING A.I. OF EXCEL – data4goodph.online (wordpress.com)

FORECASTING SALES USING A.I. OF EXCEL

Published by

data4goodphilippines

on

December 18, 2023

Arnel Lopez Cadeliña

Step 1. Use this link to get the data : https://github.com/data4goodph/excelrealdataforsalesforecast  

                            Then Create a line chart.

Step 2. From the line chart insert a trend line.

Step 3. From the trend line , use format trendline and set a forecast period.

Step 4. Forecast indicate only a linear trend.  Go back to the data.

Step 5. Select all data by using Control +A.  

Step 6. Select the button Data and then click FORECAST SHEET.  

Step 7. Excel will show the Forecast with Lower and Upper Confidence.

Step 8. AI of Excel will show the Forecast Sales with Lower and Upper Confidence in the periods you indicated.

Link of data: https://github.com/data4goodph/excelrealdataforsalesforecast

data4goodph.online