Calculate Percentage in Excel the Right Way (% Change & Amount after % increase)
ฝัง
- เผยแพร่เมื่อ 28 มิ.ย. 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
How to calculate percentage in Excel. Learn how to show data effectively for reports for example when calculating percentage change (percent increase or decrease) from Actual to Budget or this year to previous year. Learn the correct Excel percentage formula to apply.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/percentage-...
👩🏫 What You'll Learn:
▪️ Percentage Formula: Master the simple formula for calculating percentage change - a crucial skill for report analysis.
▪️ Percentage Increase/Decrease: Understand how to adjust prices or values in Excel with percentage increase or decrease.
▪️ Practical Examples: Follow along with clear examples, including actual sales data and budget comparisons.
▪️ Excel Tips: Get handy tips on correctly inputting and formatting percentages in Excel to avoid common mistakes.
Also learn how to calculate the final amount after a percent increase or percent decrease. For example if you have a 10% price increase - what is your final value?
You also need to be careful when inputting percentages in Excel. I show you different methods on how to do this properly.
This math percentage tutorial applies to calculating percentage change in all versions of Excel and also outside of Excel.
Excel Basics Playlist: • Excel Introduction - L...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/percentage-change-file
This was good. Thanks. Could you do a quick video on the best way to calculate compound annual growth rate using Excel?
Leila, for short timeframes, you can also calculate % change as ln(new/old).
That way, if you have a sequence of events, such as daily stock market data, you can just sum the % change of a range (ie week) to get the % change in that range (ie for that week)
I learn something EVERY time I watch your videos. Thank you!!!
EXACTLY what I needed. I'm working with budget information, and this was perfect. And right at the beginning of the video. Thank you!!
My pleasure Chuck.
Thank you Leila for your amazing tutorials, this one is so basic yet highly needed one. Absolutely loved this.
Version 2010 and on (not sure about earlier) of the pivot table does this also. Even if you prefer the worksheet with formulas, it's a great way to check.
Thanks Leila! I teach statistics and very happy to see your lecture!
You explained that very well and understandably, Ms. Leila Gharani. I always enjoy watching your videos.
What an amazing lesson! Thanks L.
Really useful guide about percentages. Thanks!
Thanks I been calculating percentage for 20 years in excel, Never thought of this smart way to do it.
Thank you. That's what I was looking for. You're great.
Leila, you are my saver, You help me every time. THX. BR from Slovenia.
I use DAX all the time and love learning from your tutorials and not only that you are a beautiful intelligent lady!
Amazing video! Thank you for sharing this with us.
Thank you Leila. Other ways to do basic math formulas would be nice. You could make it a special series of videos.
We all love you, you are a big source of knowledge for the entire world, thanks for what you do.
Love you Leila. Many thanks for your video tutorial. I have improved my skill in ms excel.
My wife teaches these percent applications to junior highers. They do it by hand instead of in Excel. She said your approach to writing the formulas gave her new ideas on how to explain it to them. Thank you!
I would rather do it by hand
simple enough and that's ok. Sometimes a review of the simple things is important!! Thanks, Leila!
This is my go to lady for Excel questions! Thank you!
Brilliant. Exactly what I was trying to do. Thank you!!!!!!!
Absolutely Amazing. Love it
I am so surprised! I was thinking about how to calculate the change in variance analysis - believe me once I opened youtube it showed the useful video - was that by chance? Leila covered every valuable tips :)
EXCELent, as usual!
Lovely .. straight & clear.!!!
I always watch your videos with great interest.
Thank you very much!!
Always good to review the very basics...
Was Always looking for this concept.. Finally found it. Thanks for teaching elemental basics and then excel!
Cool % video, Teammate!
@excelisfun you and Leila are the best Excel teachers.
Thank you Teammate Mike :)
I like you both and all of your training
always love you. i bought your course on udemy and it's really useful for my work. thanks for always update new trick.
Always clear, Thank You
Thank you. Great lessons!
Cool. Makes learning so meaningful. Thanks for sharing the tips.
Excellent, Leila! A lot of people - especially in the media - misuse percentages. For example "the amount of sales decreased by 200%" - impossible! Or "they increased by 300%" when a threefold increase was what happened, that should have read "they increased by 200%" (or better "to 300% of the initial figure").
Yes, and years ago I explained to someone that 100% more then is the same as 200% as much of.
I might have a problem too where when media makes this mistake I interpret it as what they said actually means and not what maybe they might actually mean. It's not my fault I'd they are saying it wrong.
again and again i wont stop thanking you :) love your videos
I watched your video this morning and used it already in the afternoon. Thanks, keep them coming.
Awesome! Thank you!
Thank you, Leila! You are a godsend!
Thank you! So simply laid out, appreciate it.
You're very welcome!
Great as always! I have a conundrum that I’m hoping you can help with. I have been sent a spread sheet with actual % and budget % (no figures to work with) how would I find the percentage change between the 2 percentages? Hope this makes sense.
Marvelous....too good... a great knowledge shared by Leila
Great! It is inspiring! It made my job easier. Thank you!
*Wasted whole night using a calculator & manually entering % addition data*- Now I have learned the time-saving way. Much appreciated & thanks for your efforts
Glad it helped!
So much informative and proper video. Keep updating these like video. I'm also getting inspired by these video, thus i've also created a youtube channel on Microsoft Excel.. Thank you..!!
I really enjoy your content. It’s such a great help. Thank you.
My pleasure. I'm glad you like it.
THANK YOU for this video. This is the help I needed to simplify my formulas.
You're very welcome.
This particular video is one of a kind, but guess what? you are such a genius!
You are awesome and thanks for sharing such valuable tips
thank you for your efforts
Thanks for the video. Simple and easy to understand.
You're welcome, Deon!
Videos are amazing. Watched you do this in IF functions and was slightly confused. Thanks for clearing up
Glad it's helpful.
Been wondering how this was calculated for a while. Thank you!
You're very welcome Giacomo.
Having seen a lot of your videos I have to congratulate you on your detailed approach to any issue that you are trying to explain. I consider myself an advanced excel user and still there are bits that I am learning from you. I see a lot of %changes as my daily job and I see people struggling. First you have to identify your starting point and then identify your terminal point. For example Budget sales is my starting point and the Actual sales my finishing point (it can easily be the other way around, depending on what you want to present). With the %chnage we are trying to find out what is the number to add on top of the budget sales (starting point) so to arrive to the actual sales (finishing point). And always the %change = (Terminal point / Starting point -1), that is the only that you have to remember so in your example is Actual/Budget-1. You might have year1 and year2 data the %change is different if the starting year is year1 and different if is year2, but always the correct formula is (Terminal point / Starting point -1). Special cases If year1 sales=120 and year2=0, then the %(year2 vs year1) = (-100%) but if year1=0 and year2=120 the %change is not defined as there is no number to multiply 0 (the starting point) and arrive to 120 (finishing point). As an analyst when I came across these cases I rather have a text saying something like "No sales in previous year" but not +100% that is totally incorrect.
Very good explanation. Thanks for the valuable feedback Christos!
Gotta have the basics covered. Many thanks for the nice tutorial.
You're very welcome :)
Thanks!!! Love your work.
Thank you!
Great lesson, really appreciate it
Thank you for the tutorial video :) quite useful.
understood . good teaching
There is one vlogger . Its channel is innorative. He discussed computing growth. This his formula =(current-previous)/current
Thanks for the help
very helpful, thanks
I couldn't concentrate admiring your beauty. Thank goodness I found you. I have to do a price increase to my inventory (1000+ products). I'm going to buy the course. You just made me the day *night. Thank you!
That's great. I hope you'll enjoy the course.
very helpful as an accountant ...
This one was a huge efficiency for me!
I finally want to learn how to work with excel and this will be a great learning base.
Thanks for valuable information 🙏🏻
THANK YOU SO MUCH Leila for this vidéo
Sister your videos are very knowledgeable. Love and respect from India
Beautiful soul! Quite rich, thank you dear
Thank you so much for the video on percentage increase and decrease.
You're most welcome.
Thanks Leila Gharani for your smart video !!!
Awesome... thanks a lot
Liked before starting 👍
Thanks for the video! easy!
Dayum! You Rock. I was playing with this not long ago and had to give up because I was making all the mistakes you mentioned. Thank you for all your help.
You're very welcome. I'm glad you found this useful.
you are the best , thank for all sharings and posts
Question: in your first example you calculated actual v budget percentages for individual entries in the row. If I wanted to calculate the overall average budget v actual between all of the entries, what would be the best way? Should I run the average of the % in the column? Or should I add all my numbers and denominators and then divide?
thank you lol, I needed this for my macroeconomics class
Thank you, Leila! Be wary of margin and markup - e.g. cost= $80 and sale price = $100; the markup is 20/80 = 25% but the margin is 20/100 = 20%.
margin is 20/100 = 20%
@@elbaymammadyarov8120 Correct!
Good stuff. How about irregular percentage increase in n years? Is there Leila version channel for Word?
Very good it helped me so much... 👌👌👌👌👍👍👏👏👏🌻🌻🌻
how person dislike this video and its content. Leila did huge effort to simplify, make easy to understand and hoe to implement the subject. moreover, she explained a nuances too. thank you Leila for your generous knowledge sharing and all you've done.
I appreciate that!
Thank You very much!
You rock! I became your fan. Your videos are spectacular.
I'm happy to hear that Patricia. Great to have you here!
Thank you so much!!!!!!
Thank you 💖
Thanks.Grate lesson
Hi Leila, I have an amendment for your formula. In Excel if you want to find out what percentage represent a value from a different one the right formula I've found (I'm using EXCEL 2007) is: =((new value cell/initial value cell -1)+1). In this way, if I am formatting the cell as "%" the result showed will be exactly the value of the percentage I am looking for.
Thank you for your work!
excellent video
thanks a lot you are the best
Very nice video, you are very good to simplify every problem .
Keep posting such informative videos. Thanks for sharing !
Glad you find the video helpful!
Thank you so much!
You're welcome!
Thank you so much for very great video. It helps me lots. I have a question, related with IF function.
my question is :
Richard asks you to calculate the membership prices for the first quarter memberships sold in the gallery ticket office. The individual membership price is $50. Students pay a discounted price of $25.
In cell F5, create a formula using the IF function to determine the membership price based on the following criteria:
a. If cell D5 (the Category) is Student the price is 25. (Hint: Student must appear in quotes. Do not enter $ for the price.)
b. All other individual members must pay 50.
Copy the formula in cell F5 into the range F6:F13.
Basic but lovely
I have learned so many idea from your videos.please keep teaching us.
I'll definitely do that. Glad to hear the tutorials are helpful.
very cool, elegant formula....
Awesome!! 👍👍
very nice. Thanks for sharing such a grate lesson.mam