YouTube is full of useful videos to teach you skills.
This playlist by QUT Tutor Owen Cafe has some great videos for learning Photoshop or Autocad. And there are many more! 
MakeUseOf publishes articles about how to do things - everything from Android to Tinder.
Other similar sites include:
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 Australia License.
QUT acknowledges the Traditional Owners of the lands where QUT now stands.