Mastering Excel Macros: Arrays


Thanks for checking out this lesson.

This is a continuation of the Mastering Excel Macros series. This lesson is a bit more 'programmy' than previous lessons. Don't worry though, I explain everything and it's not that complicated. What is this lesson about? How to use things called Arrays, Collections and Dictionaries to process large amounts of data in a macro.

Doing math in macro is exponentially faster than doing math in a worksheet. When managing 100,000 data points, you want Excel to be as fast as possible. That's where Arrays, Collections and Dictionaries come into play.

Ok, enough talk, put in your details, wait a few minutes for the confirmation email and then get started!

If you do not see the form below, please turn off your ad blocker and try again. If that still doesn't work, try another browser.

Comments on this entry are closed.

Previous post:

Next post: