How to Predict Future Sales in LibreOffice Calc

In this tutorial you will learn how to predict future sales in LibreOffice Calc. The projections will be based on historical sales data. We will use the several forecast functions to determine future sales. We will take the projected sales and put it into line charts.

Chapters:
00:00 - Intro
00:55 - Linear Sales Forecast
02:51 - Non-Linear Sales Forecast
06:45 - Confidence Level
09:00 - Minimum Projected Sales
09:24 - Maximum Projected Sales
09:55 - Forecast Sales Chart
14:01 - Wrap-up

Functions:
Linear Sales Forecast Sheet 1 B23 through B28: : =FORECAST(A23,B$2:B$22,A$2:A$22)

Future Sales Forecast Sheet 2 C23 through C28: =FORECAST.ETS.ADD(A23,B$2:B$22,A$2:A$22,1,1,1)

Confidence Level Sheet 2 D23 through D28: =FORECAST.ETS.PI.ADD(A23,B$2:B$22,A$2:A$22,0.95,1,1,1)

Lower Confidence Bound (Minimum Projected Sales): =C23-D23

Upper Confidence Bound (Maximum Projected Sales): =C23+D23

***BE SURE TO CARRY THE FUNCTION DOWN TO ALL ROWS THAT NEED CALCULATED***

Support me with your amazon purchases: https://melcompton.com/recommends/ama...

Check out these programs I use for YouTube
Bluehost discount: https://melcompton.com/recommends/blu...
Canva Pro Trial: https://melcompton.com/recommends/can...
Adobe: https://melcompton.com/recommends/adobe/
Filmora: https://melcompton.com/recommends/won...

Follow me on social media:
Facebook: https://www.facebook.com/therealmelco...
Twitter: @melissaecompton
Instagram: @melissaacompton
LinkedIn: https://www.linkedin.com/in/melissa-c...
This description contains affiliate links and I may be paid a small commission should you purchase using these links.

#melissacompton #libreoffice #sales

Видео How to Predict Future Sales in LibreOffice Calc канала Melissa Compton