Microsoft can’t predict the future — but it can sure try. Excel’s time series forecasting abilities take data you’ve provided and extrapolate potential future data. It’s not perfect, but it can give you an idea of what your data is really telling you. A tiny glimpse into the future, if you will. There are two different ways to forecast in Excel. First, you can use several forecast functions directly within the cells of your spreadsheet. The second method, which uses a graphical interface, is easier to use, so we’ll be focusing on that. If you really want to know how...
Read the full article: Use Excel’s Forecast Function to Turn Historical Data Into Predictions
from MakeUseOf http://ift.tt/2sFBqMj
via IFTTT
0 comments: