Advanced Excel: Using Charts and Functions to See Trends

[mayacho]

One of the best content I’ve seen. stock is the best though I don’t self trade but I still make my profit with the help of my broker till I'm sure I can start of self trading.

[lailaalfaddil]

Thanks for this amazing information !! If you don't find a means of multiplying money, you will wake up one day to realize that the money you thought you had, has finished. Investment is key, I pray that anyone who reads this will be successful in life

[garavanieli]

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.

[anika]

The whole difference among chart types is in equation result that is used to compute how close the trendline will be to actual forecast (accuracy, as you mentioned). In order to understand this, you need to tick two boxes on the right down panel of the trendline settings: Display Equation on chart and Display R-squared value on chart. Chart whose R-square is closest to 1 will be closest to real results. For example, if R-square of Polynomial chart shows that it is 0.98, it means that you should probably use that chart instead of Linear to make a trendline. So the chart that you used was very far from accuracy, because it's R-square result was only 0.2

[joejackson]

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.

[kathyreese]

This one was completely new to me. Great tutorial.

[wotizlove]

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

[xuanqinglong]

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.

[amgadmigo]

thanks a lot man for your teachings & instructions
you're the best

[JoaoPedroMiridium]

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.

[sachintelang]

I came to this channel looking for one video on the pivot table and ended up watching 7 8 videos. engaging and well explained..

[GerardFunClub]

Wow sir this is amazing. I am a second-year statistics major student, but this is really helpful because the lecturer doesn't go into detail about using excel to do the calculations, so I have to research it on my own. This video is really important for my study.

[judyhounsun]

Could you please make
videos on T-Test? All the different types please.
You simply are the best. I watched many videos on YouTube about T-Test and still don't understand it. I am grateful for the videos on your channel to which I attribute all my excel knowledge and understanding.

[xiaoluliu]

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!

[abdulmarygabriel]

Thank you for this tutorial, i really appreciate.

[JamesRousseaux]

Great video and explanation. Thank you

[jamesfarnham]

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.

[brytonbeats]

Thank you mahn, you have saved me from a lot of calculations😊

[sangeethanarayanan]

Thank you very much. Very informative.

[thatott]

i don't understand what trend mean in the graph but i love the video, very insightful