How to Count Unique Values in Excel (Formulas)
Sometimes we may want to know the number of unique values in a dataset. For example, if you have a list of names with repetition, you may want to find …
Steve Scott
How to Refresh Pivot Table in Excel? (Shortcut + VBA)
A Pivot Table is the simplest data analysis tool that provides a summary of large and complex data. Moreover, Pivot Tables are flexible and we can transform the table as …
How to Highlight Dates Before Today in Excel?
There may be instances in which you will need to call attention to dates before today’s date. This could be to capture payments that were due but were not received …
Calculate Days Between Two Dates in Excel (Workdays/Weekends)
Calculating the number of days between two dates in Excel is a popular operation performed in different scenarios. For example, project managers use it to measure performance against milestones, and …
How to Rearrange Rows In Excel
While working in Microsoft Excel, you may have a need to rearrange rows in order to show the data the right way. In this tutorial, I will show you some …
How to Add Border to a Chart in Excel?
A border makes a chart in Excel stand out and attract the readers’ attention. If you have multiple charts on the same sheet, adding a border also makes them look …
How to Calculate the Number of Months Between Two Dates in Excel?
Sometimes you may want to find out the number of months between two dates. For example, if you are a project manager, you may want to find out how many …
Remove Middle Name from Full Name in Excel
There may be times when you are given a full name and need to remove the middle name so that you are left with the first and last name only. …
How to Remove Scientific Notation in Excel
While Excel is built to work with large numbers, when you enter a number that has more than 11 digits, you would notice that these are converted into scientific notation …
How to Copy Row Height in Excel
We often came across a situation where we want to copy the row height from one row and apply the same to other rows. It would be quite tedious to …
Excel Shortcuts Not Working – Possible Reasons + How to Fix?
Shortcuts refer to the combination of keys used to complete repetitive tasks instead of scrolling through various ribbons to achieve the same objective. These shortcuts come in handy when you …
How to Change Date and Time to Date in Excel?
A lot of times, when I download data from a database or from the web, it has the time as well as the date in the same cell. And many …