Advanced Excel: Using Charts and Functions to See Trends
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
---
Exponential equations are of the form y = ae-bx while linear equations are of the form y = mx + b.
Exponential trends are useful when the data starts to dramatically increase or decrease as x values grow larger. It's hard to use in this case because the graph itself is not following an approximately exponential pattern. If you use a graph with a more exponential pattern in your example, the trend will look a lot less linear.
reply
Exponential equations are of the form y = ae-bx while linear equations are of the form y = mx + b.
Exponential trends are useful when the data starts to dramatically increase or decrease as x values grow larger. It's hard to use in this case because the graph itself is not following an approximately exponential pattern. If you use a graph with a more exponential pattern in your example, the trend will look a lot less linear.
reply
an
went ahead and clicked the last video in your playlist ( after finishing the first video) just to see what else is there.
Just want to express how happy i am that I can just sit down and soak in 41x 10-20 min long educational contect on Excel from here.
Feels great thanks alot, also in this video here you sound 15 years older lol
reply
went ahead and clicked the last video in your playlist ( after finishing the first video) just to see what else is there.
Just want to express how happy i am that I can just sit down and soak in 41x 10-20 min long educational contect on Excel from here.
Feels great thanks alot, also in this video here you sound 15 years older lol
reply
Joe
2 weeks ago I was wanting to take some data from work to present an idea, I needed to do it on excel but never have i done one before nor knew how too. I found your videos and have studied them and now I-m obsessed with spreadsheets and doing them all the time. Thank you so much for sharing your knowledge with us, much appreciated.
reply
2 weeks ago I was wanting to take some data from work to present an idea, I needed to do it on excel but never have i done one before nor knew how too. I found your videos and have studied them and now I-m obsessed with spreadsheets and doing them all the time. Thank you so much for sharing your knowledge with us, much appreciated.
reply
Xiaolu
thank you so much for your clear explanation! it helps greatly! just a tiny suggestion though: could you please arrange the playlist according to the sequence in which it is best for somebody to learn (sometimes it's confusing that it jumps from one topic/aspect to another). thank you!
reply
thank you so much for your clear explanation! it helps greatly! just a tiny suggestion though: could you please arrange the playlist according to the sequence in which it is best for somebody to learn (sometimes it's confusing that it jumps from one topic/aspect to another). thank you!
reply
josh
Hi, thank you for such a wonderful tutorials on charts and trends, I tried to click on the sample excel sheet before and after, but it doesn't seems to download anymore. I wonder if you could still upload the file. Otherwise, its okay.
reply
Hi, thank you for such a wonderful tutorials on charts and trends, I tried to click on the sample excel sheet before and after, but it doesn't seems to download anymore. I wonder if you could still upload the file. Otherwise, its okay.
reply
Jo-o
Doing what you did in the last example, you will turning the exponencial in to a linear -function-, so you can do it when it-s a linear function (what makes sense) but not with an exponencial function.
reply
Doing what you did in the last example, you will turning the exponencial in to a linear -function-, so you can do it when it-s a linear function (what makes sense) but not with an exponencial function.
reply
Garavani
MacBook users to add a trendline: Press control and click a point on the graph displayed. Your videos are great, quick, and easy to understand. Thanks for taking the time to make them.
reply
MacBook users to add a trendline: Press control and click a point on the graph displayed. Your videos are great, quick, and easy to understand. Thanks for taking the time to make them.
reply
-----
I think this way of trend forecast is not correct. Look at the graph. Gray line is not smooth at aruond Dec-18. ( 11:55 )
but i don't know how can I fix it.
thanks anyway!
reply
I think this way of trend forecast is not correct. Look at the graph. Gray line is not smooth at aruond Dec-18. ( 11:55 )
but i don't know how can I fix it.
thanks anyway!
reply
James
I despise trend and growth charts as they -assume- things....we all know what assume does.
But I love your videos!! Thank you for all you do! Jim.
reply
I despise trend and growth charts as they -assume- things....we all know what assume does.
But I love your videos!! Thank you for all you do! Jim.
reply
Al
Thank you so much for your effort. I'm afraid, 10:10 when I click on the right mouse I don't get the COPY VALUE ONLY, rather the regular set.
reply
Thank you so much for your effort. I'm afraid, 10:10 when I click on the right mouse I don't get the COPY VALUE ONLY, rather the regular set.
reply
Add a review, comment
Other channel videos
