top of page

Yet another new video added to my youtube channel!

So, in keeping with my promise to myself that I would be more active in posting blogs and videos this year, I've just uploaded another great new video to my YouTube channel!


This one is special, as it's the first lecture I recorded in response to a student question in the VBA part of the course (Excel Essentials Level 3 - VBA Programming)


All the code is there on the screen for anyone to use, free, gratis, and for no charge :) Though I hope it will guide some of you to get the course...you should, it's really useful.


20,000 lines of data processed in just over 1 second! That's how fast this code runs :)


This is a lecture I created for a student who asked if it was possible to collect a massive amount of data into an array, but then ignore any bits of data in an exclusion list, and return everything else...simple, and did I mention this code will process 20,000 lines of data in 1 second?


Okay, you will find the full VBA code here, with a complete walkthrough of what each line does.


Enjoy!

 
 
 

1 Comment


Alexander Smith
Alexander Smith
Jun 29, 2023

Hi. Your video turned out to be cool and informative. I advise to your attention https://www.movavi.com/screen-recorder/ this is a free application that will allow you to make your lessons even more interesting and memorable for students.

Like

Purchase: Super Memory Essentials, Leadership and Management Essentials, and The Complete Excel Series (including Levels 1, 2 and 3) are available for purchase via the Udemy platform...just click " Buy Now..." or "Purchase Lifetime Access..."button and your special discount will be applied automatically. This option give you lifetime access, and is backed by the Udemy full 100% money back guarantee. So, if you're not entirely happy, you can get all of your money back, no questions asked.

All Courses are also available to UK students via https://www.reed.co.uk/courses/?keywords=alan%20jarvis

That sounds good, right? I thought so. So, choose your path to learning, and I'll see you in the course(s).

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon
  • YouTube

© 2023 by Personal Life Coach. Proudly created with Wix.com

bottom of page