quick tech talk: financial forecasting the fun and easy way.
subscribe to 卡塔尔世界杯常规比赛时间 podcasts anywhere: apple, google, spotify, iheart, deezer, amazon music and audible, player fm, audacy, gaana (india), and boomplay (africa).
quick tech talk
with steve yoss
cpe today
one of my favorite tools is microsoft excel, the swiss army knife of any financial professional. did you know that you can easily do budgeting and forecasting inside excel?
more steve yoss here
forecast.ets allows you to forecast the future of cash flows by peering into your crystal ball and peering around the corner to see your potential future cash flows based on historical data. so, it’s super easy to take your historical sales and costs and then project into the future to get a good sense of what you might do in the next month, quarter, or year. so, check out the forecast ets function the next time you want to do easy financial forecasting inside excel.
if you want an even easier approach, check out the forecast sheet function. it does everything the functionality does, but it also gives you a nice graph simultaneously.
2 responses to “predicting the future with forecasts.ets statistical analytics in microsoft excel”
steve yoss
authur, thanks for your comment! sure thing, check out https://support.microsoft.com/en-us/office/forecast-ets-function-15389b8b-677e-4fbd-bd95-21d464333f41 to get started. if you’re interested, we’re going to have a webinar on this next week (wednesday, 8/14). we will be discussing this feature and others in that class. if you’re interested, check out https://www.cpetoday.com/event/data-and-statistical-analytics-using-microsoft-excel-webinar-24e0439/. thanks again. cheers. steve.
arthur cooke
mr. yoss
where can i find the information on how to use excel ets function