Buy Dideo Subscription
This video demonstrates a number of percentage calculations performed in Microsoft Excel, including the following: Calculate what one number is as a percentage of another - eg 78 of 150 staff are female, what percentage of staff are female? Calculating a percentage of a value, eg markup on our goods is 23%, what is 23% of £75 as a monetary amount? Calculating a retail price based on a wholesale price once the markup has been added. eg the item was bought at £130, the markup is 15%, what should I sell the product at? Calculating discount, eg we want to apply a 45% discount to our normal price - what will the new price be? Working out the percentage difference between two values, eg year1 sales was £1200, year2 was £1550. What is the percentage increase? Also, adding and removing VAT from an amount. ------------------------
