Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
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 …
It is often tempting to combine several related cells of your worksheet into one by merging them together. It could be for aesthetics and alignment or it could be a …
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 …
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 …
The best way to draw a user’s attention to a cell or some text within a cell is to make it look different from the rest of the text. One …
At some point, you might have come across a cell with a number of pound symbols or hash characters (####). If you’re a beginner and seeing this for the first …