This lesson covers the VBA topics: Arrays, Collections and Dictionaries. Each one of these items help you use macros to manage, calculate and process large amounts of information. Why are these needed? Because performing cal...

Buy Now From Amazon

Product Review

This lesson covers the VBA topics: Arrays, Collections and Dictionaries. Each one of these items help you use macros to manage, calculate and process large amounts of information. Why are these needed? Because performing calculations in macro is exponential faster than performing calculations in a worksheet. Seriously faster. This lesson has a sample workbook where you can test and see the performance improvements.

If you are new to my lessons (by lesson 10 you shouldn't be...but who knows!), you will see a link in the lesson where you can download follow along workbooks so you can practice what you read.

I also don't abandon you after you buy the lesson, if you have any questions, you can email me and I will help you out.

Similar Products

Mastering Excel Macros: VBA Forms and Events - Book 9Mastering Excel Macros: FileSystemObject  (Book 8)Mastering Excel Macros: Debugging (Book 2 of Mastering Excel Macros)Mastering Excel Macros - IF Statements (Book 4)Mastering Excel: Interactive ChartsMastering Excel: Building DashboardsMastering Excel: Power QueryMastering Excel Macros: PowerPoint Automation (Book 7)Mastering Excel Macros - Function Procedures (Book 11)Mastering Excel Macros: Looping (Book 5)