top of page

New video added to my YouTube channel!

It's been a while, but I've finally got around to adding another free video to my to my YouTube channel...



If you like this video, please hit the subscribe button!


This is a lecture I recorded in response to a student question in the VBA part of the course (Excel Essentials Level 3 - VBA Programming), which will teach you everything you will ever need to know about coding in VBA.


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.


So, this is another SQA (Student Questions Answered) lecture, this one from Neil...and it's a great one...


Neil works in the Energy industry. What Neil has is a HUGE data set with over 4000 lines across dozens of columns...with all the data laid out this way, it's a bit of a mess!


What we want to do, is analyse this data, and create a new workbook with multiple tabs, one for each unique MPAN (a 13 digit code), and return each of the 48 entries for all 365 days for that particular MPAN to the appropriate sheet laid out in a nic easy to read table!As always, we walk through the code line by line so we can see exactly how it is built, and what it is doing at each step...all simple steps, which, when combined can save hours of work!


So, all the code is here, and a complete walkthrough of how it works.


Enjoy!


Be sure to check out the other videos on the channel...there are quite a few!


Videos in the Level 1 series:



Videos in the Level 2 series:



Videos in the Level 3 series:




 
 
 

Comments


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