Percentages. The very word can send shivers down the spines of many Excel users. In this video you’ll learn how to calculate percentages in Excel. For each of the 6 examples, I explain the scenario, what is required and how to calculate the percentage in both Excel and mathematical terms.


Calculate X percent of a number

Calculate the with-tax selling price given pre-tax price and tax amount

Calculate the new price given the old price and the percentage increase

Calculate a percent increase between 2 numbers

Calculate a percent decrease between 2 numbers

Calculate the amount of tax to be paid given the tax rate and the tax-inclusive price