Tip 4!

Got Payment??!? This is a fun tip to help find out who is past due a specified amount of time. (Hopefully you have keyed in a formula to update the number of days you are passed due) 

Lets say you have accounts that owe money and you want to collect payment from accounts 40 days over but you dont want to run down the list and see whos over. We get to use "Conditional Formating"!

Click the row or column you want to check how many people are over a certain amount of days, click conditional formating, highlight cell rules (you can choose if you want greater than 40 days, less than that, equal to that or even use it to highlight cells with certain words) in this case we want to know whos over 40 days due. So we click greater than and then plug in 40, press okay and viola! it will highlight them the color you choose. 

It is in the Virginia interpreter code of conduct to always get payment in a professional manner. Most of the time you wont bill the client til after you have preformed the service. Its important you are constantly checking who owes money. This tip really works well with other formulas. If the formulas are automated then you can easily search up and highlight information you need. Like lets say I want to highlight all invoiced from Sorenson ( a popular VRS company) I could use this tip. 

Adding color to the excel makes it more appealing and easier to look at. I think for me that is very important because boring deters me. I have to have fun with something I am doing. Part of this journey is seeing how Excel works for me!