by Paul Kelly | | Most Popular, Vault Video
Webinar Number: W0046 This webinar features: * Excel VBA Coding * How to structure your code – it’s not hard once you know the secret. * How to get notified immediately when an error occurs – this idea alone will save your hours of wasted time. *...
by Paul Kelly | | Classes and Objects, Most Popular, Vault Video
Webinar Number: W0041 This webinar includes: * Live Excel VBA Coding * What are Class Modules and why do I need them? * The 5 major advantages of using Class Modules that everyone should know. * How to use Class Modules with a Dictionary – so easy you’ll...
by Paul Kelly | | Data Structures VBA, Most Popular, Vault Video
Webinar Number: W0038 Arrays have been an important part of programming languages for a long time. In Excel VBA they are even more important as they have many important uses. The most powerful being when it comes to speeding up your VBA code exponentially. This...
by Paul Kelly | | Data Structures VBA, Most Popular, Vault Video
Webinar Number: W0037 It’s the start of a brand new year. And what better way to kick it off than with a live webinar on one of the most useful elements in VBA – The Excel VBA Dictionary. This webinar features: * The only VBA Webinar with Live Coding. * A...
by Paul Kelly | | Excel Specific, Most Popular, Vault Video
Webinar Number: W0030 Everybody has heard of Pareto’s 80/20 rule. 80% of your work comes from 20% of your efforts. In Excel VBA, 80 to 90% of your work will involve using Cells and Ranges. If you can master using this area of VBA then everything else you do will...
by Paul Kelly | | Copying Data, Most Popular, Vault Video
Webinar Number: W0027 This webinar features: Live coding Why you shouldn’t use a For Loop How to use Advanced filter correctly The common mistakes to avoid when using Advanced Filter A sample application using Advanced Filter functionality Proven principles used...