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.
Subscribe to:
Posts (Atom)