Here, we look at how to use data imported into Microsoft Excel to perform a linear regression ... "Linear Trendline." To add the R 2 value, select "More Trendline Options" from the "Trendline" menu.