Professor Excel

How to Use Conditional Formatting With Formulas in Excel

One advanced scenario of Conditional Formatting is to use formulas to determine the format. Let’s say, you want to change the background color of cell A if cell B has a certain value.

When to use VLOOKUP, SUMIFS or INDEX/MATCH in Excel

One of the most often used functions when creating an Excel model is consolidating data from different sources. There are 3 major formulas for combining data from different tables or worksheets: VLOOKUP, SUMIFS and INDEX/MATCH. VLOOKUP and SUMIFS are rather popular whereas INDEX/MATCH is usually not that well known. So what is the difference between these 3 formulas and which one should you use? […]

thumbnail, copy, paste, exact, ranges, exact ranges, persist, preserve

How to Compare Two Lists in Excel

Let’s assume, we have the following (although realistic) challenge: We got two lists which should have the same items in Excel. But they aren’t exactly the same so that we need to compare them. But how do we find out the best way, which items are missing in either one of the lists? Instead of comparing manually, there are some easy steps. […]