Beat Excel! Get to next level in Excel!

Power Pivot

Power Pivot takes the power of relational database queries to your desktop. Only requirement is Excel 2010 or 2013. And knowing how to use it...

For Each Loop (Excel VBA)

For Each loop is for looping through each element in a collection. It is especially useful when you don’t know how many elements there is...