Category: Excel Guides

shape
shape
shape
shape
shape
shape
shape
shape
Standard

How to Calculate Depreciation in Excel: SLN, DB, DDB and SYD Functions

Depreciation spreads the cost of an asset, such as a vehicle, a machine or a computer, over the years in which it is used, instead of treating the whole cost as an expense in the year of purchase. Accountants use it to match costs to the income that an asset helps to earn, and it

Standard

How to Do Break-Even Analysis in Excel: Formula, Table and Chart

The break-even point is the level of sales at which your revenue exactly covers your costs, so you make neither a profit nor a loss. Every sale beyond that point adds to your profit. Knowing it helps you set prices, decide whether a product is worth launching, set a sales target and see how safe

Standard

How to Calculate Profit Margin in Excel: Gross, Net and Markup Formulas

Profit margin tells you how much of each sale you keep as profit. It is one of the most important numbers in any business, because a high sales figure means little if the costs eat up most of it. In Excel, you can calculate the gross profit margin, the net profit margin and the markup

Standard

How to Rank in Excel: RANK.EQ, RANK.AVG, Ties and Rank by Group

Ranking puts values in order and tells you the position of each one, such as first, second and third. People rank students by score, salespeople by revenue, products by sales and teams by points. Excel can do this with the RANK.EQ and RANK.AVG functions, and with a few formulas for special cases such as ties