Excel Advanced Features

Excel custom number formatting feature is immensely powerful. From hiding things to formatting telephone numbers correctly, to changing colours to use them to insert symbols in data or chart, it is definitely of great...

If Excel ever had a tongue it surely would have told us that eating thousands of rows is as delicious for it as dunking oreos in milk for humans! But we humans have another issue and...

Either it is about daily life or business, we almost all the time in our minds comparing the actual results with our plans. Though we can talk numbers and percentages but the way charts...

Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at all levels. That is why charts and Excel is one...

Last year the same day we learnt how to make a birth date heat map in Excel. So lets another Excel trick exactly one year after. Lets say the date of birth is August 6, 1986....

In the world we live in where almost every country has its own distinct currency and value, we almost always feel a need to convert one currency to another. These days it is easy...

Title should be "making charts dance to your command in Excel" but lets keep it technical :) OK let me be very quick at it as I learnt about this almost by chance. I used...

What if your manager gave you a file with thousands of file names and you have to extract file extensions? If you are following our Excel tutorials on regular basis then it won't be...

When it comes to information then most of the time its about numbers and often numbers come with decimals i.e. numbers that are written as: 9.82 0.9856486 1021587.986244 But what if we are only interested in decimal portion...

Many have the impression that Excel is a tool to do maths. But the ones who are using it on daily basis know that Excel is way beyond just calculation and helps you maintain...