Hey there, I have a SUPER exciting announcement! April is about to get a whole lot sweeter with our Power BI Dashboard Contest! Your mission, should you choose to accept it: Craft the most EPIC d...
https://chandoo.org/wp/announcing-power-bi-dashboard-contest/
Classically, known as "interest on interest", compound interest is the most common type interest used in every day finance situations. To calculate compound interest in Excel, on principal am...
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 formulas. I will also share a te...
https://chandoo.org/wp/how-to-convert-test-scores-to-letter-grades-in-excel/
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 calculate the GPG (Gender Pay Gap) fro...
Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel's SUMPRODUCT formula to calculate weighted average / we...
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 below. In this article...
https://chandoo.org/wp/how-to-get-non-adjacent-columns-with-filter-function-in-excel/
Think of XLOOKUP as an improved version of VLOOKUP. In this article, learn all about the XLOOKUP function, it's syntax, parameters with real-world xlookup examples. The post What is XLOOKUP and...