Explanation: Applying a credit memo on an invoice can be done through the receive payment section of the software. Before a credit memo is applied, an invoice would have been issued and it is either a payment is received in cash or check or a credit memo is issued to the customer on that particular invoice.
To apply the credit memo on any invoice, the receive payment option is clicked, then the credit memo is applied on the invoice applicable to remove the outstanding debt on that particular invoice.
When you convert your range of data into an Excel table, by default, the Excel shades every other row in the table, making them easy to read. You can turn on/off the banded-row option from Table Style Options under the Design tab. You can also have banded columns.