Explore advanced Dictionary concepts such as using Arrays and Dictionaries within a Parent Dictionary

Beginner's introduction to using Dynamic Arrays.

Learn how to extract unique values using advanced filter and dictionary. Many examples covered such as multiple column combination and criteria based.

Question and Answers from Youtube related to my videos on Dictionaries.

Guide to using Dictionaries in VBA. 4 awesome examples.

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.

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.