Data cleaning is probably the most common data pre-processing task. This becomes especially necessary when the data is imported from an external source, which was probably formatted differently. One of …
Converting a date to month name is quite common, but sometimes there may be a need to convert the month name to its corresponding month number. For example, you might …
One of the most common data cleaning tasks in Excel includes removing duplicate or redundant records/rows. While removing whole rows that are duplicate is straightforward, it’s a little trickier when …
We often round numbers up or down to simplify them or make them easier to use. In some cases, we round numbers to a particular integer. There might be situations …
Data that has been imported to Excel from external sources often need to be formatted properly, both for aesthetic as well as functional purposes. If you’ve imported data that contains …
Calculating the number of hours between two given times might be required for a number of situations. You might need to calculate the number of hours needed to complete a …
If you’re working with computers or machines, you might need to convert a set of decimal numbers into their binary equivalents. In this tutorial we will go over how you …
When you work with addresses, it can be convenient sometimes to have different parts of the address split out into Street address, city, state, and zip code (or postal code). …
If you want to find out how to calculate a confidence interval in Excel, you’re in the right place! Here, you can see how a confidence interval is calculated based …
A lot of organizations prefer to use the 24-hour ‘military time’. These include the airline industry, public transport, and of course the armed forces. Besides organizations, there are a lot …
There might be a number of reasons for wanting to convert days to years in Excel. For example, you might have a count of days that have passed and you …
I am sure you have heard the word percentile when people talk about numbers and rankings. I remember it being one of the ways we used to get our ranking …