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.

Learn to extract attachments from Outlook messages that are saved onto our computer drive. This is a safe and low-risk way of extracting attachments, compared to directly connecting to Outlook.