How to use the TREND function in Excel You can calculate and visualize trends in Excel using the TREND function. Here's how to use the TREND function in Microsoft Excel.