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.

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.

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

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.

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

This one was completely new to me. Great tutorial.

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

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.

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!

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.

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.

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

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

This is actually really awesome. Thanks for teaching to us sir 🙏😊

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.

Thanks much! I appreciate your teachings 🙂

Could you please make videos on T-Test? All the different types please. You simply are the best. I watched many videos on KZfaq 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.

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

Totally different and amazing. I don't know what Excel cannot do...

Sooooo helpful videos.. Get job man!! 👍👍👍

Thank you for this tutorial, i really appreciate.

Great lecture! thanks!

Thank you. Very good tutorial

It is helpful at all ; thank you

Thank you.😁

Greetings to you Sir. I wish I could have followed you long back, I would have learnt many things.

Thank you very much. Very informative.

Great video and explanation. Thank you

can you please do video on placing your data on a pie chart. great videos!

Thanks a lot, I learned a lot from your video.

Totally different and cool

Thank you very much!

Very informative and useful

Thank you. This helped.

Hello. Thanks for the video. Can you also use the FORECAST function, have a separate colour line on the chart and not just an extension of the trend and growth? What do you think?

amazing video thank you

So..helpful

awesome. great tutorial.

Amazing sir I learned all excel from you

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.

excellent explanation keep it up

Thank you!!

Wow. Thanks

thank you so much!!!

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.

Great video

You saved me. Thank you Brother.

the auto fill for growth forecast is not exponential. is it just based on a linear trend?

Do you not teach Microsoft access as well? I cannot find any of those in your channel. I wish you would . You helped me to finally understand Excel ! So , I am sure I would have same experience if you taught Microsoft access.

thanks...

this was little tough, though i understood it

pleasing.

How to align multiline text in one cell after a Bullet without moving bullet?. Problem is Bullet also moves as the first letter of text. I want to keep it fixed at a space and rest of multiline text, aligned and move with indent. Bullet should be stationery and text goes indented. Both the Bullet and Text are in same cell.

COOL

I cannot do the ctrl+shift+enter function. only appear result when i press enter only. does it show incorrect result?

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!

when i enter CTRL + SHIFT + ENTER i get message multi cell array formulas are not allowed in tables. any solution?

7:20 min..... I tried without Ctrl+Shift+Enter. Just pressed Enter. Excel gave me the same result. Why is that?

The chart keep requiring that my location chosen is invalid

like and subscribe. thanks you are the best

Its not working with ctrl i cannntttt

Who else is here because they said they know everything about Excel? 😂

my wife shes dead

Then what's the difference between trend and growth? ²⁴