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