How does anyone learn anything?

This is sorta a broad question, but how does anyone learn anything that is complicated or technical of nature? Even simple things are sprangly hard, like finding the correct formula to manipulate data in a spreadsheet a certain way. Online tutorial and guides may only answer some question or cover certain things and not be useful for specific problems. Overflow and exchange sites users get mad when questions are two trial or poorly worded, but part of the poor wording comes from the fact you don't have enough knowledge to be able to articulate the problem well. Some tutorials do not cover the level of abstraction you need answered and it is not possible to infer the correct answer. So how does one get out of this rut and actually become good at something when guides are so poor and ad-filled (Google is becoming increasingly useless as well for finding things due to spam) and people unhelpful? Other tutorials are useless and do not work when following steps.