Learn how to pass dictionaries and dynamic arrays as parameters through a function.
Read More
How to select a dataset minus top row
Read More
We will look at 2 ways of achieving this. Direct and via Offline Saved messages
Read More
Explore advanced Dictionary concepts such as using Arrays and Dictionaries within a Parent Dictionary
Read More
Beginner's introduction to using Dynamic Arrays.
Read More
Learn how to extract unique values using advanced filter and dictionary. Many examples covered such as multiple column combination and criteria based.
Read More
Question and Answers from Youtube related to my videos on Dictionaries.
Read More
Guide to using Dictionaries in VBA. 4 awesome examples.
Read More
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.
Read More