Convert to Debit/(Credit) Amount by using Paste Special

Excel is one of the important tool for finance professionals. If I want to present anything or want to draft anything, my mouse directly hit Excel.

Today topic may be very much useful for the accounting guys, who post Journal Entries in the systems.

Most of the ERPs (Enterprise Resource Planning) allow the Journal Entry in the following way.

Particulars	Dr/(Cr) Amount
Cash a/c	$2,500.00
Income a/c	$(2,500.00)

How to count total number of posts from archive in any Blog?

If I visit any of the blog online, I used to see their archive to know the total number of posts. I do, bit analysis about the age of the blog, frequency of number of posts, number of feedburner subscribers etc.,

If number of posts are less, we can easily count the total. If number of posts are more and they enabled archive for weekly subtotal, it is very difficult to calculate the total number of posts for aged blogs.

Today, I will explain you how to count total number of posts from archive for any of the blog by using our MS Excel.

Learn All About Paste Special Options In MS Excel

Copy and Paste are the most powerful options in MS Excel. If we use excel for 1 hour, I am sure we use these two options more than couple of times. I can say, without these options excel is nothing.

Short Cuts:

• Copy - Ctrl + C  (or)  Right Click, C  (or)  Alt + E, C (or) Ctrl + Insert
• Direct Paste - Ctrl + V  (or)  Right Click, P  (or)  Alt + E, P (or) Right Click, S, A  (or)  Alt + E, S, A

Excel given us, 10 wonderful options for pasting Copied data apart from Direct Paste.

Can You Solve This, By Using Transpose, Skip Blanks and Sorting Options ?

Today, I am going to explain you a Cool Trick to Transpose more than one Column Data into Single Row.

See the below case, and Try Your Own.

Did you get any Clue??


OK. Let me give you Few Clues..you can use Sort Option, Transpose Option and Skip Blanks Option

Still Not getting any Clue??