Monday, March 18, 2019

Customize the Y Axis Values

When creating a chart, most of the time you'd take the default axis labels that Excel would provide. However there are times when you want to provide you own labels, especially on the horizontal axis. This video show you how to customize the Y axis to show descriptive text instead of values.


Wednesday, March 13, 2019

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.


Tuesday, March 12, 2019

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.