Tuesday, September 27, 2011

How to Quickly Change Orientation of an Excel Table

You may have a list of items going down a column.


For some reason you want to change the orientation to make it go across a row instead.

How can you do that?

It is quite easy actually.
Highlight all the items in the List and Right-Click Copy them.


Then go to any empty cell and Right-Click 'Paste Special...'
Note: Make sure that you allow for enough space for the row to go across. Otherwise your data may be overwritten.

Tick the Transpose Option.

VOILA! Your new list is ready.

Thursday, September 8, 2011

Debtor Journal

There are times when you require to post a correcting journal against a debtor account. A common example would be to write off a small amount due to rounding difference or exchange rate difference. You might have a number of transaction lines against the debtor which can be considered 'settled'. Since you can't issue a receipt against it, the alternative way is to use Debtor Journal Program.

From the program, you can post balancing or correcting figures against the debtor and it will update both Debtor Subledger as well as the General Ledger. This ensures that your GL and Subledger remains in balance.


Related Posts Plugin for WordPress, Blogger...