Excel Advanced Formula

"Your life is what you choose it to be" In essence whatever we give to life it returns the same. If we give peanuts, it will return peanuts. If it is 1 life will return...

A classical scenario to understand the excellence of Excel. There might be situations where we would like to split the email address in two parts i.e. the username (part at the left of @...

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

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

A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his best to get his head round the problem but in...

We have been provided with a top secret data of one lab situated at the very center of the earth. A team of vigilant individuals take readings of different parameters to monitor the temperature...

One of our community member asked how to convert rows to columns or make columns as rows in Excel quickly without using pivot tables? Making rows appear as columns or columns as rows is called...

Data validation lists are one easy way to keep your data error free and other benefit it is that it automates data entry to some extent. For those who are unaware of data validation...

Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported to Excel where calculations and everything is done much more...

Often we have to deal with dates as they form integral part of almost every data set. But what if you want to count specific weekdays within a large range of dates? This is...