When you’re working with Excel’s TREND and FORECAST functions, there are several tips and tricks that can help you get the most out of these powerful tools. Here are some key points to keep in ...

You can use the FORECAST.ETS function to calculate a potential future value based on historical values. I used part of the example workbook available from Microsoft to get to grips with it.