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

Transpose Data in Excel: Shift Columns to Rows or Rows to Columns – 5...

In Excel one can easily convert data columns to rows or multiple data rows to columns which is technically named transpose. https://www.youtube.com/watch?v=sWLAjLbNYkA In Excel switching or rotating columns to rows or rows to columns is called...

Excel Drop Down List using Data Validation and Excel Tables that updates dynamically –...

Excel drop down lists are one easy way to keep your data error free and other benefit it is that it automates data entry to some extent. Data validation help us make such drop down lists easily. For...

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