

Category Archives for "Excel Tips"

0 Calculate the Number of Months Between Two Dates in Excel (Easy Formulas)

Difference between YEARFRAC and DATEDIF and YEAR & MONTH function

If you manage multiple projects, you would have a need to know how many months have passed between two dates. Or, if you’re in the planning phase, you may need to know the same for the start and end date of a project. There are multiple ways to calculate the number of months between two […]

0 How to Sort by the Last Name in Excel (Easy Guide)

Watch Video – How to Sort By Last Name in Excel If you work with names datasets, sorting it is one of the common tasks you would have to do often. It’s quite easy to sort data alphabetically based on the full name, where Excel uses the first character of the name to sort. But […]

1 How to Stop Excel from Changing Numbers to Dates Automatically

Number Changes to date when entered in Excel

Excel has some really smart features that can be really useful in many cases (and sometimes it could be frustrating). One such area is when you enter numbers in Excel. Sometimes, Excel automatically changes these numbers to dates. For example, if you enter 1/2 in Excel, Excel will automatically change this to 01-02-2020 (or 02-01-2020 […]

0 Change Negative Number to Positive in Excel [Remove Negative Sign]

Formula to convert negative numbers to positive numbers

Watch Video – Convert Negative Number to Positive in Excel Most of the people who work with Excel spreadsheets deal with numbers in large/small datasets. And when you work with numbers, you will have all types of it (positive, negative, decimals, date/time). One of the common tasks a lot of us need to do often […]

0 How to Remove Cell Formatting in Excel (from All, Blank, Specific Cells)

Dataset from which formatting is to be removed by copying from another cell

In Excel, you can easily remove cell formatting with a few clicks (or a keyboard shortcut). You can also copy-paste formatting from one cell/range to the other. Or, you can choose to clear the formatting from cells that contain a specific value or a specific format. In this short Excel tutorial, I will show you […]

0 How to Calculate Square Root in Excel (Using Easy Formulas)

Append square root symbol to a value using ampersand

It’s amazing how you can find multiple ways to do the same thing in Excel. After all, there are so many awesome functionalities and functions. A really simple and often needed task is to calculate the square root in Excel. And as I said, there are multiple ways you can do that in Excel (formulas, […]

0 Convert Time to Decimal Number in Excel (Hours, Minutes, Seconds)

Convert Time to Decimal using the CONVERT function

By default, date and time are saved as numbers/decimals in Excel. But you often see it in different formats because of the way the cells have been formatted. For example, in the below example, the value in column A and B is the same, but these are displayed differently because of the format. And one […]

1 2 3 … 37 Next »