Calculate Percentage in Excel the Right Way (% Change & Amount after % increase)

Подписаться 2,7 млн

Просмотров 835 тыс.

50% 1

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

Опубликовано:

31 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 481

@LeilaGharani 6 месяцев назад

Grab the file I used in the video from here 👉 pages.xelplus.com/percentage-change-file

@msmith3090 2 года назад

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!

@michaelamccurry6899 Месяц назад

I would rather do it by hand

@chuckriesterer8284 4 года назад

EXACTLY what I needed. I'm working with budget information, and this was perfect. And right at the beginning of the video. Thank you!!

@LeilaGharani 4 года назад

My pleasure Chuck.

@rkagi 4 года назад

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)

@Look4chrisng 2 года назад

Thanks I been calculating percentage for 20 years in excel, Never thought of this smart way to do it.

@XLGuy 5 лет назад

Thank you Leila for your amazing tutorials, this one is so basic yet highly needed one. Absolutely loved this.

@dekebell3307 5 месяцев назад

I learn something EVERY time I watch your videos. Thank you!!!

@yulinliu850 5 лет назад

Thanks Leila! I teach statistics and very happy to see your lecture!

@matthiasheuer 2 года назад

You explained that very well and understandably, Ms. Leila Gharani. I always enjoy watching your videos.

@tkosse 5 лет назад

This was good. Thanks. Could you do a quick video on the best way to calculate compound annual growth rate using Excel?

@wmfield152 4 года назад

What an amazing lesson! Thanks L.

@netsurfers9357 3 года назад

I use DAX all the time and love learning from your tutorials and not only that you are a beautiful intelligent lady!

@xitcode 4 года назад

Thank you. That's what I was looking for. You're great.

@gregorgeorge8868 2 года назад

Leila, you are my saver, You help me every time. THX. BR from Slovenia.

@wannabedal-adx458 3 года назад

simple enough and that's ok. Sometimes a review of the simple things is important!! Thanks, Leila!

@DonChevez1978 5 лет назад

Amazing video! Thank you for sharing this with us.

@andrewmoss6449 5 лет назад

Really useful guide about percentages. Thanks!

@irviantantohaditomo8917 5 лет назад

Love you Leila. Many thanks for your video tutorial. I have improved my skill in ms excel.

@practicecomputing8506 5 лет назад

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.

@massimoriggio6297 2 года назад

We all love you, you are a big source of knowledge for the entire world, thanks for what you do.

@ajexcel 5 лет назад

Absolutely Amazing. Love it

@maherahmed2018 4 года назад

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 :)

@venukrishna8453 Год назад

Was Always looking for this concept.. Finally found it. Thanks for teaching elemental basics and then excel!

@remediationdepartment4332 Год назад

I always watch your videos with great interest. Thank you very much!!

@waltersandoval5038 4 года назад

EXCELent, as usual!

@Highway123456789 2 года назад

This is my go to lady for Excel questions! Thank you!

@daarkthunderr 4 года назад

again and again i wont stop thanking you :) love your videos

@ParadoxGD 5 лет назад

always love you. i bought your course on udemy and it's really useful for my work. thanks for always update new trick.

@Haywoodma419 2 года назад

I watched your video this morning and used it already in the afternoon. Thanks, keep them coming.

@LeilaGharani 2 года назад

Awesome! Thank you!

@karhukivi 5 лет назад

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").

@islandcave8738 2 года назад

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.

@NandaKumar-vg9oy 2 года назад

Cool. Makes learning so meaningful. Thanks for sharing the tips.

@petersmith8134 6 месяцев назад

Brilliant. Exactly what I was trying to do. Thank you!!!!!!!

@sumittrox143 Год назад

*Wasted whole night using a calculator & manually entering % addition data*- Now I have learned the time-saving way. Much appreciated & thanks for your efforts

@LeilaGharani Год назад

Glad it helped!

@reachbhanuchandran Год назад

Thank you, Leila! You are a godsend!

@compufama4678 4 года назад

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!

@LeilaGharani 4 года назад

That's great. I hope you'll enjoy the course.

