Compound interest is defined as “the interest on savings calculated on both the initial principal and the accumulated interest from previous periods.” Classically, known as “interest on interest”, this is…

We can use Excel’s LOOKUP function to quickly convert exam or test scores to letter grades like A+ or F. In this article, let me explain the process and necessary…

Gender Pay Gap is the difference in pay for groups of men & women and usually based on the average or median salaries. We can use Microsoft Excel to quickly…

Excel 365’s FILTER() function is great for getting a cut of data that meets your criteria. But what if you need to filter and then show non-adjacent columns? Something like…

With the free Data Validation Select Popup (DVSP) tool from Contextures, you can add popup lists to Excel workbooks. Set the rules you’d like for the pop-up lists — allow…

Ever need to extract just the bold portion of some cells automatically? You can use my getBoldText VBA custom function to do that. This function takes a cell and returns…

Did you know that you can use the Excel ERROR.TYPE function to identify specific types of errors on a worksheet? And after the error type is identified, you can use…

So you have a SPILL error in your Excel tables? In this quick article, let me show you 3 easy fixes to the problem. Fix 0: See if Excel can…

Do you want to calculate loan amortization schedule in Excel? We can use PMT & SEQUENCE functions to quickly and efficiently generate the full loan amortization table for any number…

Do you want to create a dynamic dependent drop down list in Excel like below? You can use XLOOKUP and data validation to set this up quickly. It is fully…