If you're using Excel and you’ve already learned how to use INDEX MATCH, you’re well on your way to becoming proficient with Excel lookups.  What INDEX MATCH MATCH offers you is a more powerful version of the formula.  Instead of just a vertical lookup, INDEX MATCH MATCH allows you to perform a matrix lookup, which ... Continue Reading >>

How to Build an Excel Model: Tab Structure

One of the most important aspects of model building is the way you setup the tabs in your Excel workbook.  Every tab you create should have a specific purpose within your model; otherwise, the tab should be deleted.  By having a clear understanding of the different tabs and their respective functions, you’ll build an efficient ...