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

11 months ago
21
calculate percentage change excel percentages percent change formula percent change explanation percentage increase original amount after percentage change percentage number formatting excel percentage change minus 1 math percentage tutorial Leila Gharani Excel 2016

February 21, 2019 Excel Introduction - Learn Excel Basics

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials

How to calculate percentages 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.

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.

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/calculate-percentage-change/

Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0

★ My Online Excel Courses ► https://courses.xelplus.com

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

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!

#MsExcel

Loading comments...