Steve Scott 
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 …
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 …
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 …
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 …
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. …
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 …
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 …
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 …
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 …
Tiered commissions are quite common for people who do sales. Tiered commissions provide an incentive for salespeople to boost their sales figures in order to earn more commission. This, in …
In Excel, we often use formulas like INDEX/MATCH, VLOOKUP, and XLOOKUP to match the lookup value but in some scenarios, we came across a situation in which we lookup for …
The Conditional Formatting feature provides an excellent way to highlight or draw attention to data that meets certain criteria or conditions. It is an effective visual communication technique. Spreadsheet designers …