Instead of demonstrating what each of the thousands of functions does in Excel, it’s most helpful, I think to demonstrate how to solve real-life scenarios and the formulas that come in handy as secondary. Today, I present this. The Challenge: You are given 2 datasets of fruits and their prices. One set includes some items/fruits … Continue reading A Real Data Merge Challenge (Excel)