Skip to content
Skills and Automation

Visit my Youtube Channel

YouTube
  • Home
  • Master Class
  • How To
  • Tutorial
  • Project
  • Useful Code
Search
Skills and Automation
Menu
Functions With Dictionaries and Arrays

Use Functions With Dynamic Arrays and Dictionaries

Learn how to pass dictionaries and dynamic arrays as parameters through a function.
Read More
Select dataset except for top row

Select Dataset Except For Top Row

How to select a dataset minus top row
Read More

Download Attachments From Outlook Emails

We will look at 2 ways of achieving this. Direct and via Offline Saved messages
Read More
Arrays And Dictionaries in a Dictionary

Using Arrays and Dictionaries Within Dictionaries

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

Introduction to Dynamic Arrays

Beginner's introduction to using Dynamic Arrays.
Read More
Find Unique Values

Excel VBA: Practical Guide to Finding Unique Values

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

Dictionary Q & A

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

Excel VBA: Practical Guide to Using Dictionary

Guide to using Dictionaries in VBA. 4 awesome examples.
Read More

Excel VBA: Dealing with Excel Errors

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
1 2
Next

Copyright © 2025 Skills and Automation

  • Home
  • Master Class
  • How To
  • Tutorial
  • Project
  • Useful Code