The TREND function has three primary uses in Excel: Calculate a linear trend through a ... function calculates what would be the line of best fit on a chart using the least-squares method.