Understanding Excel CHOOSE() function [Intro]

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

Splitting/Extracting Username and Domain name in Email address using Excel [LEFT and FIND function...

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

Creating Currency Converter in Excel [How To]

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

Extracting Integer and Decimal portion from a number in different cells – Part 1

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

Adding specific Prefix to All cells or Specific cells in Excel – 3 Methods...

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

Conditional COUNT in Excel: Count cells meeting multiple criteria + Data Cleanup Tip

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

5 Ways to Transpose in Excel – Shifting Columns to Rows or Rows to...

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

Excel Dynamic Data Validation Lists – Explained

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

Building a reference to specific Worksheet based on Cell value using Formula

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

Count Specific Weekday or Weekdays within Data range containing Dates

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...
12,446FansLike
2,147FollowersFollow