Advanced Excel: Using Charts and Functions to See Trends
Advanced Excel: Using Charts and Functions to See Trends
Learn how to show trends in Excel by using Excel charts and a couple of functions: trend and growth. You’ll also learn how to create a forecast of what could happen in the future based upon the past and current trend of your data. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here’s my entire playlist of Excel tutorials: http://bit.ly/tech4excel Here’s the practice file that goes with the video: http://bit.ly/exceltrendsbefore Here’s what your spreadsheet should look like when the video’s over (if you follow along): http://bit.ly/exceltrendsafter
like and subscribe. thanks you are the best
amazing video
thank you
This one was completely new to me. Great tutorial.
this was little tough, though i understood it
when i enter CTRL + SHIFT + ENTER i get message multi cell array formulas are not allowed in tables. any solution?
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.
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!
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.
i don’t understand what trend mean in the graph but i love the video, very insightful
Thanks much!
I appreciate your teachings 🙂
Great lecture! thanks!
Sooooo helpful videos.. Get job man!! 👍👍👍
the auto fill for growth forecast is not exponential. is it just based on a linear trend?
thanks…
So..helpful
Thank you.😁
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
Thank you very much!
7:20 min….. I tried without Ctrl+Shift+Enter. Just pressed Enter. Excel gave me the same result. Why is that?
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.
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 a lot man for your teachings & instructions
you’re the best
Amazing sir I learned all excel from you
Totally different and cool
Thank you very much. Very informative.
pleasing.
I cannot do the ctrl+shift+enter function.
only appear result when i press enter only.
does it show incorrect result?
COOL
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.
It is helpful at all ; thank you
I came to this channel looking for one video on the pivot table and ended up watching 7 8 videos. engaging and well explained..
Thank you.
Very good tutorial
Thank you!!
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.
Totally different and amazing. I don’t know what Excel cannot do…
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!
my wife shes dead
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.
You saved me. Thank you Brother.
Greetings to you Sir.
I wish I could have followed you long back, I would have learnt many things.
Wow. Thanks
Very informative and useful
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.
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.
Its not working with ctrl i cannntttt
Who else is here because they said they know everything about Excel? 😂
This is actually really awesome. Thanks for teaching to us sir 🙏😊
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