Excel Table vs. Excel Range – What’s the Difference?
There is a good amount of confusion around the terms ‘Table’ and ‘Range’, especially among new Excel users. You will find many tutorials use the terms interchangeably too. But the …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Apply Short Date Format in Excel?
Working with dates in Excel might not be as simple as working with plain numbers and text, and the reason is that Excel’s way of storing and displaying dates is …
How to Move Row to Another Sheet Based On Cell Value in Excel?
If you’re looking for a way to move rows of data from one sheet to another depending on the value in a given cell, there’s, unfortunately, no direct feature or …
How to Extract Text After Space Character in Excel?
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 …
How to Unmerge All Cells in Excel?
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 …
How to Convert Month Name to Number in Excel?
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 …
How to Remove Duplicate Rows based on one Column in Excel?
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 …
How to Change All Caps to Lowercase Except the First Letter in Excel?
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 …
How to Calculate Hours between two Times in Excel?
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 …
How to Convert Decimal to Binary in Excel
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 …
How to Separate Address in Excel?
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). …
How to Calculate Confidence Interval in Excel
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 …