predicting the future with forecasts.ets statistical analytics in microsoft excel

quick tech talk: financial forecasting the fun and easy way.

subscribe to 卡塔尔世界杯常规比赛时间 podcasts anywhere: applegooglespotifyiheartdeezer, amazon music and audibleplayer fmaudacygaana (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

in fact, forecasting has never been easier than using the forecast ets function.

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.

 

229

2 responses to “predicting the future with forecasts.ets statistical analytics in microsoft excel”

  1. 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.

    reply
  2. arthur cooke

    mr. yoss
    where can i find the information on how to use excel ets function

    reply

leave a reply