Advanced Excel: Using Charts and Functions to See Trends
ฝัง
- เผยแพร่เมื่อ 29 ก.ย. 2024
- 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***: / technologyforteachersa... Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Here's the practice file that goes with the video: bit.ly/exceltre... Here's what your spreadsheet should look like when the video's over (if you follow along): bit.ly/exceltre...
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.
I'm looking forward to investing in the stock market. I am still trying to figure out how the entire thing works
@@theresagarcia1218 Obviously trading in stock is very volatile and risky, that's the reason most investors trade with a professional broker.
@@theresagarcia1218 My personal broker/investment manager is 'PRISCILLA DIANE AIVAZIAN", she runs a stock investment platform where you don't have to undergo any stress in the trades, she manages my account and all I need to do is invest capital and she gets a tiny bit of my returns as her commission. Just look with her name online, she can help you get started.
@@mayacho4910 Thank you for this, i will be sure to look her up, hopefully she can help.
@@theresagarcia1218 Welcome.
Thank you very much!
So..helpful
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.
this was little tough, though i understood it
7:20 min..... I tried without Ctrl+Shift+Enter. Just pressed Enter. Excel gave me the same result. Why is that?
my wife shes dead
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
You're absolutely right , to be successful in life required not only hard work but awareness and sometime opportunity at the moment , investment remains the best to start .
*ROCHELLE DUNGCA-SCHREIBER* is my portfolio-coach, I found her on Bloomberg where she was featured, I looked up her name on the internet. Fortunately I came across her site and reached out to her, you can verify her yourself.
I can't tell if these are bots or real people.
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
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.
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.
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
This one was completely new to me. Great tutorial.
The chart keep requiring that my location chosen is invalid
OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG OMG 😲 so good
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.
How can we calculate predicted values from the data please?
I came to this channel looking for one video on the pivot table and ended up watching 7 8 videos. engaging and well explained..
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
what is the difference between trend forecast and a growth forecast?
i don't understand what trend mean in the graph but i love the video, very insightful
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.
what is the difference trend forecast and a growth forecast?
Could you please make
videos on T-Test? All the different types please.
You simply are the best. I watched many videos on TH-cam 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.
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.
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.
Sooooo helpful videos.. Get job man!! 👍👍👍
when i enter CTRL + SHIFT + ENTER i get message multi cell array formulas are not allowed in tables. any solution?
Go to DESIGN tab and click Convert to Range. You cannot do it in a table.
Who else is here because they said they know everything about Excel? 😂
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!
Thank you mahn, you have saved me from a lot of calculations😊
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.
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 cannot do the ctrl+shift+enter function.
only appear result when i press enter only.
does it show incorrect result?
Couldn't do it as well. There must be another way to have this shortcut work.
Thanks
Greetings to you Sir.
I wish I could have followed you long back, I would have learnt many things.
Totally different and amazing. I don't know what Excel cannot do...
Great video and explanation. Thank you
Thank you for this tutorial, i really appreciate.
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?
Great video
Thank you very much. Very informative.
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.
pleasing.
can you please do video on placing your data on a pie chart. great videos!
like and subscribe. thanks you are the best
Thanks a lot, I learned a lot from your video.
Amazing sir I learned all excel from you
Very informative and useful
awesome. great tutorial.
Thank you. This helped.
excellent explanation keep it up
thank you so much!!!
Thank you.
Very good tutorial
Thanks much!
I appreciate your teachings 🙂
amazing video
thank you
Thank you.😁
This is actually really awesome. Thanks for teaching to us sir 🙏😊
Thank you!!
Wow. Thanks
thanks...
COOL
Nice explanation
Great lecture! thanks!
It is helpful at all ; thank you
Its not working with ctrl i cannntttt
me too, did you figure it out?
Totally different and cool
You saved me. Thank you Brother.
Then what's the difference between trend and growth? ²⁴