The TREND function has three primary uses in Excel: Calculate a linear trend through a set of existing data, Predict future figures based on existing data, and Create a trendline in a chart that ...