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

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.

👩‍🏫 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.

🚩Let’s connect on social:

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

[dekebell]

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

[chuckriesterer]

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

[rkagi]

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)

[tkosse]

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

[msmith]

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!

[XLGuy]

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

[matthiasheuer]

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

[yulinliu]

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

[Lookchrisng]

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

[netsurfers]

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

[gregorgeorge]

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

[xitcode]

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

[andrewmoss]

Really useful guide about percentages. Thanks!

[DonChevez]

Amazing video! Thank you for sharing this with us.

[practicecomputing]

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.

[maherahmed]

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

[wannabedal-adx]

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

[irviantantohaditomo]

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

[massimoriggio]

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

[karhukivi]

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