Discover 5 different ways to find the last row in an Excel sheet using VBA. I will also, suggest my preferences as we move through the code.

Discover how to build a dynamic report using dynamic arrays. We will copy data from source and paste it using a mapping table. We will also, do a look style operation using arrays.

Learn a powerful way to aggregate data using the SQL Group By clause within Excel VBA. We will also, cover some basic SQL statements. In addition, we will look at error handling.