@mezianeremila454 5 лет назад

Always good to review the very basics...

@kazisazzad9257 3 года назад

Great! It is inspiring! It made my job easier. Thank you!

@iscoalmichael3117 4 года назад

This particular video is one of a kind, but guess what? you are such a genius!

@TechnicalPortal 5 лет назад

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..!!

@jaykiriona 4 года назад

Thank you! So simply laid out, appreciate it.

@LeilaGharani 4 года назад

You're very welcome!

@Betterifitsfree 5 лет назад

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.

@LeilaGharani 5 лет назад

You're very welcome. I'm glad you found this useful.

@dejabluek8297 5 лет назад

THANK YOU for this video. This is the help I needed to simplify my formulas.

@LeilaGharani 5 лет назад

You're very welcome.

@scottgerlach6867 4 года назад

Thank you. Great lessons!

@shanesmohammed 5 лет назад

Marvelous....too good... a great knowledge shared by Leila

@jbkregs2766 4 года назад

I really enjoy your content. It’s such a great help. Thank you.

@LeilaGharani 4 года назад

My pleasure. I'm glad you like it.

@excelisfun 5 лет назад

Cool % video, Teammate!

@sebghatulbarykhabaey6680 5 лет назад

@excelisfun you and Leila are the best Excel teachers.

@LeilaGharani 5 лет назад

Thank you Teammate Mike :)

@Softwaretrain 5 лет назад

I like you both and all of your training

@rlionheart8657 5 лет назад

Thank you Leila. Other ways to do basic math formulas would be nice. You could make it a special series of videos.

@CKBREEZY7 5 лет назад

Videos are amazing. Watched you do this in IF functions and was slightly confused. Thanks for clearing up

@LeilaGharani 5 лет назад

Glad it's helpful.

@surjagain 5 лет назад

Thank you for the tutorial video :) quite useful.

@naboulsikhalid7763 2 года назад

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.

@LeilaGharani 2 года назад

I appreciate that!

@willie3528 2 года назад

I finally want to learn how to work with excel and this will be a great learning base.

@christoslefkimiotis9889 5 лет назад

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.

@LeilaGharani 5 лет назад

Very good explanation. Thanks for the valuable feedback Christos!

@j4v33d 4 года назад

You are awesome and thanks for sharing such valuable tips

@ExcelExciting 5 лет назад

Lovely .. straight & clear.!!!

@karhukivi 4 года назад

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%.

@elbaymammadyarov8120 2 года назад

margin is 20/100 = 20%

@karhukivi 2 года назад

@@elbaymammadyarov8120 Correct!

@robbieknott6901 4 года назад

Thanks!!! Love your work.

@Stef1955 5 лет назад

Thank you!

@knotdavewalker 2 года назад

Always clear, Thank You

@bonifaciojr.piedad4021 3 года назад

There is one vlogger . Its channel is innorative. He discussed computing growth. This his formula =(current-previous)/current

@fahimamf 3 года назад

thank you for your efforts

@GiacomoVaccari 5 лет назад

Been wondering how this was calculated for a while. Thank you!

@LeilaGharani 5 лет назад

You're very welcome Giacomo.

@patrickvazeille6972 2 года назад

THANK YOU SO MUCH Leila for this vidéo

@deondunn3074 3 года назад

Thanks for the video. Simple and easy to understand.

@LeilaGharani 3 года назад

You're welcome, Deon!

@knowledgevoyage8828 2 года назад

Great lesson, really appreciate it

@dushyantbhati2722 2 года назад

Sister your videos are very knowledgeable. Love and respect from India

@ibrahimzimit6241 3 года назад

Beautiful soul! Quite rich, thank you dear

@firojahmad8980 2 года назад

Thanks Leila Gharani for your smart video !!!

@kkyl5175 5 лет назад

Liked before starting 👍

@samseuropejourneys838 5 лет назад

very helpful as an accountant ...

@josephalaguna 2 года назад

This one was a huge efficiency for me!

@markwilliamson6820 5 лет назад

