Перейти к содержимому

Excel VBA: Practical Guide to Start Using Dictionary [4 Awesome Examples]

Skills and Automation

0:00 / 0:00

Excel VBA: Practical Guide to Start Using Dictionary [4 Awesome Examples]

11 674 просмотра · 4 г. назад
Skills and Automation
3,71 тыс. подписчиков
11 674 просмотра · 4 г. назад
Excel VBA Dictionaries explained in simple terms. Advanced concepts made easy. Unravel the benefits of this awesome tool and take your VBA programming to the next level. We will cover 4 practical use-cases 1. Find Unique Values from a List 2. Perform Sum & Count on Grouped Values 3. Copy & Paste Data Dynamically 4. Perform VlookUps #vba #learnvba #excelvba #excel #exceltutorial #exceltips Dictionaries may be a tough concept to grasp. And that's too bad. Because there are so many great ways to use them in our everyday coding. This video will go get you started with using dictionaries ASAP. Learn the basics of dictionaries and directly start using them in some useful examples. Course file is uploaded to Github: https://github.com/skillsandautomatio... 00:00 Intro 1:33 What is a Dictionary? 2:22 Main Features 3:25 How to Use Dictionaries 9:05 Initial Setup 10:54 Example 1: Find Unique Values from a List 13:02 Example 2: Perform Sum & Count on Grouped Values 17:04 Example 3: Copy & Paste Data Dynamically 21:05 Example 4: Perform VlookUps 23:49 When To Use Dictionaries