How to customize Quick Access Toolbar in MS Excel

Microsoft Excel has different parts. The Ribbon, Office Button, Quick Access Toolbar, Menu Group, Formula Bar, Address Bar, Status Bar, Headers, Vertical Scroll Bar, Horizontal Scroll Bar and so on.

Each part of excel has its own importance. Let me discuss one of the Important part of Excel, that is Quick Access Toolbar.

And also, we will see what are the new options in Excel 2013 relates to the quick Access Toolbar

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.

How To Convert Number Into Words In MS Excel ? (Example 100 = Hundred Dollars)

MS Excel has so many Text, Financial and Statistical Formulas. But Unfortunately, we don't have the direct formula to convert Number to the Text Words. Fortunately, we have a Macro Code to act for the same.


I found a Macro Code to convert Number to the English Text Words, and I did few modifications to customize.

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??