Microsoft Excel can generate trend lines based on data you provide, and in doing do, calculates the equation of the trend line. This equation can be accessed using Excel's built-in Visual Basic tools.