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

Excel’s SLOPE function makes this simple: =SLOPE(known_Ys, knownXs) Let's try to get the slope for the trend in the last section's example.

Excel PERCENTILE and IF function basics. The PERCENTILE function in Excel helps you find the K percentile in a set of values. For instance, you’d use this function to see which Salespeople are in the ...

In the first post in this series I showed a simple example of how you can use the FORECAST.ETS function in Excel in combination with the Excel cube functions to do forecasting with Power BI data. In ...

Today's Excel tip for those less experienced users is how to use the FORECAST and TREND functions. These functions can be extremely helpful if you sales data or any other series where there is a trend ...

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.

One of the reasons I love using the Excel cube functions to get Power BI data into Excel instead of PivotTables is because they make it much easier to use other native Excel features and functions in ...