Because it is so easy to get lost in the muck, do you have any particular recommendations on some “decent” YouTube videos/channels to get at least some practice before taking lessons with a vocal coach?
The channel I've watched the most videos on is Chris Liepe's. The video "STOP Singing Vowels this way! (its making you tense)" was in my singing playlist:
Awesome question! It honestly was a combination of the official documentation, articles regarding various topics and StackOverflow. It also involved a ton of trial and error through the implementation of many, many projects.
This is a problem I have that I thought was near to impossible. I have a nightmare test case for you. I am a property manager of 1000 units. We have 40 properties each of which we track vacancies with a spreadsheet. They've got all relative property data on them as well. Let me know if you are interested.
My solution was to build a web app for this completely out of spreadsheet land. But I've got some other things to tackle first. Either way good luck!
Not affiliated with them at all, but airtable (www.airtable.com) might get you there faster (basically simple database modeling using a spreadsheet metaphor).