Excellent, as usual. You explain things clearly and concisely. For me, this one wasn't as useful as the others. I'm a certified high school teacher, so I know the math, and I learned spreadsheets on Supercalc 5.1 ( ever heard of that??), so the cell formulas were pretty straightforward. However, this brings us back to my first point: excellent, as usual. Since many people doing this work may not know the math, it's great that you cover it, just to be sure. I think people would rather learn math from you, as they need it, than suffer in my math class. LOL. This is really a great service you are doing. Thank you, and God bless you!

@LeilaGharani 5 лет назад

Thanks for the kind words Mark. I'm glad you like the videos. I'm sure no one is suffering in your class :)

@sametsevim8681 4 года назад

you are the best , thank for all sharings and posts

@ckokse 5 лет назад

Gotta have the basics covered. Many thanks for the nice tutorial.

@LeilaGharani 5 лет назад

You're very welcome :)

@ezekielamadukoroma6942 4 года назад

very helpful, thanks

@santerihuida4215 10 месяцев назад

Thanks for the help

@anishpillai 5 лет назад

These formulas are really helpful. Thanks for this video. However I have a tip for anyone who wants to use these formulas. When I work with clients or fresh recruits or sometimes even my boss 😀, I find it easy to explain it to them by using the formula in layman terms. For example %change would be (Actual-Budget)/Budget.

@figlermaert 5 лет назад

Anish Pillai agree.

@iduncanw 5 лет назад

Much easier to understand and explain. Basically the difference divided by the starting figure.

@patricia5121 5 лет назад

You rock! I became your fan. Your videos are spectacular.

@LeilaGharani 5 лет назад

I'm happy to hear that Patricia. Great to have you here!

@Sachin19831000 Год назад

Thanks for valuable information 🙏🏻

@RahulKumar-zv2nd 5 лет назад

Very nice video, you are very good to simplify every problem . Keep posting such informative videos. Thanks for sharing !

@LeilaGharani 5 лет назад

Glad you find the video helpful!

@faizandhami 3 года назад

understood . good teaching

@gladsonj2333 2 года назад

Awesome... thanks a lot

@rauleestobar5192 5 лет назад

Una vez más; excellent work. Thank you, gracias

@LeilaGharani 5 лет назад

You're very welcome. Glad you like it.

@22Crex 4 года назад

Thanks for the video! easy!

@Shng1968 3 года назад

Thank you so much for the video on percentage increase and decrease.

@LeilaGharani 3 года назад

You're most welcome.

@tramasdelahistoria Год назад

thank you lol, I needed this for my macroeconomics class

@aliyarhusain8276 5 лет назад

very nice. Thanks for sharing such a grate lesson.mam

@qayoumafghan 5 лет назад

Thanks from Afghanistan, nice explanation

@zinghiway 2 года назад

Thank You very much!

@halishahar4544 3 года назад

Thank you very much It helped me a lot. Thank You Thank YOu

@mohamedharoon3750 5 лет назад

Thank you 💖

@RMKserve 3 года назад

Smart trainer Leila and smart tricks♥️❤️

@classicmobile3760 Год назад

Thanks.Grate lesson

@ashoksahu9546 5 лет назад

Hii Mm. Excellent video. Thank you so much.

@atiaabdelkader1905 3 года назад

thanks a lot you are the best

@skgaming1806 2 года назад

Thank You Very Much Leila Gharani I like your video very much

@Llb890 5 лет назад

I have learned so many idea from your videos.please keep teaching us.

@LeilaGharani 5 лет назад

I'll definitely do that. Glad to hear the tutorials are helpful.

@yugalysk3395 Год назад

Thank you so much!!!!!!

@abdanomer 5 лет назад

Basic but lovely

@ssergeant9682 3 года назад

I know enough about xcel to be dangerous. seriously thinking about taking one of your courses but not sure what I need. I'm a small business owner (semi-retired) applying for PPP loan and needed to get percentages of loss from 2019 - 2020. your formula was just what I needed. need to wait for PPP grants or loans before spending any money but am now subscribed. thank you. currently using xcel 2010 but I think I have a newer version. just not installed

@LeilaGharani 3 года назад

Welcome aboard!