# How to Use TREND in Excel

Save

Excel is the spreadsheet software of the Microsoft's Office suite of productivity software. It is commonly available on most PCs and a large number of Macs. Excel manages information through a series of tables. The values in the tables can be inter-related and manipulated through built-in functions. TREND is a built-in function that "returns values along a linear trend," according to Microsoft's website.

• Open Excel, and either open a data file or type data into a blank worksheet. The data must be at least one-dimensional (a list of points), though two-dimensional data (two values per data point, as on a graph) can be processed also. Data values should be in a consecutive list with one data point per cell.

• In the cell where you want the trend calculated, type "=TREND(" in the formula box and then hold the "Shift" key while selecting the dependent data points (y-values on a graph). This should insert an array of cells that is formatted like A1:A14, except with the appropriate letters and numbers.

• If you have a set of independent data points (x-values on a graph), insert a comma into the formula then select ONLY those data points that directly correspond to the dependent data points already selected.

• The best way to calculate a trend is to also include future independent data points. This allows the function to correctly predict where you are going. If you have such data points, insert a comma and then select the data points.

• Once all the values have be inserted a close parentheses is needed, ")", to complete the formula. Press "Enter," and the trend should be calculated.

## Tips & Warnings

• This works on Microsoft Office 2007. The trend syntax is: TREND('y-values', ['x-values'], ['future x-values'], ['constant']).

## References

• Photo Credit Jack Hollingsworth/Photodisc/Getty Images
Promoted By Zergnet

### You May Also Like

• What is an Excel Formula?

Excel formulas are used to perform calculations, identify trends and consolidate numbers from disparate sources. These dynamic and valuable functions provide crucial...

## Related Searches

Check It Out

### Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.