Create a Break Even Analysis Chart

This video show how to create a break even chart. Based on fixed and variable costs you can calculate the break even unit totals and dollar amounts with the per unit sales price.

Use the TRIM function

Sometime we get worksheets that have mysterious characters in cells. This makes it hard to compare cells to each other, especially when using lookup functions. It also could cause you to print out strange phantom pages that seem to have nothing on them. Lets learn how to use the TRIM function to get rid of this extra characters in our cells.

Calculate Subtotals in Excel

Have you ever shopped online and mindlessly put items into your shopping cart? Then you go to check out and look at the Subtotal. Then you laugh. Then you close the window. That kind of sticker shock may happen once a while in our shopping lives and it come from the magic of the mathematical concept of addition. This magic is also available in Excel! In addition, you can conjure up sophisticated numbers across different categories with the Subtotal feature in Excel. Learn all this is less than ten minutes (that’s less time it takes to do a full load of laundry!).