The TREND and GROWTH functions are array functions that create series of values based on regression techniques. TREND produces a straight line if depicted in a chart and GROWTH produces an exponential line, typically curved. Highlight multiple cells before entering these functions. Press Ctrl+Shift+Enter.
- [Voiceover] In this worksheet called trend,…we see some data in columns A and B,…potentially some data in columns C and D.…We've got a chart to the right.…As I click on the chart,…you can see that it is prepared to pick up data…in columns C and D.…We've got sales data here,…as I scroll down,…beginning in January 2014 all the way through June 2016.…Now, you may or may not be familiar with the concept…called a trend line.…On a chart,…it could be a column chart, line chart,…a few other types as well.…If you right click, this case the line,…an options called add trendline.…
And what Excel adds is what's called…a linear trendline.…Now,…possibly what we might want to show here,…with the same line,…is the actual numbers that comprise this line.…And we can do that with the trend function.…We're about to do this in column C.…So we don't necessarily need to use this,…but this alerts us to the idea.…A linear line is analogous to the function called trend.…It's an array function.…Now, another kind of function is called exponential.…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome46s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Build analysis with TREND and GROWTH regression techniques